Go Small
The SQL Server community is amazing, and Steve Jones hopes we continue to be close as we grow. He brings light on an idea to grow us larger, but smaller.
2014-12-16
159 reads
Editorials
2014-12-15
100 reads
Drop and Recreate
Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.
2014-12-15
206 reads
The Last Job
Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.
2014-12-12
164 reads
Citizen Programmers
Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.
2014-12-11
147 reads
Holiday Struggles
The sporadic schedule of a day or two a week this holiday season has been a struggle for Steve Jones.
2014-12-09
191 reads
Software Projects: the important boring bits
Phil Factor on the sort of boring expertise that will help you thrive as a consultant.
2014-12-08
143 reads
We Still Need Human Judgment
Computers aren't necessarily more infallible than humans, and they aren't necessarily even going to make better decisions. We still need humans in the decision process.
2014-12-08 (first published: 2010-06-23)
200 reads
What Have You Learned Lately?
Have you learned anything new lately? Steve Jones asks the question after an interesting T-SQL Tuesday.
2014-12-04
165 reads
The Value of Code
What's the value of code to your organization? Steve Jones thinks it's much larger than many people believe.
2014-12-02
149 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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