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.
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.