During a code review I spotted a query missing its join condition. Here is a script for finding queries without JOIN predicates in SQL Server.
SQL SERVER – How to Find If Queries are Running in Parallel?
Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.
SQL SERVER – Querying Performance Counters from SQL Server
When SQL Server is slow, where do you start? I look at querying performance counters from inside SQL Server as a quick way to see what is going on.
SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)
An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.
SQL SERVER – Using “High Performance” Power Plan for SQL Server
A simple, often missed setting on a new server: switch Windows to the High Performance Power Plan. Here is why it matters for SQL Server and where to set it.
Forced Parameterization: When It Cuts CPU and When It Hurts
Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.
SQL SERVER – 8 Performance Related Articles on Logical Reads
Here are my 8 favorite articles on SQL Server performance published on Logical Reads, from DMVs in SQL Azure to troubleshooting high CPU issues.