2016-09-29
71 reads
Editorials
What is the Future of Monitoring?
Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer assistance in the future.
2016-09-28
103 reads
DevOps at Microsoft
Microsoft has dramatically changed the way they develop software, in a very public way, as Steve Jones notes.
2016-09-27
133 reads
Don't tell the boss
Why would I want the boss to be able to see so easily every little bad thing that happens on my servers? Grant Fritchey offers a few reasons...
2016-09-26
143 reads
The Black Boxes
The world of machine learning and artificial intelligence are growing. Steve Jones notes this means we need to decide if we can trust the black boxes.
2016-09-26
71 reads
What Helps You Learn?
This Friday Steve Jones looks to find out what things help people learn and build skills more readily.
2016-09-23
91 reads
Capture the Flag
A competition among software bots may foretell a vision of the future for software developers.
2016-09-22
97 reads
Why We Need Backups First
This week Steve Jones notes that backups aren't the most important thing for your data. Restores are.
2016-09-19
112 reads
Data Science Education
Data Science is a hot area and one to which quite a few people would like to move. Steve Jones has some thoughts on trying to get certified in this area.
2016-09-15
172 reads
2016-09-14
144 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