December Question: What does it mean to be a Proactive DBA?
One of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the...
2010-12-02
622 reads
SQL Craft Fair
Have you ever been “dragged” to a long weekend afternoon at a craft fair? Did it look something like this?
This...
2010-12-02
480 reads
Processing a Measure Groups Index Using SSMS
As I had mentioned in a previous blog (Creating and processing an Analysis Services partition), instead of processing an entire...
2010-12-02
1,268 reads
iPad Update
I updated the iPad tonight to iOS 4.2. I had no particular reason to upgrade, but I saw a few...
2010-12-01
537 reads
LiveWriter 2011
I recently upgraded to LiveWriter 2011 while upgrading to the final version of LiveMesh. After the upgrade I noted the...
2010-12-01
342 reads
RTFM365
Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.) I think for...
2010-12-01
595 reads
When Were The Statistics In SQL Server Last Updated?
When SQL Server receives a new query, the Query Optimizer undertakes the task of identifying a good plan to resolve the...
2010-12-01
691 reads
The Development DBA Role
The Development DBA role, though not as common as the more prominent DBA and Database Developer roles in the database...
2010-12-01
4,519 reads
Semi-Crippled
When it rains it pours.
Last week my Nano died. It won’t hold a charge, or at least it won’t...
2010-12-01
447 reads
Passing SSRS T-SQL Values to SSRS MDX Parameters
At a recent client engagement we built a SQL Server Reporting Services (SSRS) report with a T-SQL based data source....
2010-12-01
2,376 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
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...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
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
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