SQLServerCentral - Scripts by Sylvia Moestl Vasilik

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 | 973 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...

By Sylvia Moestl Vasilik 2010/05/26 | Source: SQLServerCentral.com | Category: drop database objects

Rating:

|

Discuss |

Briefcase | 1,394 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,512 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 2011/05/20 | Source: SQLServerCentral.com | Category: backup / restore

Rating:

|

Discuss |

Briefcase | 12,930 reads