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 - Wrap on Series of Temporary Statistics

SQL SERVER – Wrap on Series of Temporary Statistics

December 6, 2013
Pinal Dave
SQL Tips and Tricks
SQL Statistics

The final post on temporary statistics answers reader questions, like whether you can update them. Only SQL Server can, but you can drop them.

Read More
SQL SERVER - Scripting Statistics for Read-Only Database and Making it Permanent

SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent

December 4, 2013
Pinal Dave
SQL Tips and Tricks
SQL Statistics

Learn scripting statistics for read-only database use from TempDB, then make them permanent so they survive a SQL Server restart.

Read More
SQL SERVER - Location of Statistics Before and After Database is Marked as a Read-Only

SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only

December 2, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics

Where do old statistics go when a database becomes read-only? The location of statistics created before the change stays the same, and they remain permanent.

Read More
Right-click Script Statistics as.

SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS

November 30, 2013
Pinal Dave
SQL Tips and Tricks
SQL Statistics

Trying to script statistics in SSMS but the option is always disabled, even outside read-only databases? Here is why it happens.

Read More
SQL SERVER - Statistics for Read-Only Database are in TempDB

SQL SERVER – Statistics for Read-Only Database are in TempDB

November 29, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Statistics

Statistics usually live in the same database as the table, so where do they go for a read-only database? The answer is TempDB. Here is how it works.

Read More
A baking table with only the used ingredients left out, including an open red cocoa tin.

Finding Which Statistics a Query Used in the Execution Plan

July 20, 2013
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Server, SQL Statistics

Find which statistics a query used through OptimizerStatsUsage in actual-plan XML, cached plans, and Query Store history.

Read More
A small proofing basket with a huge mass of dough spilling over its sides across a floured bakery bench.

Temp Table Statistics: Why a #Table Plan Goes Stale

July 12, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server, SQL Statistics, Temp Table

Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.

Read More
Previous 1 … 9 10 11 12 13 14 15 16 Next
  • Books
  • Testimonials
  • Privacy Policy

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