User Groups and Winners!: Day 3
Today's winner is! Aadhar Joshi!
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.
We still...
2013-12-11
540 reads
Collecting Historical Wait Statistics
As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...
2013-12-16 (first published: 2013-12-11)
2,517 reads
Learn To Code
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
630 reads
T-SQL Tuesday #49: My Go-To Query For Waiting Tasks
I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...
2013-12-10
1,228 reads
Certification Updates for SQL Server 2014
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...
2013-12-10
5,420 reads
T-SQL Tuesday #49: Wait for it
It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....
2013-12-10
859 reads
Be a Brilliant DBA
John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice,...
2013-12-10
525 reads
T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
This tradition was started by Adam...
2013-12-10
1,457 reads
One Piece of Advice For the Aspiring DBA #DBAJumpStart
Unicorn DBA Advice
When you are an aspiring DBA, there are many things that come with that job role that you’ll...
2013-12-10
783 reads
T-SQL Tuesday#49 - Wait for it...Waits & Queues
As
I was waiting for the next TSQL
Tuesday topic to be announced, we all know that when SQL Server performance is
slow,...
2013-12-10
1,608 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