Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.
Microsoft Dynamics CRM – Max Degree of Parallelism Settings and Slow Performance
After a SQL Server upgrade, a client’s Microsoft Dynamics CRM showed slow pages and white screens. Here is how Max Degree of Parallelism settings played a part.
Practical Real World Performance Tuning – Reviews and Feedback
My online class Practical Real World Performance Tuning now has 37 reviews. Here I share a few of the reviews and feedback from people who took the class.
Right-Sizing SQL Server: Reading CPU and Memory Use Before Consolidation
Base right-sizing SQL Server on sampled CPU, memory pressure, buffer use and interval I/O, then compare peaks across a full business cycle.
SQL SERVER – Applying NOLOCK to Every Single Table in Select Statement – SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Need NOLOCK on every table of a huge stored procedure? There is a simpler way: SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED once at the top.
SQL SERVER- High CPU and Transaction Type WorkFileGroup_fake_worktable and Workfile
High CPU on a client’s server led me to WorkFileGroup_fake_worktable and Workfile, something I found no hint about online. Here is the cause I found.
Practical Real World Performance Tuning – Games , Interaction and Feedback
What makes my online class Practical Real World Performance Tuning different? Let me show you the games, the interaction and the feedback from students so far.