What are hints in SQL Server and when should you use them? Understanding table hints with examples, plus a word of caution about overriding the optimizer.
SQL SERVER – Size of Index Table – A Puzzle to Find Index Size for Each Index on Table
sp_spaceused shows the total index size of a table. My puzzle for you: write a query that adds the size of each index to the sys.indexes list.
SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren
Ola Hallengren’s free scripts for backup, integrity check and index optimization in SQL Server 2005 and 2008, with notes from Ola on how they work.
SQLAuthority News – Notes of Excellent Experience at SQL PASS 2009 Summit, Seattle
My notes from SQL PASS 2009 Summit in Seattle: why I went, from networking to putting faces to names, and links to my posts from all four days.
SQL SERVER – Whitepaper Consolidation Using SQL Server 2008
Allan Hirt’s white paper on consolidation using SQL Server 2008: gathering the facts, then planning, building and running a consolidated environment.
Storage Settings That Matter for SQL Server
Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.
SQL SERVER – Policy Based Management – Create, Evaluate and Fix Policies
A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.