Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.
geometry STTouches: A Shared Boundary Is Not Interior Overlap
geometry STTouches tests whether shapes meet without their interiors intersecting. I keep that predicate separate from a general intersection check. Sharing an edge and sharing an area are different spatial relationships.
SQL SERVER – Business Intelligence – Aligning Business Metrics
Managers want timely, visual, personal information for faster decisions. How Business Intelligence helps with aligning business metrics across a company.
CAST to date: Remove Time Without Moving the Day
CAST to date keeps the calendar day from a typed datetime2 value. The example preserves the original time and contrasts actual removal with a display that merely hides it.
LEAD Defaults: Missing Rows Differ From NULL Values
LEAD defaults handle a missing following row. Keep that boundary separate from a present row containing NULL and choose replacement policy explicitly.
SQL SERVER – White Papers – Consolidation Guidance for SQL Server – Consolidation Using SQL Server 2008
Two white papers by Allan Hirt: Consolidation Guidance for SQL Server, which compares three consolidation options, and Consolidation Using SQL Server 2008.
SQLAuthority News – Notes from TechDays 2009 at Infosys, Bangalore
My notes from TechDays 2009 at Infosys, Bangalore on Nov 16-17: the largest Microsoft tech event at Infosys, with about 2,500 attendees in person and online.