Faster Cloud Warehouses
Azure SQL Data Warehouse gets some improvements, and Steve has a few comments.
2019-01-23
77 reads
Editorials
2019-01-22
91 reads
2019-01-21
142 reads
Versatile or Jack of all trades
Do you consider multi-skills useful; or just one with mastery in it?
2019-01-21
157 reads
2019-01-17
74 reads
2019-01-16
155 reads
Measuring Effectiveness
Being effective is important to Steve. Today he talks about the things you might consider when trying to determine if your group is being effective.
2019-01-15
62 reads
Where's that Snippet?
Phil Factor has tried many different ways to remember code and archive old code for reuse, but has yet to find the perfect solution. Does it exist?
2019-01-14
129 reads
Do you have a security to-do list?
Security is important, and Steve wonders if any of us have a list of things we do that improve security.
2019-01-11
90 reads
2019-01-10
121 reads
Blogs
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...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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