SQL
- Are my actual worker threads exceeding the sp_configure 'max worker threads' value?
- 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
- July, the 31 Days of SQL Server DMO's ? Day 1 (sys.dm_exec_requests)
와우,, 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
- 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
Other
- tpcc-mysql: Simple usage steps and how to build graphs with gnuplot
tpcc mysql을이용해서 benchmark 순서를 보여주네요... 따라해보면 될것 같기도 하고 ...
'SQLTAG Daily Links' 카테고리의 다른 글
2013.07.05 (0) | 2013.07.05 |
---|---|
2013.07.03 (1) | 2013.07.03 |
2013.07.01 (0) | 2013.07.01 |
2013.06.28 (0) | 2013.06.28 |
2013.06.27 (0) | 2013.06.27 |