Query Store and Optimize For Ad Hoc
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...
2016-04-11 (first published: 2016-03-28)
1,944 reads
The Scary DBA
Happy Dance!
I’m all like:
Because I saw this on an eval:
I’ve been trying to ramp up to take advantage of my MSDN...
2016-03-25
1,139 reads
PASS Board 2016: Update #2
Time flies. I didn’t notice that I hadn’t posted an update in February.
There’s been a lot going on since I...
2016-03-24
433 reads
Cross Database Query in Azure SQL Database
You can’t query across databases in Azure SQL Database… or can you?
Let’s check. I’ve created two new databases on an...
2016-03-28 (first published: 2016-03-21)
3,138 reads
Opportunities To Talk
It’s weird being an introvert who likes to talk to people, but what can I do. I like talking to...
2016-03-17
467 reads
Leadership Lessons
Not for you, for me.
I’m sure you’ve heard the statement: Praise in public. Criticize in private.
I agree with this approach....
2016-03-18 (first published: 2016-03-14)
1,740 reads
SQL Server Backups Are A Business Decision
Blog post #3 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel
Read more about Tim’s challenge here.
It’s very easy to think of...
2016-03-10 (first published: 2016-03-07)
1,810 reads
Speaker of the Month: March 2016
I’m finally getting back out to community events so I should be able to avoid giving this gigantic honor to professional...
2016-03-04
409 reads
Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,939 reads
Query Store and Recompile
One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...
2016-02-24
631 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