Standard SQL Server Build
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions and the answer is it always depends. Let’s discuss...
2015-02-11
15 reads
Anthony Nocentino Blog
Reflections as a consultant
Let’s just start withthe last three years have been fantastic! This blog post is a slight deviation from the technical...
2015-01-30
743 reads
Reflections as a consultant
Let’s just start with the last three years have been fantastic! This blog post is a slight deviation from the technical content on my blog. We’re going to focus...
2015-01-30
14 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly....
2015-01-25
3,454 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was...
2015-01-25
22 reads
Building Debug Symbols – Troubleshooting symbol building
Recently, I have working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the...
2015-01-01
644 reads
Building Debug Symbols – Troubleshooting symbol building
Recently,I have been working with the Debugger Symbols for SQL Server to generate call stacks and learn more about the internals of SQL Server. I approached one of...
2015-01-01
21 reads
Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries
Where to get the debugger tools
To generate the needed symbols you will need the “Standalone Debugging Tools for Windows (WinDbg)” download here: http://msdn.microsoft.com/en-us/windows/hardware/hh852365
How to...
2015-01-01
881 reads
Tracing call stacks in SQL Server – Installing the Debugging Tools for Windows (WinDbg) on Windows 8.1 and generating debug symbols for SQL Server binaries
Where to get the debugger tools To generate the needed symbols you will need the “Windows Software Development Kit (SDK) for Windows 10” download here: https://dev.windows.com/en-us/downloads/windows-10-sdk and click “Download the standalone SDK” ...
2015-01-01
17 reads
Tracing call stacks in SQL Server – Introduction
At this fall’s SQLIntersection conference in Las Vegas I attended, Paul Randal’s (t|b)“Performance Troubleshooting Using Latches and Waits” precon. Where at...
2014-12-24
1,046 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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