- Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads
- SQL Server Perfmon (Performance Monitor) Best Practices
- Why You’re Tuning Stored Procedures Wrong (the Problem with Local Variables)
- Improving Query Performance by using correct Search Arguments
- Fixing Cache Bloat Problems With Plan Guides and Forced Parameterization
- Most SQL users flunk performance test
- SQL Server Isolation Levels By Example
- How to Make Scalar UDFs Run Faster
- What MAXDOP setting should be used for SQL Server
- SQL Server 2014 Real Time Query Monitoring
- Avoiding Sorts with Merge Join Concatenation
- SQL SERVER – SSMS: Resource Locking and Object Execution Statistics Report
- Great new Microsoft KB article: Recommended SQL Server Updates and Trace Flags
- What Effect Does Persisting a Computed Column Have in SQL Server?
- Using PerfMon for SQL Server Reporting Services Performance Management
- Explanation of SQL Server IO and Latches
- David Klee Virtualization Articles
- Testing SQL Server Query Performance Using Different Levels of Parallelism
- Size does matter: 10 ways to reduce the database size and improve performance in SQL Server
- My Queries For Top 20 Resource Hogs
- Checking the Plan Cache Warnings for a SQL Server Database
- Never Ignore a Sort Warning in SQL Server
- Performance Tuning SQL Server Change Tracking
- Three Easy Tweaks to Tune Up Your SQL Server
- SQL Server Memory
- The Halloween Problem – Part 1
- Why Halloween slowed your queries
- Optimizing Update Queries
- Performance Surprises and Assumptions : DATEADD()
- Query tuning 101: Problems with IN ()
- Inside The Storage Engine: GAM, SGAM, PFS and other allocation maps
- Cheat Sheet: How to Configure TempDB for Microsoft SQL Server
- Frequently Asked Questions About TempDB
- SQL Server 2008/2008 R2: Move tempdb to Improve Performance
Query Plans
- Performance Tuning the Whole Query Plan
- Improved diagnostics for query execution plans that involve residual predicate pushdown in SQL Server 2012 (see also this and this article)
- SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches (video, 70 minutes; also see demo files and comments here)
- Understanding and Using Parallelism in SQL Server
- Forcing a Parallel Query Execution Plan
- Dynamically Query a 100 Million Row Table-Efficiently
- Optimizing T-SQL queries that change data
Extended Events
- Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events
- Identifying large queries using Extended Events
- Finding One Problem Query With Extended Events
Statistics
- SQL Server Statistics Questions We Were Too Shy to Ask
- Statistics in SQL Server 2014
- Are “bad” statistics the reason my query is slow?
- SQL Server 2014 Incremental Statistics
RBAR (Row By Agonizing Row)
- The “Numbers” or “Tally” Table: What it is and how it replaces a loop
- Cursor-Killing: Accessing Data in the Next Row
- Hidden RBAR: Counting with Recursive CTE’s
Parameter Sniffing
- “OR” pattern causing indexing scans in parameter based queries
- When Parameter Sniffing Caused Deadlocks
- Does Query Store’s “Regression” Always Catch Nasty Parameter Sniffing?
Comments
T-SQL Tuning — No Comments
HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>