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
Kit gets the potatoes fast, but every burner is busy, so the order waits on the rail while the potatoes grow bored little faces and Casey hangs a second stopwatch. Quinn sums it up: "Ready to cook, stuck in line. That's a signal wait!"

Signal Wait Stats: CPU Waits vs Resource Waits

February 2, 2011
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Wait Stats

Signal wait stats show how long a SQL Server query sat ready to run, waiting in line for a CPU. On Night 2 at the Clipboard Diner, the potatoes arrive on time and the Garden Hash waits anyway. Then two queries split your server’s waits into the CPU part and the resource part.

Read More
A postcard says the food critic is coming, the busy kitchen can't explain its late plates, and Casey hangs up a new clipboard while Ace, Quinn and even the jukebox lean in. Casey asks, "New question. What are we waiting for?"

Wait Stats Explained: SQL Server as an All-Night Diner

February 1, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Performance, SQL Wait Stats

Wait stats explained with one picture: SQL Server is an all-night diner, and every query is an order ticket that waits for something. Meet the Clipboard Diner, its owner Casey, the cooks and booth 7. Then count the burners and cooks on your own server with one query.

Read More
Casey times one Garden Hash: Ace stalls at an empty potato bin, and by the time Quinn serves the plate, a cobweb has grown on the trucker's coffee cup. Casey reads the stopwatch: "Cooking: four minutes. Waiting: nine."

Wait Stats Basics: How Waits Work in SQL Server

February 1, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Wait Stats

Wait stats basics start with one idea: a query in SQL Server is always either working or waiting. On Night 1 at the Clipboard Diner, one plate of Garden Hash shows the three states every query moves through. Then two queries show the same thing on your own server.

Read More
SQL SERVER - What is Fill Factor and What is the Best Value for Fill Factor

SQL SERVER – What is Fill Factor and What is the Best Value for Fill Factor

January 31, 2011
Pinal Dave
SQL Performance
SQL Index

What is fill factor and what is the best value for fill factor? I explain how it controls the space used on leaf-level pages and why the default is 100.

Read More
SELECT NEXT VALUE FOR Seq As SeqNumber.

SQL SERVER – Denali – SEQUENCE is not IDENTITY

January 30, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

SEQUENCE is not IDENTITY. A reader asked about the difference: identity belongs to a single column, while a sequence does not depend on any table.

Read More
SQL SERVER - Denali - Introduction to SEQUENCE - Simple Example of SEQUENCE

SQL SERVER – Denali – Introduction to SEQUENCE – Simple Example of SEQUENCE

January 29, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts

A quick introduction to SEQUENCE in SQL Server Denali: create a sequence with start, increment and max values, then fetch numbers with NEXT VALUE FOR.

Read More
Gouache painting: two identical toy trains with red engines and blue carriages standing on one wooden track

Text Equality: Trailing Spaces Can Compare as Equal

January 28, 2011
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Datatype, SQL Server

Text equality can match different stored strings. Check byte length and complete representation when exact identity belongs to the contract.

Read More
SQL SERVER - What is a Technology Evangelist?

SQL SERVER – What is a Technology Evangelist?

January 27, 2011
Pinal Dave
Personal
Database, MVP

What is a technology evangelist? Someone who spreads the news about new products, but unlike a salesperson, stays brutally honest even if it costs a sale.

Read More
A receiving trough distributes small pieces through several separate channels into independent trays.

SQL SERVER – Reducing Page Contention on TempDB

January 26, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB

Page Contention on TempDB needs an identified allocation wait and server version. I check both before recommending legacy trace flags.

Read More
SQL SERVER - Denali - Clipboard Ring - CTRL+SHIFT+V

SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V

January 25, 2011
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

SQL Server Denali brings the clipboard ring from Visual Studio to SSMS. Copy a few items, then press CTRL+SHIFT+V to cycle through what you copied.

Read More
Previous 1 … 429 430 431 432 433 434 435 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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