Month: February 2019

First published on MSDN on Jan 01, 2013 I wanted to make this post because I think the term “recompile” is used to describe a few slightly different concepts in SQL Server. Here are three uses of the term “recompile”:
1. WITH RECOMPILE or OPTION (RE… Continue reading Recompile Meditation: Is a plan always cached?→

First published on MSDN on Apr 02, 2013
Recently, I had the opportunity to present table and index partitioning and a follow up question came up regarding partitioning a table with unique constraint/index. The Special Guidelines for Partitioned Ind… Continue reading Dealing with Unique Columns when Using Table Partitioning→

First published on MSDN on Apr 04, 2013 I was approached recently with the following request: “Hey Joseph, we think that this query is performing horribly. Here is the XML query plan. Can you tell us what is going on?” My first reaction was to start … Continue reading Finding Performance Metrics (Duration, CPU, Reads) based on XML Query Plan QueryHash and QueryPlanHash→

First published on MSDN on Apr 04, 2013
Many companies rely on IO stress-testing tools like SQLIO Disk Subsystem Benchmark Tool (aka SQLIO) to perform an I/O subsystem validation before they deploy SQL Server in production. Over the years, I have … Continue reading Choosing what SQLIO tests to Run and Automating the Tests→

First published on MSDN on Apr 15, 2013
 
Question : My customer wants to store data other than English in his table, using the Latin alphabet. For example, he has Spanish, German, Portuguese and English data. He wants to be able to return al… Continue reading Dealing with Diacritics in Your Data→

First published on MSDN on Apr 15, 2013
 
 
I know this is a fairly common problem and there might be multiple solutions out there, but I figured adding another one may not hurt.
 
An application I was supporting recently, was leading… Continue reading Finding Large Transactions that Bloat Your Transaction Log→

First published on MSDN on Apr 18, 2013 Somebody approached me with this error, asking whether this is by design or caused by certain conditions.
Msg 25023, Level 16, State 1, Server <removed name>, Procedure sp_MSaddexecarticle, Line 192 Stor… Continue reading Procedure Execution with Table-Valued Parameters Involved Cannot be Replicated→

First published on MSDN on Apr 24, 2013
 
 
Somebody approached me recently with a question like this:
 
Question : We’ll be hosting our existing application in one data center, but we’ll be setting up 2 more instances in two differ… Continue reading Meditation: Replicate Data from Multiple Instances into a Single Reporting Database→