2015-11-09
237 reads
Editorials
The Lost Laptop Crisis
Losing a laptop isn't something most of us would want to deal with, usually because of the expense. However, there may be other implications that concern you. Share your worries with us today.
2015-11-06
126 reads
Crossing Azure Borders
Steve Jones is pleased to see some changes at Azure that make the database a stronger platform.
2015-11-05
114 reads
2015-11-04
149 reads
Virtual Failback
The pressure to move to virtual systems is increasing, but is there a fallback if you have issues?
2015-11-03
106 reads
Secret Software Security
The move to limit disclosure of vulnerabilities continues, with potential issues for many of us.
2015-11-02
115 reads
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
2015-11-02
298 reads
2015-10-30
344 reads
Leave Developers Alone
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
2015-10-29 (first published: 2011-07-25)
535 reads
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
2015-10-28 (first published: 2008-03-07)
1,325 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