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
A blank clipboard and small hourglass sit beside neatly arranged tools on a workbench.

What to Collect When SQL Server Is Slow

August 26, 2012
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.

Read More
A pasta roller holds fixed rollers while dough must pass through successive connected stages

INNER HASH JOIN: Why a Table Join Hint Also Fixes Join Order

August 11, 2012
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Joins, SQL Performance

A join hint in the FROM clause quietly fixes the join order. I show the warning, three plans side by side, and the softer query-level alternative.

Read More
A bicycle wheel leans on a wall with one bent spoke, while loose spokes and a spoke key lie on the floor

Comparing Session SET Options Between SSMS and the Application

August 6, 2012
Pinal Dave
SQL Performance
SQL Cache, SQL Connection, SQL DateTime, SQL Server Management Studio

Fast in SSMS, slow in the app? The query may be fine and the connection settings different. Here is how to check, with nothing to set up.

Read More
A conveyor belt of identical parcels beside a single hand trolley carrying one parcel

What Is a Cursor in SQL Server, and When to Avoid One

July 31, 2012
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Scripts, SQL Server

A cursor in SQL Server took 260 milliseconds where one SELECT took 4. Why the gap exists, how to turn a loop back into a set, and the three cases where a cursor really is the right answer.

Read More
A dustpan collects spilled grain beside one of two intact neighboring strips

Exchange Spill: When Parallel Streams Write to tempdb

July 24, 2012
Pinal Dave
SQL Performance
Execution Plan, Parallel, SQL Extended Events, SQL TempDB

Tempdb writes during a parallel query, with no sort warning in sight? Here is a demo that spills every time, and how to find the operator.

Read More
ntfs

SQL SERVER – NTFS File System Performance for SQL Server

July 6, 2012
Pinal Dave
SQL Performance
SQL Server

A reader asked how to tune the NTFS File System for an 80 GB SQL Server box. I start a list of best practices, like disabling disk indexing; help me finish it.

Read More
SQL SERVER - Video - Beginning Performance Tuning with SQL Server Execution Plan

SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan

June 13, 2012
Pinal Dave
SQL Performance
Execution Plan, SQL Server

Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.

Read More
Previous 1 … 73 74 75 76 77 78 79 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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