Data Storage

SQLServerCentral Editorial

Do We Care About Disks?

  • Editorial

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. […]

You rated this post out of 5. Change rating

2021-11-03

245 reads

External Article

SQL Server Storage Internals 101

  • Article

This article is an extract from the book Tribal SQL. In this article, Mark S. Rasmussen offers a concise introduction to the physical storage internals behind SQL Server databases. He doesn't dive into every detail, but provides a simple, clear picture of how SQL Server stores data.

2013-10-21

3,767 reads

Blogs

T Sql Tuesday 170: Learning From Abandoned Projects

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Read the latest Blogs

Forums

File share witness in an Always On cluster

By robinpryor

Another DBA mistakenly created a file share witness for one of our ao clusters....

Improve Delete Performance in Table With Many Related Tables

By tgitchel

This simple delete statement drives CPU to 100% for long periods of time when...

Transpose table by Row number

By scott@lucsam.com

I want to transpose the attached table of data so that all the data...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers