Welcome To 2014
A quiet and rainy day here in Orlando today. Not my favorite weather, but good for thinking, mostly about what...
2014-01-02
321 reads
Goodbye, 2013
For me, 2013 was one of the most interesting and busy years of my life. It was a good year...
2014-01-01
776 reads
Day 8 – Ring in The New
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-01
9 reads
Day 8 – Ring in The New
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-01
743 reads
Happy new year!
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
639 reads
Wrapping Up 2013
Last year, I did a wrap up post of the year (also 2011 and 2010) to see where I landed from...
2014-01-01
754 reads
MVP Award for 2014
Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server...
2014-01-01
656 reads
Answer - Objective Question (Number of non clustered indexes possible on a Table in SQL Server 2008R2)
Question :-
How many non clustered indexes are possible in a table in SQL Server 2008R2
1) 1
2) 249
3) 999 (Correct answer)
4)...
2014-01-01
1,099 reads
Answer - Question of the Week - 28/12/2013 - Question 2
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
602 reads
While loop in SQL server
In While loop, we set a condition for the repeated execution of a SQL Code block or a SQL Statement....
2014-01-01
22,842 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
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...
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