This script will help in identifying file size of primary file, log file and all partition files. This include free space available and space used for each file in a database.
2014-03-03 (first published: 2014-02-20)
1,241 reads
This is script is useful when you are short of space on a drive and you need to know how much space can you get shrinking your databases
2014-02-28 (first published: 2012-11-08)
2,727 reads
Create Copy of database with new name.
2014-02-27 (first published: 2014-02-11)
1,874 reads
Get the list of the tables on the server which dont have the clustered index.
2014-02-24 (first published: 2014-02-17)
1,359 reads
Grabs information about what reports in SSRS are scheduled, when are they due to be sent out, report parameters and any errors in the last run etc.
2014-02-21 (first published: 2010-08-18)
2,552 reads
This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.
2014-02-17 (first published: 2011-07-28)
1,697 reads
This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)
2014-02-12 (first published: 2012-05-21)
4,035 reads
This will list the columns used by the update statement inside a trigger. More generic and useful for columns > 32.
2014-02-10 (first published: 2012-06-06)
1,556 reads
Convert Months,Days,ShortMonths to Different Langauges with out sql server set language function can be used in views tables and stored procedures also includes proper case conversion
2014-02-03 (first published: 2014-01-21)
991 reads
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
1,959 reads