SQL Server 2005 Service Pack 3 BETA is now available. THIS IS A BETA so use with caution. I would advise against applying it to any production servers until the official release of Service Pack 3 and you have fully tested it in your DEV and UAT environments. Download SQL 2005 SP3 BETA Release Notes
Posts Tagged ‘SQL 2005’
“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 [...]
