2013.07.02

SQL

   

• Are my actual worker threads exceeding the sp_configure 'max worker threads' value?

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/07/01/are-my-actual-worker-threads-exceeding-the-sp-configure-max-worker-threads-value.aspx

   

• Myth Busting Query Optimisation

  http://blog.kejser.org/2013/07/01/myth-busting-query-optimisation/

   

• JULY 2013 ? MONTHLY SQL SERVER CHECKLIST

  http://www.jasonstrate.com/2013/07/july-2013-monthly-sql-server-checklist

   

• LAST WEEKS TOP "READING" LINKS #39

  http://www.jasonstrate.com/2013/07/last-weeks-top-reading-links-39

     

• July, the 31 Days of SQL Server DMO's - Intro

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/01/july-the-31-days-of-sql-server-dmo-s-intro.aspx

     

• July, the 31 Days of SQL Server DMO's ? Day 1 (sys.dm_exec_requests)

  http://sqlblog.com/blogs/tamarick_hill/archive/2013/07/01/july-the-31-days-of-sql-server-dmo-s-day-1-sys-dm-exec-requests.aspx

  와우,, dmo 시리즈가 시작되네요^^

  sys.dm_exec_requests 현재 세션에 대한 핸들 정보, 상태 등등.. 마지막 sql text까지,,, 대기 상태 등등 많은 정보를 볼 수 있는 dmv ㅎㅎㅎ

     

• Updatable columnstore index, sp_spaceused and sys.partitions

  http://sqlblog.com/blogs/michael_zilberstein/archive/2013/07/01/49903.aspx

   

• SQL Server CREATE TABLE syntax diagrams

  https://www.simple-talk.com/sql/t-sql-programming/sql-server-create-table-syntax-diagrams/

  정말 대단하신 분이시네요..... CREATE TABLE 다이어그램 그림과 쉽게 설명 표현을 해주셨네요.
   

  

     

• New DMV… not yet

  http://sqlblog.com/blogs/michael_zilberstein/archive/2013/07/01/49898.aspx

  sys.dm_exec_query_profiles 기대했던 dmv가 아직 패치되지 않았네여..

     

• June 2013 release of SSDT contains a minor bug that you should be aware of

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/07/01/june-2013-release-of-ssdt-contains-a-minor-bug-that-you-should-be-aware-of.aspx

     

• Log Shipping Lite with PowerShell

  http://www.sqlservercentral.com/articles/powershell/99832/

     

• xp_cmdshell for Non-System Admin Individuals

  http://www.databasejournal.com/features/mssql/xpcmdshell-for-non-system-admin-individuals.html

     

• Handling Windows Processes using Windows PowerShell for SQL Server

  http://www.mssqltips.com/sqlservertip/2966/handling-windows-processes-using-windows-powershell-for-sql-server/

     

Other

   

• tpcc-mysql: Simple usage steps and how to build graphs with gnuplot

  http://www.mysqlperformanceblog.com/2013/07/01/tpcc-mysql-simple-usage-steps-and-how-to-build-graphs-with-gnuplot/        

  tpcc mysql을이용해서 benchmark 순서를 보여주네요... 따라해보면 될것 같기도 하고 ...