http://www.sqlmag.com/authors/author/author/5059106/rss/5059106en-USFri, 25 May 2012 10:38:01 GMTFri, 25 May 2012 10:38:01 GMThttp://www.sqlmag.com/article/sql-server-2008/dynamically-create-maintain-table-partitions-141273
By Saravanan Radhakrishnan
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 dynamically.]]>Saravanan RadhakrishnanThu, 26 Jan 2012 08:00:00 GMThttp://www.sqlmag.com/article/sql-server-2008/dynamically-create-maintain-table-partitions-141273http://www.sqlmag.com/article/store-procedures/stored-procedure-provides-update-statistics-report
By Saravanan Radhakrishnan
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.]]>Saravanan RadhakrishnanThu, 25 Mar 2010 08:01:00 GMThttp://www.sqlmag.com/article/store-procedures/stored-procedure-provides-update-statistics-reporthttp://www.sqlmag.com/article/store-procedures/update-the-statistics-on-recently-modified-tables-only
By Saravanan Radhakrishnan
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 where the data has been recently changed, saving time and resources.]]>Saravanan RadhakrishnanThu, 25 Mar 2010 08:01:00 GMThttp://www.sqlmag.com/article/store-procedures/update-the-statistics-on-recently-modified-tables-onlyhttp://www.sqlmag.com/article/tsql3/t-sql-statement-tracks-transaction-less-dates
By Saravanan Radhakrishnan
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 it off.]]>Saravanan RadhakrishnanMon, 12 Oct 2009 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/t-sql-statement-tracks-transaction-less-dates