Handling Data Corruption
This week Steve Jones wonders what you might do if you discovered data corruption.
2017-06-29
74 reads
Editorials
2017-06-28
116 reads
Classifying Sensitive Data
The ability to protect, and perhaps handle, sensitive data separately from other data is becoming more important. Steve Jones discusses the process and asks if it's something you perform on a regular basis.
2017-06-27
78 reads
Improving Replication
If you have ideas for how to improve replication, Steve Jones is asking for them.
2017-06-26
151 reads
The Forgotten Editorial
Phil Factor reflects on the occasional benefits of document loss, whether accidental or less so.
2017-06-26
76 reads
The Traveling Data Professional
This week Steve Jones talks about the need to get away and asks if you have plans.
2017-06-23
84 reads
Backup Plans for Data Loss
Today Steve Jones discusses data loss, always a scary topic for the data professional.
2017-06-22
106 reads
Migrating Schema Between Platforms
The decision to change platforms isn't one Steve Jones takes lightly.
2017-06-20
90 reads
DevOps Can Help
DevOps can help, not just development, but also infrastructure, if you spend time adapting the practices to your environment.
2017-06-19
46 reads
2017-06-19
205 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