SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Michael Zhang

SQLServerCentral.com profile

   Items 1 to 6 of 6   

Know read and write ratio before you tune database performance

A script to get the user table query ratio and update radio,etc  Read more...
By Michael Zhang 2015/12/21 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 1,629 reads

Shrink database log file

How to reduce a database log file size? A script and process to help you.  Read more...
Rating: |  Discuss |   Briefcase | 1,892 reads

List file name, size of all databases

lists file name, size of all databases in sql server  Read more...
By Michael Zhang 2015/11/26 | Source: SQLServerCentral.com | Category: db name
Rating: |  Discuss |   Briefcase | 1,249 reads

Figure out recovery mode for each database

It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.  Read more...
By Michael Zhang 2015/11/23 | Source: SQLServerCentral.com | Category: database
Rating: |  Discuss |   Briefcase | 611 reads

Who are connecting to database and disconnect ...

When you want gain exclusive access to database in order to restore database  Read more...
By Michael Zhang 2015/11/06 | Source: SQLServerCentral.com | Category: who
Rating: |  Discuss |   Briefcase | 1,812 reads

Rebuild index selectively

Rebuild index is expensive most time. So you don't rebuild all index blindly.  Read more...
Rating: |  Discuss |   Briefcase | 1,735 reads
   Items 1 to 6 of 6