2017-12-11
61 reads
Editorials
The Relational Database is the Default
If you don't have a good reason not to, use a relational database. Always.
2017-12-07
113 reads
2017-12-06
99 reads
A Christmas Bug
A bug in American Airlines scheduling could impact travelers, but certainly will impact their bottom line.
2017-12-04
106 reads
The Appearance of the Flat File Wizard.
After many barren years, Phil Factor is pleased to see the first signs of Spring in SSMS.
2017-12-04
100 reads
Certifying Schools
Schools don't necessarily teach people how to code, but they could do a better job.
2017-11-30
100 reads
2017-11-29
195 reads
We Need DevOps for Performance
CosmosDB has ways to tune performance based on throttle metrics. We probably need some DevOps style feedback and adjustment for relational systems.
2017-11-28
79 reads
A well-earned break from the database
Databases, like sheep, get get into some surprising scrapes. However, as long as you've planned for all the common mishaps, your conscience should be clear to take a well-earned holiday.
2017-11-27
79 reads
2017-11-24
79 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