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.
SQL SERVER – Sharepoint Resource Available for SQL Server
A quick SharePoint resource list: recently updated Microsoft tools for SQL Server and SharePoint, like the External Collaboration Toolkit and Reporting Services Add-in.
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
This is very short note announcing details about my course details for ‘Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning’.
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.