If you’ve ever done a migration or consolidation on a SQL Server 2000 server that uses DTS Packages you probably ran into the task of needing to open each DTS Package and change the connections within that package to a new server (this is assuming the environment does NOT make use of config or ini [...]
Posts from ‘November, 2008’
When did the CHECKPOINT run?
A fellow DBA questioned some strange occurrences in their environment and wanted to rule out that a checkpoint did not cause this problem. They wanted to see when the last time CHECKPOINT ran. The question was raised: Is there a way to see when the last checkpoint was run? By default the answer is no… [...]
“Smart” Reindexing (SQL Server 2005, 2008)
Something that still baffles me about SQL Server is that even in SQL Server 2008 there is no maintenance plan option to do reindexing properly. The key word in that sentence is properly. SQL Server gives you an all or nothing approach to indexing. You have 2 options: 1) Rebuild Indexes 2) Reorganize Indexes (Great [...]
