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 fish scaler beside two headless fillets with smooth and overlapping scaled skin

Checking Data Compression Settings on Every Table and Index

November 7, 2011
Pinal Dave
SQL Performance
Database, SQL Scripts, SQL Server

A table is not simply compressed or not. Here is how to read the setting for each index and partition, and the mistake that leaves indexes full size.

Read More
Rinsed empty milk bottles on a doorstep at dawn waiting for reuse, one still wearing a red foil cap.

Temp Table Caching: Why Some Temp Tables Get Reused

November 1, 2011
Pinal Dave
SQL Performance
SQL Server, SQL Statistics, SQL Stored Procedure, SQL TempDB, Temp Table

Understand temp table caching in stored procedures, avoid cache blockers, inspect creation counters, and review retained statistics.

Read More
SQL Server query results window.

SQL SERVER – How to Ignore Columnstore Index Usage in Query

October 30, 2011
Pinal Dave
SQL Performance
SQL Index

A reader’s query ran slower after adding a nonclustered columnstore index. Here is how to ignore columnstore index usage for just that one query.

Read More
SQL SERVER - Fundamentals of Columnstore Index

SQL SERVER – Fundamentals of Columnstore Index

October 29, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server 2012

Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.

Read More
SQL SERVER - TRACEWRITE - Wait Type - Wait Related to Buffer and Resolution

SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution

October 20, 2011
Pinal Dave
SQL Performance
SQL Wait Stats

What does the TRACEWRITE wait type mean, and how do you resolve it? A DBA saw it as the top wait on his system, so here is a quick explanation.

Read More
A spokeshave follows a straight spindle, leaving neatly aligned wood shavings

POC Index: Supporting Window Functions Without a Sort

October 18, 2011
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server

Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.

Read More
Fingers taking a pinch from a small salt cellar, the large salt box on a high shelf behind

Caching Query Results in the Application

October 17, 2011
Pinal Dave
SQL Performance
Best Practices, Developer, Query Store, SQL Cache, SQL Server

Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.

Read More
Previous 1 … 76 77 78 79 80 81 82 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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