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 emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.