'sql script'에 해당되는 글 1건

  1. SQLServer365 A Script A Day

SQLServer365 A Script A Day

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