Policy Management, added in SQL Server 2008, is an underappreciated feature. Here is an introduction to its building blocks and how the pieces fit.
SQL SERVER – What is Filtered Statistics?
Filtered statistics, added in SQL Server 2008, help the optimizer estimate rows when data is correlated. Here is a small demo with Employee and Sales tables.
SQL SERVER – Transaction Log Backup Failing After Rebuilding Database Log File
A DBA at a Delhi conference asked why the transaction log backup kept failing after rebuilding the database log file. Here is why it happens.
Interview Question of the Week #014 – How to DELETE Duplicate Rows
Delete duplicate rows with a ROW_NUMBER CTE, preview the duplicate groups, choose a survivor, and prevent recurrence with uniqueness.
SQL SERVER – An Observation SET vs SELECT in T-SQL
SET vs SELECT: both can assign a value to a variable, but they behave differently when a query returns many rows. Here is a simple example.
SQL SERVER – Log Shipping – Sharing Tab Missing in Folder Properties
Setting up Log Shipping and found the Sharing tab missing in folder properties? A reader hit this, and here is how to get the Sharing tab back.
SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074
Agile builds software in small, time boxed steps. In Notes from the Field #074, Stuart Ainsworth shares stories about 3 common mistakes of Agile Development.