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 kitchen pot rack tilting because every heavy pan hangs from one end, the other end's hooks empty.

Data, Log and tempdb File Placement: Checking Where Everything Lives

September 2, 2010
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL TempDB, Transaction Log

Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.

Read More
Three garden sprinklers on separate hoses, all fed from one outdoor tap, each spraying a weak short arc.

Storage Settings That Matter for SQL Server

November 14, 2009
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL Server Configuration, SQL TempDB

Storage settings That Matter for SQL Server include latency, file placement, allocation unit size, and file growth; learn what to verify.

Read More
A tall woodpile against a cottage wall with space left for more, an axe in the chopping block, frost on the grass.

Planning for Data Growth

March 30, 2009
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Backup and Restore, SQL Data Storage

Planning for data growth uses backup and file trends, workload events, storage lead times, and a dated request for more capacity.

Read More
Two separate stone water troughs in a farmyard, one large and one small

Choosing Where to Put Data and Log Files

August 11, 2008
Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL Server Configuration, Transaction Log

Choosing where data and log files live means checking storage behavior, capacity, install defaults, and a tested move procedure.

Read More
Previous 1 2 3 4 5
  • Books
  • Testimonials
  • Privacy Policy

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