Half a Year
We're halfway through the 2015 year and Steve Jones has a few thoughts for you this holiday weekend.
2015-07-03
83 reads
Editorials
SSMS Maturity
Announcements recently for changes in SSMS mean that the tool many of us rely on is growing up.
2015-07-02
224 reads
Training Computer Scientists
What's the best way to enter this business? Steve Jones has a few thoughts on the traditional CS degree.
2015-07-01
254 reads
The Importance of Our Work
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
2015-06-30
142 reads
Not a cloud to be seen
Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
2015-06-29
136 reads
2015-06-29
322 reads
#SQLNewBlogger
Steve Jones talks about blogging today, how it can help your career, and how easy it can be to get started.
2015-06-25
146 reads
2015-06-24
615 reads
Skill Supply and Demand
Finding staff with the proper skills can be a challenge, and it might be a reason why you choose, or remain with, a particular technology.
2015-06-23
203 reads
The Stress of a Former DBA
Rodney Landrum impresses on his audience the importance of attention to the finer details, during data analysis and reporting.
2015-06-22
244 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