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
Gouache painting of a single millstone with a line of grain sacks waiting and the first sack in vermilion

Signal Waits: Detect CPU Pressure With Wait Statistics

August 12, 2019
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Wait Stats

Signal waits are the part of every wait that a task spends in the queue for a free CPU. This post ranks the wait types by signal time, shows why timer waits ruin the total share, and samples the signal share into a small table so a whole working day can be read interval by interval.

Read More
The first group of towels is set aside while the remaining sequence stays on its shelf

How to Skip Top N Rows in SQL Server? – Interview Question of the Week #237

August 11, 2019
Pinal Dave
SQL Interview Questions and Answers
Ranking Functions, SQL Function, SQL Paging, SQL Scripts, SQL Server

Question: How to skip top N Rows in SQL Server and retrieve the rest of the rows? Answer: I had asked the above question in one of the interviews last week.

Read More
Gouache painting of three garden beds in a row with a hoe whose grip is vermilion

Delete the Wrong Row: A Cheap Answer That Passes the Test

August 8, 2019
Pinal Dave
SQL Puzzle
SQL Delete, SQL Performance, SQL Scripts

A cheap answer to the multiple table delete puzzle reads only 6 pages and passes the check. It can still delete the wrong row. This post shows the answer, asks you to find the row it removes by mistake, and fixes it with a delete that costs 5 reads.

Read More
Gouache painting of a crowd of small rowboats at a narrow quay with one vermilion boat at the end

Max Worker Count: Why Typing 10000 Slowed a Server

August 7, 2019
Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL DMV, SQL Scripts, SQL Server Configuration

Max worker count looks like a speed dial but behaves like a safety limit. A client typed 10000 on an 8 processor server and slowed it, and a reset to 0 fixed it in minutes. Two read-only queries show your value and whether workers run short.

Read More
Gouache painting of a shelf of sorted pears with the first three covered and the next four in a vermilion basket

OFFSET FETCH in SQL Server: Get Rows 21 to 30 After ORDER BY

August 6, 2019
Pinal Dave
SQL Tips and Tricks
SQL Order By, SQL Paging, SQL Scripts, SQL Server

OFFSET FETCH reads a block of rows from the middle of a sorted result. The demo returns rows 21 to 30, builds pages from a page number and measures why deep pages cost more. A seek based alternative reads the same two pages every time.

Read More
Gouache painting of a meadow with one wide worn path and a vermilion stile at its start

Frequently Run Stored Procedures: Find Them in the Cache

August 5, 2019
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL CPU, SQL Scripts, SQL Stored Procedure

Frequently run stored procedures leave an execution count in the plan cache. A tested demo ranks three procedures by count, reads and calls per minute. It also shows what the cache forgets and when to use Query Store instead.

Read More
A small boat leaves a visible wake beyond its old mooring

How to Write in Text File from T-SQL in SQL Server? – Interview Question of the Week #236

August 4, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL String

Question: How to Write in Text File from T-SQL in SQL Server?
The question above was actually asked in an interview and also was not asked in the same word.

Read More
Previous 1 … 67 68 69 70 71 72 73 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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