Presenting at the kickoff Lynchburg Va SQL User Group meeting
There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...
2014-02-17
727 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
T-SQL Tuesday #51: Is this a bet worth making?
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2014-02-14 (first published: 2014-02-11)
1,814 reads
Transaction Isolation Levels
An examination into how the various transaction isolation levels affect locking (and blocking)
2014-02-13
9,060 reads
SQL Prompt – new features in version 6.x
I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late...
2014-01-31 (first published: 2014-01-27)
3,078 reads
Assumptions and clusters – the double whammy
I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through...
2014-01-20
843 reads
TSQL Tuesday #50 – Automation – Verifying the Backup Chain
I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into...
2014-01-14
785 reads
Interview Questions – what to ask the company interviewing you
Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that...
2014-01-10 (first published: 2014-01-06)
4,147 reads
Are CHECKSUMs being performed with a Compressed Backup?
Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:
CHECKSUM
Specifies...
2014-01-06 (first published: 2013-12-30)
2,891 reads
Creating templates for use in BIDS (SQL Spackle)
Learn how to create and use templates in BIDS in this short SQL Spackle article.
2013-12-30 (first published: 2011-04-21)
11,045 reads
Locking, Blocking and Deadlocking
Introduction into Locking, Blocking and Deadlocks in SQL Server, and why SQL Server uses these actions.
2013-11-18
11,483 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