By Saravanan Radhakrishnan, 01/26/2012
Loading new data and purging old data from a table can take a lot of time if a large amount of data is involved. Here's an elegant partition solution that loads and purges data ...
By Saravanan Radhakrishnan, 03/25/2010
With this stored procedure, you can find out the last time the UPDATE STATISTICS statement was run against all the table indexes in a database.
By Saravanan Radhakrishnan, 03/25/2010
Running UPDATE STATISTICS is important but can be time-consuming, especially if you have very large tables. Here's a stored procedure that updates statistics only on those tables ...
By Saravanan Radhakrishnan, 10/12/2009
A DBA was asked to produce a list of dates in which there were no transactions from a database that included only the dates in which there were transactions. Here's how he pulled ...