Vinay Kumar

  • Interests: Hi, I worked with different technologies like C#, ASP.NET, Web services and sql server. But i was fall in love with sql server and became a DBA. I always try to learn something new or recall old stuff. Frankly speaking, i don't think that i am a DBA. Still learning. I like to spend my spare time with my family and friends. Recently, i have stared blogging and improving my writing way. :-). that's all about me. Keep Learning - Keep Growing !!! Thanks Vinay Kumar

All authors

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

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