The DBA often needs to know when, how much and what kind of database file has changed its size. Also nice to know the amount of free space on the drive where the files are located databases.
2017-03-29 (first published: 2016-01-07)
2,032 reads
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
645 reads
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,008 reads
Find all stored procedures that use UDFs
2017-03-21 (first published: 2017-03-15)
444 reads
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
802 reads
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
2,166 reads
Inline function generating the set of numbers based on submitted parameters.
2017-03-09 (first published: 2017-02-16)
1,669 reads
2017-03-07 (first published: 2017-03-01)
1,097 reads
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
477 reads
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,148 reads