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 flax brake handling coarse fiber while finer strands extend beyond its working reach

Deprecated System Tables: Replacing sysobjects and sysindexes

November 9, 2018
Pinal Dave
SQL Performance
SQL Deprecated Feature, SQL System Table, System Database, System Object

Old catalog views still answer, but their page counts can be far too small. A short demo shows the gap and how to replace them.

Read More
Execution Plan Cost Breakdown.

SQL SERVER – Parallelism for Heap Scan

October 29, 2018
Pinal Dave
SQL Performance
Clustered Index, Parallel, SQL CPU, SQL Heap, SQL Index, SQL Scripts, SQL Server

Two DBAs asked me if their table needed a clustered index. Our conversation during a Health Check turned into a lesson on parallelism for Heap Scan.

Read More
A coil of rope on a dock, half of it wound onto a drum and half still loose on the boards.

SQL Authroity News – Optimizing Lazy Spool – PASS Blog

October 26, 2018
Pinal Dave
SQL Performance
SQL Index, SQL PASS, SQL Scripts, SQL Server

A sneak preview of my SQLPASS sessions: I wrote about optimizing Lazy Spool on the PASS blog, and here are the first two paragraphs with a link to the rest.

Read More
Gouache painting of a paper kite caught high in the branches of a bare tree by its tangled string, with one vermilion ribbon trailing from its tail

PREEMPTIVE_OS_DEVICEIOCONTROL: DBCC CHECKDB Will Not Stop

October 22, 2018
Pinal Dave
SQL Performance
SQL Error Messages, SQL Server, SQL Server DBCC, SQL Transactions, SQL Wait Stats

A DBCC CHECKDB session waiting on PREEMPTIVE_OS_DEVICEIOCONTROL did not end, even after a stop job and a kill. The wait is outside SQL Server’s control, so nothing inside SQL Server could clear it. Restarting SQL Server removed the session.

Read More
A hand washing with a thin worn sliver of soap while a new red bar dries on the windowsill.

Asynchronous Statistics Updates: When They Help and When They Hurt

September 27, 2018
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics

Evaluate asynchronous statistics updates against compile latency, data-change timing, and low-priority metadata locking in SQL Server.

Read More
Two identical dollhouses side by side, each with lights on in different rooms.

Intelligent Query Processing: Checking What Is On per Database

September 25, 2018
Pinal Dave
SQL Performance
Compatibility Level, SQL Performance, SQL Server, SQL Server 2019

Check intelligent query processing by database compatibility level, scoped switches, and actual plan evidence before comparing servers.

Read More
Two pies cooling on a board, one with a solid crust and one with a lattice showing the filling

Inline Table-Valued Functions: Parameterized Views That Stay Fast

September 22, 2018
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Performance, SQL Server, SQL View

Compare inline table-valued functions with scalar functions, preserve customer results, and inspect plans before claiming performance gains.

Read More
Previous 1 … 46 47 48 49 50 51 52 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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