http://sqlserver365.blogspot.com/ 사이트 주인 아저씨 "Chris McGowan"가 연재식으로해서 Script 정보를 공유해주셨네요^^
괜찮은 스크립트들이 많이 보이는데. 예, DB 복구 할때 남은 시간 보기 등등....
SQLServer365 - AScriptADay.pdf
Table of Contents
A Script a Day Series ......................................................................................................... 3
Script 1 - Server volume to database file mapping ............................................................. 5
Script 2 – Database Mail Troubleshooting ......................................................................... 7
Script 3 - Live Change Data Edit Script Template ................................................................ 9
Script 4 – Estimated Time to Complete............................................................................ 11
Script 5 – Database Owner Permissions .......................................................................... 12
Script 6 – Drop And Create Database Snapshots .............................................................. 13
Script 7 – Memory Queries ............................................................................................. 19
Script 8 – Non Clustered Index Information ..................................................................... 24
Script 9 - Index Compression Estimations ........................................................................ 26
Script 10 – Hosts on vCentre ........................................................................................... 29
Script 11 – User Permissions By Database ....................................................................... 31
Script 12 – Granting Role Membership to All Principals ................................................... 33
Script 13 – Chris' Top Tip - Batches .................................................................................. 37
Script 14 – Upgrading to SQL 2012 .................................................................................. 38
Script 15 – Untrusted Check Constraints ......................................................................... 42
Script 16 – Restore Database .......................................................................................... 44
Script 17 – Possible Poor Indexes .................................................................................... 46
Script 18 – Viewing System Configuration ....................................................................... 47
Script 19 – Remove Virtual Subscriptions ........................................................................ 48
Script 20 – User Database VLF Count ............................................................................... 51
Script 21 – HAVING Clause .............................................................................................. 53
Script 22 – Backup Database ........................................................................................... 55
Script 23 – Find an Object in Job Steps ............................................................................ 56
Script 24 – Object Qualification ....................................................................................... 57
Script 25 – Performance Counters ................................................................................... 61
Script 26 – RESTART a Database Restore ......................................................................... 63
Script 27 – Missing Database Backups ............................................................................. 65
Script 28 – String Manipulation ....................................................................................... 67
Script 29 – The Importance of Being Idle ......................................................................... 68
다운로드는 아래에서 할 수 있어요.
http://www.fileswap.com/dl/FCg84QounN/SQLServer365_-_AScriptADay.pdf.html
'Transact-SQL' 카테고리의 다른 글
쥑이는 SCRIPT (0) | 2012.06.28 |
---|---|
sp_configure 마지막 변경일 (0) | 2012.05.15 |
최신 진단쿼리 (0) | 2012.05.08 |
SQL 로그인 계정 비밀번호 변경 일시 알아내기 (0) | 2012.04.10 |
Clustered Index Rebuild시 UNIQUIFIER Key 값이 변할까요 안 변할까요?? (0) | 2011.08.02 |