Pinal Dave - SQL Server Performance Tuning Expert

A long wooden seed drawer with equal compartments, two hands lifting one out whole while an empty one waits at the end.

Partitioning a Large Fact Table

January 15, 2011

Data Warehousing, SQL Index, SQL Server, Table Partitioning

Partitioning a large fact table can simplify loading and retention when boundaries, aligned indexes, and switch rules are designed together.

SQL SERVER – Quick Look at SQL Server Configuration for Performance Indications

January 14, 2011

Pinal Dave

SQL Performance

SQL Scripts

Part two of my SQL Server Magazine series is a quick look at SQL Server configuration for performance and the settings I check first with new clients.

SQL SERVER – A Quick Note on DB_ID() and DB_NAME() – Get Current Database ID – Get Current Database Name

January 13, 2011

Pinal Dave

SQL Tips and Tricks

SQL Scripts

A quick note on DB_ID() and DB_NAME(): how to get current database name and ID, and how to turn a database ID into a name and back again.

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.

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.