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
SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL

January 2, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure

My company owner asked which query runs longest and I found no ready script, so I wrote one: the Longest Running Query with its average and maximum time.

Read More
A hand checking every coat on a row of hooks for the one with a red lining

Leading Wildcard LIKE Searches: Why They Scan and What Helps

December 25, 2008
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL Server, SQL String

Diagnose a leading wildcard LIKE scan and compare prefix search, reversed suffix keys, full-text search, and n-gram indexing.

Read More
Database column collation.

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008
Pinal Dave
SQL Performance
SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.

Read More
A hand holding a stethoscope to the flank of a calm chestnut horse in a stable, a closed leather bag nearby

Five DMVs Worth Memorizing

December 19, 2008
Pinal Dave
SQL Performance
DBA, SQL DMV, SQL Performance, SQL Server, SQL Wait Stats

Five DMVs worth memorizing show SQL Server sessions, active requests, waits, index use, and file I/O during an incident.

Read More
A planting dibber continues a row of holes beyond a bare rocky patch in a garden bed.

Updating a Large Table in Batches With a Moving Key Range

December 11, 2008
Pinal Dave
SQL Performance
Batch, Clustered Index, SQL Transactions, Transaction Log

Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.

Read More
A trail camera on a fence post watches one sheep standing in a narrow gateway while another waits behind it.

The Blocked Process Report

December 8, 2008
Pinal Dave
SQL Performance
SQL Extended Events, SQL Lock, SQL Monitoring, SQL Server, SQL Server Configuration

The blocked process report shows the waiting session and blocker after a configured threshold, with Extended Events capturing the XML for review.

Read More
Two glass jars on a garden wall, one empty, one filled with water under a red lid

Comparing Two Wait Stats Snapshots to See What Changed

December 8, 2008
Pinal Dave
SQL Performance
DBA, SQL DMV, SQL Performance, SQL Wait Stats

Compare wait stats snapshots over a chosen window, subtract cumulative counters, remove background waits, and calculate rates and average waits.

Read More
Previous 1 … 105 106 107 108 109 110 111 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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