This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Script: Finding queries without JOIN Predicates

SQL SERVER – Script: Finding queries without JOIN Predicates

August 26, 2015
Pinal Dave
SQL Performance
SQL Scripts

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.

Read More
Gouache painting of an old mossy watermill wheel on a stream with a fresh red paddle waiting on the bank

Analysis Services Performance Monitoring: What to Measure

August 13, 2015
Pinal Dave
SQL Performance
Notes from the Field, SQL Analysis Services, SQL Monitoring

Analysis Services performance monitoring starts with one habit: take measurements before users complain. This guest post by Bill Anton explains what to measure for processing and for queries, and why the OLAPQueryLog table tells only part of the story.

Read More
Gouache painting of four wheelbarrows in parallel each carrying part of a pumpkin pile, one pumpkin painted red

How to Find Queries Running in Parallel in SQL Server

July 25, 2015
Pinal Dave
SQL Performance
Parallel, SQL CPU, SQL Scripts, SQL Server

To find queries running in parallel, read max_dop and the CPU to elapsed ratio from the query stats view, then confirm with the plan XML. This post tests both on a two million row table. It also explains why the same query stays serial until its cost passes the threshold.

Read More
SQL SERVER - Querying Performance Counters from SQL Server

SQL SERVER – Querying Performance Counters from SQL Server

July 14, 2015
Pinal Dave
SQL Performance
SQL Scripts

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.

Read More
SQL Server DTA tuning options.

SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

May 11, 2015
Pinal Dave
SQL Performance

An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.

Read More
SQL SERVER - Using "High Performance" Power Plan for SQL Server

SQL SERVER – Using “High Performance” Power Plan for SQL Server

April 27, 2015
Pinal Dave
SQL Performance
SQL CPU, 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.

Read More
A waffle iron making identical waffles beside a stack of uneven pancakes

Forced Parameterization: When It Cuts CPU and When It Hurts

April 17, 2015
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, SQL CPU, SQL Performance, SQL Server

Test forced parameterization against ad hoc compile pressure with query_hash counts, compilations per second, CPU, and parameter sensitivity.

Read More
Previous 1 … 58 59 60 61 62 63 64 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com