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 colorful paper chain along a kitchen window with one gap in the loops, scissors on the sill

A Daily Streak in SQL: Finding the Longest Run of Consecutive Days

October 29, 2019
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL DateTime, SQL Scripts, SQL Server

Find consecutive days with gaps and islands, rank the longest streak per user, and define a current streak using the right business date.

Read More
Gouache painting of five matching tea cups in a row with the second from the left in vermilion

Get the Second Row From a Table in SQL Server

October 28, 2019
Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Function, SQL Scripts, Temp Table

To get the second row from a table, first decide what second means, because a table has no order until you give it one. This post builds a small demo and compares ROW_NUMBER, OFFSET and FETCH, and TOP inside TOP. It also covers every second row, the second row in each group, ties and the cost of each method.

Read More
A cabinet's contents are visible through glass while a locked door prevents additions

Why Query Store Actual Operation Mode is Not Same as Requested? – Interview Question of the Week #248

October 27, 2019
Pinal Dave
SQL Interview Questions and Answers
Query Store, SQL Scripts, SQL Server, SQL Server Configuration

Question: Why Query Store Actual Operation Mode is Not Same as Requested? Query Regression (poor performing queries, once working great)

Read More
Gouache painting of a mountain stream blocked by one large vermilion stone with water backing up behind it

Session Wait Stats: Find the Query Behind a Wait Type

October 26, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts, SQL Server, SQL Wait Stats

Session wait stats tell you which session produced a wait type, and the input buffer tells you which query that session ran. This post shows how to see who waits right now, how to read the wait history of each session, and how to join them to the query text. It also explains the THREADPOOL wait.

Read More
Gouache painting of rows of pebbles arranged smallest to largest on a flat rock with one vermilion pebble

Does GROUP BY Sort Results? Only ORDER BY Guarantees It

October 23, 2019
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Group By, SQL Order By, SQL Scripts

Does GROUP BY sort the rows it returns? No: only ORDER BY guarantees an order. This post builds a small demo, shows one GROUP BY query returning two different orders, and reads the plans that explain why.

Read More
Gouache painting of several rowboats waiting at a canal lock with one vermilion boat edging ahead

Priority Boost in SQL Server: Check It and Turn It Off

October 18, 2019
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio

Priority boost sounds like a speed setting, but it can make a server slower. This post explains what the option does, checks it with a query that works when Management Studio doesn’t show it, prints the statements that turn it off with their undo, and explains why a restart is needed.

Read More
Gouache painting of a pantry shelf of jars with uneven gaps beside a snug shelf, with one vermilion jar alone

Check Index Fragmentation With Row Count in SQL Server

October 17, 2019
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Scripts, SQL Server

To check index fragmentation with row count, read sys.dm_db_index_physical_stats in SAMPLED mode and keep the page count and row count next to each percentage. This post builds a demo with three tables, lists every index, filters out the tiny ones, loops over every online database, and rebuilds the one index that matters.

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

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