Auto-Deleting Data
Steve likes that idea of auto deleting data, especially with legislation increasing.
2018-05-01
103 reads
Editorials
2018-04-30
70 reads
Taking Shortcuts
We don't mean to introduce security issues, but sometimes we do because we give in to pressure.
2018-04-30
55 reads
The CDO
Does your company have a Chief Data Officer? Steve Jones doesn't think you need one to use data wisely.
2018-04-27
63 reads
2018-04-26
196 reads
Stairway to Advanced T-SQL Crossword
This crossword puzzle is based on the contents of the Stairway to Advanced T-SQL.
2018-04-25
320 reads
Cloud Snake Oil
The Cloud isn't always what it seems and Steve notes that paying attention to finances might be the most important thing.
2018-04-24
118 reads
SQL Community
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
2018-04-23
136 reads
Keep It All
We could use more intelligence in our backup systems, since we don't need to keep all those files.
2018-04-20
76 reads
Good Security Needs Layers
A good security system needs layers since our applications and platforms don't exist in a vacuum.
2018-04-18
66 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