Redundant Redundancy
When DBAs too often find themselves trading sleep for Megabytes, it's time for a different approach to detection and alerting of disk space problems. So argues Rodney Landrum.
2014-01-20
135 reads
Editorials
Picking Your Packaging
Today we have a guest editorial from Andy Warren that asks you how you choose the tools you use to solve a problem.
2014-01-17
127 reads
Step Up, Don’t Step Back
We have a guest editorial today from Chris Shaw, on the need to take chances in your life.
2014-01-16
174 reads
We're not craftsmen and craftswomen
We don't always do the job we would want done for us. We don't pride ourselves as craftspeople do. At least that's what Steve Jones thinks.
2014-01-15
170 reads
Double Checks
Many of us have checks in place on systems or processes, but would we be aware of tampering with the operation of our computer systems? Steve Jones notes that auditing can be important to ensure things are working well.
2014-01-14
126 reads
No Bosses
The idea of not having a boss appeals to many of us, but is it really what you'd like? Steve Jones notes that Zappos is trying this, by eliminating many of the manager roles at the company.
2014-01-13
224 reads
The Art of Performance
Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.
2014-01-13
344 reads
The Desktop Setup
This Friday Steve Jones asks about how you set up your hardware and software environment for work. Are there things you recommend?
2014-01-10
198 reads
Sabbatical
Steve Jones is taking a sabbatical this year and has a few thoughts on what this means for his career.
2014-01-09
533 reads
The Holiday Challenge
The holiday time period isn't always a fun time for IT pros who can get stuck working more than usual. Steve Jones talks about some of the experiences he's had.
2014-01-08
151 reads
Blogs
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers