2017-05-09 (first published: 2013-08-08)
305 reads
Editorials
2017-05-08
110 reads
Three Days and a Notebook
Steve Jones is off to Seattle for the rest of the week attending Microsoft Build 2017.
2017-05-08
106 reads
2017-05-05
135 reads
2017-05-03
165 reads
The Secret Password
The secret passwords we store in systems might be secure from discovery, but are they secure from use?
2017-05-02
86 reads
2017-05-01
79 reads
Why deadlines stink, and are so necessary
I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild guess. They restrict the amount of time that I can spend in preparation and research so that I can do things right; they squeeze the artistic quality out of my work as a […]
2017-05-01
66 reads
Starting to Use SQL Server 2017
Today Steve Jones looks forward to the next version of SQL Server, with his curiosity to see if you feel the same way.
2017-04-28
142 reads
SQL Server on Linux is Just SQL Server
Steve Jones looks at SQL Server on Linux and how this may differ from what most of us have worked with in the past.
2017-04-27
110 reads
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
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