Can a Table Really Have a Clustered Index?
A table doesn't so much "have" a clustered index as a table "is" a clustered index.
DBAs Take Sixth Place
The hot jobs for 2013 are compiles and a number of tech jobs make the top 100. DBAs come in 6th and Steve Jones thinks that's good news for data professionals.
It's the Bits
A woman sues Best Buy for $54million. That's absurd, but her laptop is worth more than the hardware. This editorial was originally published on Mar 3, 2008. It is being re-run as Steve is traveling.
Making the Case for a SQL Server Platform Refresh
With the release of Windows Server 2012, SQL Server 2012, and the new generation of Sandy Bridge Xeon processors, your organization is likely to get many tangible benefits from upgrading your current database infrastructure with a complete platform refresh.
Rudolph The Red-Nosed Tester and Other Festive Arrangements
A Christmas poem and a contest from Simple Talk.
Some tips for working with big data models
The main goal of this article is to present some tips to help professionals that need to work with complex, big, and hard to understand database models that anyone may came across some day.
The Load Poll
This Friday Steve Jones asks what the load on your systems are. Do you know what it is and how it compares to other systems?
Setting up a Data Science Laboratory
There is no better way of understanding new data processing, retrieval, analysis or visualising techniques than actually trying things out. In order to do this, it is best to use a server that acts as data science lab, with all the basic tools and sample data in place. Buck Woody discusses his system, and the configuration he chose.
Eleven Challenges in Unifying Reference Data
Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.
The Auto OS
Automobiles are becoming more complex, with more computerized systems every year. Steve Jones talks about some advances and how we must be sure that security is a part of future design considerations.
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
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...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers