When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.
2025-09-24
2,506 reads
Storage Management
2025-04-21
1,896 reads
Do We Care About Disks?
I ran across a tip on MSSQLTips from Joe Gavin recently, and it got me thinking about hardware and disks. For a lot of us, we deal with servers and storage, and not disks. While we might have a disk on a laptop or desktop, most of the production systems just attach to remote storage. […]
2021-11-03
298 reads
The State of Data Growth
Data continues to grow at incredible rates. That's good for those of us that make a living with data.
2021-09-11
269 reads
Storage 101: The Language of Storage
Robert Sheldon continues his series on storage. This article covers some of the basics of performance metrics, HDDs, and SSDs.
2020-02-10
Storage 101: Welcome to the Wonderful World of Storage
Understanding all the storage options available to...
2019-12-30
DBA Walkthrough – Adding space on IBM AIX Power Machines
Learn how to manage storage/filesystems on IBM AIX - Power machines. Learn from this demo of expanding a filesytem on AIX so that your DBA's get a high level overview of how AIX storage management works.
2019-05-21
1,513 reads
Check Used Table Space for User Defined Tables
Query the System Tables to find the space usage, which helps Database Administrators identify the Tables that are using the most space.
2012-07-11 (first published: 2012-07-04)
1,268 reads
Disk space alert per drive
This script validates the sufficient disk space per drive.
When you'll reach a minimum on a diskdrive, the script will mail all recipients.
2011-12-07 (first published: 2011-10-28)
4,063 reads
Reliable Storage Systems for SQL Server
By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantage
2010-06-03
2,506 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers