Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Sylvia Moestl Vasilik

SQLServerCentral.com profile

   Items 1 to 4 of 4   
 

Mask PII data (Personally Identifiable Information)

When creating a backup that will be restored to a development database, you may need to mask PII information. This script will help you with that.  Read more...
By Sylvia Moestl Vasilik 2011/06/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 1,064 reads

Easily delete database objects

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user  Read more...
Rating: |  Discuss |   Briefcase | 1,410 reads

Easily calculate the size of your tables

This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)  Read more...
By Sylvia Moestl Vasilik 2009/05/04 | Source: SQLServerCentral.com | Category: table size
Rating: |  Discuss |   Briefcase | 1,576 reads

An easy way to track the growth of your database

This query gives you an idea of the growth of your database over time.  Read more...
By Sylvia Moestl Vasilik 2013/11/01 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 14,229 reads
   Items 1 to 4 of 4