Technical Article

SQL Server Database File Sizes

This script creates a SQL_Statistics table in the Mater Database and then scroll through the existing databases on the server and gathers the Servers Name, logical device name, the file name and the file size and writes it to the table alond with a date time stamp.We run it once a month to gather the […]

You rated this post out of 5. Change rating

2005-02-22 (first published: )

543 reads

Blogs

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Advice I Like: Responsibility

By

“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...

Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports

By

Originally published April 2022; substantially updated July 2026. This post is a complete replacement...

Read the latest Blogs

Forums

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Another Model, More Data Loss

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Another Model, More Data Loss

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers