Compare SQL Server encryption options by the threat they address, where keys live, what applications must change, and how recovery is tested.
SQL SERVER – Understanding Table Hints with Examples
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.
smallmoney: Four Fractional Digits Need a Contract
smallmoney stores a bounded numeric amount with four fractional digits. These explicit conversions show retained and changed digits without making a financial storage recommendation.
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.