Problems With Database Problems
The GitLab crisis has Steve Jones thinking about two things: competence and care.
2017-02-13
124 reads
Editorials
The Second Career
From a well-built cockney who knew how to avoid wheel clamps, to an ex-member of an elite anti-riot unit, some of the best DBAs have a surprising diversity of skills and experiences, according to Phil Factor.
2017-02-13
112 reads
Moving Through Five Years
An updated editorial. The five years are almost up for the prediction that IT departments would be eliminated. Read Steve Jones thoughts on where we are today.
2017-02-10
122 reads
Why Devops? For Better Security
DevOps is supposed to help us build better software, faster. Steve Jones looks at one of the other benefits: security.
2017-02-09
113 reads
2017-02-08
170 reads
A View of the Cloud
Today Steve Jones looks at how we can better build software by considering the cloud.
2017-02-06
81 reads
Close Encounters of the CEIP Kind
Microsoft's Customer Experience Improvement Program for SQL Server: once easy to avoid, now hard to ignore, but Rodney Landrum sees an upside.
2017-02-06
1,589 reads
Your Favorite Feature that Needs Work
This week Steve Jones asks what parts of SQL Server would you improve and why.
2017-02-03
83 reads
The Great and Powerful Internet of Things
A look at the good, and bad, of the IoT world along with the potential future.
2017-02-02
108 reads
A Wide Variation in Skill
We all have different levels of skills, and it's not always because we don't try. Sometimes it's a question of timing.
2017-01-31
138 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