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
Two plain notebooks lie open with blank pages and a wooden pencil between them.

Using Query Store to Prove an Upgrade Did Not Hurt

January 12, 2011
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Plan a Query Store upgrade comparison with a captured baseline, matched workload periods, regression review, and carefully monitored plan forcing.

Read More
Gouache painting of a paper road map on a desk with faded grey and blue routes and one route traced in vermilion, held down by a brass pushpin beside a magnifier

Force a Plan With Query Store: Undo a Bad Plan in Minutes

January 11, 2011
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, Query Store, SQL Scripts

Force a plan with Query Store when a query turns slow after a plan change. This post builds a regression, finds both plans in Query Store, forces the good one, measures what forcing costs and shows when to unforce.

Read More
SQL Server Database Log File Grew Too Big.

SQL SERVER – master Database Log File Grew Too Big

January 9, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A reader found the master database log file grew very large even in simple recovery mode. I share the full email and ask what you would suggest.

Read More
SQL SERVER - Get File Statistics Using fn_virtualfilestats

SQL SERVER – Get File Statistics Using fn_virtualfilestats

January 8, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics, SQL View

Which MDF or NDF file is the busiest? This query uses fn_virtualfilestats to show reads, writes, IO stalls and size for every database file.

Read More
SQL Server Query Optimizer Statistics.

SQL SERVER – DMV – sys.dm_exec_query_optimizer_info – Statistics of Optimizer

January 7, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Scripts

The DMV sys.dm_exec_query_optimizer_info keeps statistics of optimizer activity. My simple query shows optimizations, elapsed time, final cost and more.

Read More
Generate Scripts Wizard.

SQL SERVER – Copy Statistics from One Server to Another Server

January 5, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics

Without the client’s data, every query ran in zero milliseconds. Here is how I copy statistics from one server to another to tune with only the schema.

Read More
Gouache painting of a row of worn garden tools with one spotless untouched red trowel in the middle

Unused Index Script: Find Indexes That Only Cost You Writes

January 4, 2011
Pinal Dave
SQL Performance
SQL DMV, SQL Index, SQL Scripts

This Unused Index Script lists nonclustered indexes that SQL Server keeps writing to and no query ever reads. It starts from the index list so untouched indexes are not missed, skips the risky ones, and writes the disable and recreate statements. A garden center orders table shows one update dropping from 5,011 pages to 6 once an unused index is disabled.

Read More
Previous 1 … 238 239 240 241 242 243 244 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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