A Fun Distraction
With the holiday season here, Steve Jones wonders what you'll do for fun away from work.
2016-12-16
124 reads
Editorials
This is how to fail
Today we have a guest editorial from Tim Mitchell that talks about security and communications with your customers. Ultimately it pays to be open and honest.
2016-12-15 (first published: 2013-12-17)
410 reads
2016-12-14
78 reads
DBAs Need to Learn to Develop
SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.
2016-12-13 (first published: 2014-01-07)
635 reads
2016-12-12
105 reads
The Five Year Plan
Is your IT department outdated? There's a prediction that they won't be around in five years. Steve Jones doesn't agree.
2016-12-12 (first published: 2013-06-13)
391 reads
The One Metric to Rule Them All
Measuring the performance of systems isn't always just CPU, RAM, and Disk IO. Today Steve Jones looks at business based metrics.
2016-12-09
110 reads
Testing Coders
It seems that everyone has a different idea on how to interview people. Today Steve Jones looks at the technique of having someone improve some code in real time.
2016-12-08
112 reads
What do you do when you inherit a mess at work?
I have seen three common responses to database messes. My favorite is nuclear.
2016-12-06
273 reads
2016-12-05
103 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
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