Tag: t-sql

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 4 min read

How to update DB File Growth Settings for ALL Databases at the same time

Running with SQL Server's default autogrowth settings is quietly hurting your performance. Learn how to bulk-update file growth settings across all databases using a single T-SQL script.

Read article →

21 Oct 2017 · 6 min read

Gettin’ Techie SET STATISTICS TIME

SET STATISTICS TIME reveals exactly how long SQL Server spends parsing, compiling and executing your queries. Learn to read the output and diagnose slow query performance with confidence.

Read article →

← Previous Page 2 of 2

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.