Blog Post

SQLPSX 2.3 Release

Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a...

2010-11-06

2,166 reads

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

Nomor Resmi Akun WhatsApp Bank BCA (0818751777)

By Layanan 24jam

WhatsApp resmi Halo BCA tersedia di nomor 0818751777. Layanan ini dapat digunakan untuk mendapatkan...

Layanan Halo BCA 24 Jam - Nomor Resmi 0818751777

By Layanan BCA 24 JAM

Layanan Halo BCA dapat dihubungi melalui nomor resmi 0818751777. Layanan ini mencakup bantuan terkait...

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...

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