ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.
SQL SERVER – Monitoring Database Autogrowth Settings
Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;
Heap or Clustered Index: When a Heap Table Is the Right Choice
The heap or clustered index choice changes the reads of every scan. The demos measure forwarded records in a heap, a range query on both kinds of table, and the size of a nonclustered index on a wide key, and says when a heap is the right choice.
Finding Oversized Data Files With Lots of Free Space
Identify oversized data files with FILEPROPERTY, separate internal free space from disk capacity, and review one-time shrink choices.
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.
Most Used Database Files – SQL in Sixty Seconds #190
If a client has many databases, this script finds the most used database files. Here is my SQL in Sixty Seconds video on it.
Reads and Writes per File: Rank Files by Bytes Moved
Reads and writes per file show which data or log file SQL Server uses the most. This post ranks the files of a demo database by bytes moved with sys.dm_io_virtual_file_stats and explains what the tally can and cannot tell you.