Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

All authors

Blog Post

Your First Jupyter Notebook

In April, I said I was going to start learning Jupyter Notebooks. It’s November. Let’s get going with your first Jupyter Notebook. A quick aside before we start. I...

2019-11-28 (first published: )

724 reads

Blog Post

Docker, Git and DBATools

For those who don’t know, last week was the PASS Summit. It’s an amazing event every year, but this last week, I saw a ton of indications that our...

2019-11-20 (first published: )

632 reads

Blog Post

You Are A Coder

So, you say you’re a DBA. I say you’re not. You say you’re a system administrator. I say you’re wrong. We are all coders now. Every single one of...

2019-11-04

47 reads

Blog Post

Well Trained Staff

I’ve had the opportunity in the last month to do a couple of different consulting visits, one private and one through my employer, Redgate. The goals of each of...

2019-10-28

22 reads

All authors

Blogs

Using the Data API Builder–VS Live San Diego Resources

By

Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...

Running a Local LLM On Your Laptop Resources

By

Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...

Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger

By

I was creating a question on sp_readerrorlog and realized that this procedure is different...

Read the latest Blogs

Forums

Implementing Type 4 Slowly Changing Dimensions in SQL Server

By Dinesh Asanka

Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...

The Disabled Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Disabled Index

Server-Level Table sizes

By Artur Sanin

Comments posted to this topic are about the item Server-Level Table sizes

Visit the forum

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