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;
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.
11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes
This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.
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.
SQL SERVER – Most Used Database Files – Script
If the client has multiple databases, this script also helps us to find out which database and particularly which database file is the most used.