2017-12-25
40 reads
Editorials
VMs for Development
Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.
2017-12-22 (first published: 2014-02-14)
254 reads
Data Security Policies
Does your organization have policies around data security? Perhaps they should, or perhaps you should ask for some to be created and education available for users.
2017-12-21 (first published: 2014-04-07)
161 reads
2017-12-19 (first published: 2014-03-18)
506 reads
2017-12-18
70 reads
Understanding Your Value
Fill out the 2017 salary survey to help us all understand where our compensation might lie relative to others.
2017-12-18
21 reads
2017-12-15
179 reads
2017-12-13
75 reads
Advice for Newcomers
If you could look back on your career, is there some advice you wish you had? Is there something you'd tell people considering your job as a career? Let us know this Friday.
2017-12-12 (first published: 2014-04-18)
706 reads
2017-12-11
96 reads
Blogs
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
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...
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