SQL Clone
SQLServerCentral is supported by Redgate
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...
Rating: |  Discuss |   Briefcase | 1,101 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,434 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,626 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...
Rating: |  Discuss |   Briefcase | 14,296 reads
   Items 1 to 4 of 4