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 - Quick Look at SQL Server Configuration for Performance Indications

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.

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

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.

Read More
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
Herbs growing in reused tin cans and jars on a sunny windowsill, with a spoon used as a trowel beside them.

Learning SQL Server on a Budget

January 10, 2011
Pinal Dave
SQL Tips and Tricks
SQL Sample Database, SQL Server, SQL Server Express, SQL Training, Starting SQL

Learning SQL Server on a budget is possible with free development editions, official documentation, samples, and community practice.

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
Four figures seen from behind carrying one long oak beam on their shoulders along a village lane.

Striped Backups: Writing One Backup to Several Files

January 6, 2011
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server

Use striped backups across several files, inspect media families, restore every stripe, and test resource settings on your own server.

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
Previous 1 … 431 432 433 434 435 436 437 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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