A full walk through Policy Based Management in SQL Server 2008: the policy framework, facets and conditions, then creating, evaluating and fixing policies.
SQL SERVER – Disable CHECK Constraint – Enable CHECK Constraint
Need to disable CHECK constraint validation for a bulk load? Here is how, and how to enable it again with WITH CHECK CHECK CONSTRAINT, the syntax with CHECK twice.
geometry STSymDifference: Keep the Parts Outside the Overlap
geometry STSymDifference keeps points belonging to either input while excluding their shared portion. I use it when both sides’ exclusive regions matter. Directed subtraction would answer a different question about only one side.
Derived Table, CTE or View: Choose the Scope
A derived table, CTE and view can express the same grouped result while offering different scopes. Compare complete outputs with duplicates and NULLs, then choose a statement-local expression or a saved definition for the task.
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
Seek Predicate beats Predicate. An observation from a query optimization project on removing key lookup and how datatypes decide which one you get.
SQL SERVER – Stored Procedure are Compiled on First Run – SP taking Longer to Run First Time
Why does a stored procedure take longer the first time? Stored procedures are not pre-compiled; each one is compiled on first run and cached after that.
SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
A Microsoft white paper on data compression in SQL Server 2008: strategy, capacity planning, best practices, and the trade-off of I/O savings for CPU.
SQLAuthority News – SQL PASS Summit, Seattle 2009 Day 4
PASS Summit Seattle 2009 Day 4: Kevin Kline honored for 10 years of service, a great keynote by Dr. David DeWitt, eight meetings and lots of swag.
SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
My third day at SQL PASS Summit 2009: a late start after the parties, breakfast with Solid Quality Mentors and an entertaining keynote full of demos.
SQLAuthority News – SQL PASS Summit, Seattle 2009 Day 2
PASS Summit Seattle 2009 Day 2 began with Twitter bingo, then breakfast with SQL friends, a karma lesson about a borrowed pen, and keynote notes.