Assuming Good Intentions
With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while...
2020-10-09 (first published: 2020-10-05)
361 reads
The Scary DBA
Capture Execution Plans Only For Long Running Queries
I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...
2020-10-05 (first published: 2020-09-28)
531 reads
Review: Stellar Repair for SQL Server
I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it...
2020-10-01 (first published: 2020-09-23)
299 reads
Extended Events: Filter on Stored Procedure Name
I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...
2020-09-04 (first published: 2020-08-24)
583 reads
Azure SQL Database Automatic Tuning
I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...
2020-08-27 (first published: 2020-08-17)
272 reads
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
326 reads
Capturing Queries Can Be a Pain
The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...
2020-08-11 (first published: 2020-08-03)
447 reads
Announcing: AWS Community Builders
I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...
2020-07-30
15 reads
Database Fundamentals #28: Creating a Primary Key Using T-SQL
There are actually a couple of ways to create a primary key with T-SQL. You can use the ALTER TABLE script to add a primary key to an existing...
2020-08-06 (first published: 2020-07-28)
528 reads
AWS Deployment Pipelines
I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...
2020-07-20
66 reads
Blogs
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...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
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