So a Twitter friend of mine @peschkaj tweeted this morning: “Just finished adding scripts to update stats and rebuild indexes after our nightly and weekly loads. Now on to… something else.” So I asked the question: “now the question is… did you update stats BEFORE or AFTER the index rebuild? ” He replied with the [...]
Posts under ‘Maintenance’
Cycling Error Logs
Have you ever gone into an envrionment looking for a problem and when you go to check out the error log you find that it hasn’t been rolled over for months or longer? (So annoying). Anyways… as one of my monthly scheduled jobs I rollover the Error Log using the sp_cycle_errorlog command. USE [master] GO [...]
Automatically Changing DTS Connection Strings
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 [...]
“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 [...]
