The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we...
2014-03-26 (first published: 2014-03-19)
1,442 reads
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,190 reads
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
672 reads
I had a recent run in with collation problems and it got me started reading. As I read I started...
2014-03-19
2,240 reads
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned yesterday, this post has...
2014-03-24 (first published: 2014-03-19)
1,467 reads
TweetG’day,
Are people familiar with the saying “If there’s an elphant in the room, introduce it“? – if not, then to sum...
2014-03-25 (first published: 2014-03-19)
5,441 reads
What would you do?
What would your reaction be if, one day, all that old data you’ve been holding onto for...
2014-03-24 (first published: 2014-03-18)
1,971 reads
I haven’t been to Wisconsin in a long time. Not since I was a little kid, going to visit family....
2014-03-18
820 reads
Today, MSDN and TechNet are reporting that SQL Server 2014 will be available on April 1, 2014. Thanks to @MariaZakourdaev, who posted...
2014-03-18
820 reads
I have heard people say that the Parallel Data Warehouse (PDW) is Microsoft’s best kept secret. So let me give a...
2014-03-18
2,469 reads
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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