After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed. Let us fix the error in this blog.
SQL SERVER – Introduction to SQL Azure Database Throttling
On-premises SQL Server queues extra requests, but Azure works differently. Here is an introduction to SQL Azure Database Throttling and what it means for you.
SQL SERVER 2016 – STRING_SPLIT Function Performance Comparison – Notes from the Field #118
Splitting strings once meant temp tables or CROSS APPLY. In Notes from the Field #118, Kathi Kellenberger compares STRING_SPLIT performance in SQL Server 2016.
Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?
Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.
Generating Test Data That Behaves Like the Real Thing
Make test data generation reflect skew, row width, missing values, and key relationships so your SQL Server experiments expose realistic plan risks.
Interview Question of the Week #061 – How to Retrieve SQL Server Configuration?
A common interview question: how do you retrieve SQL Server configuration? Right-click and Properties is not enough. Here is the better answer.