Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
Replacing a Cursor With a Set-Based Query
Replacing a cursor with one set-based update can simplify row processing; this worked example shows correctness checks and fair timing.
SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
Three ways to send query results to text, grid or file in SSMS: the shortcuts CTRL+T, CTRL+D and CTRL+SHIFT+F, the toolbar, or the menu bar.
SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
Stop building ORDER BY strings and running them with EXEC in a stored procedure. I show how a CASE statement in ORDER BY sorts by a variable without dynamic SQL.
SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
My summary of two Microsoft white papers: the top 10 best practices for Analysis Services query performance, and Partial Database Availability with filegroups.
SQL SERVER – 2005 – Features Comparison Chart
What are the differences between SQL Server 2005 editions? I point you to the Microsoft features comparison chart for Express, Workgroup, Standard and Enterprise.
SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
A simple Best Practices Analyzer Tutorial with images, run on an old laptop with SQL Server 2005 and many planted issues, to help you start using BPA.