Fifty Words for Databases
Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.
2015-03-09
247 reads
Editorials
Upgrade and Refresh, or Not?
Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.
2015-03-06
138 reads
Measuring Career Growth
A guest editorial from Tim Mitchell today looks at keeping track of what we have done in our careers, and the value that it gives us.
2015-03-05 (first published: 2010-10-01)
451 reads
2015-03-04
572 reads
Pier to Pier Replication on Frozen Lake Erie
In a guest post, Rodney Landrum ponders the gaps in his DBA experience at the edge of Lake Erie.
2015-03-02
153 reads
The Express Choice
This week Steve Jones wonders if you'd be willing to use Express edition in production situations.
2015-02-27
146 reads
Building Small Habits
Today Steve Jones talks about development, and finding ways to make small changes that improve your code.
2015-02-26
212 reads
Small Leadership
Today Steve Jones talks leadership, and the value it can bring to your team if you display just a little of it.
2015-02-25
148 reads
Making Plans
PASS President Tom Larock doesn't make long term plans. Steve Jones doesn't make long term plans. Do you?
2015-02-24
133 reads
The Query Store
This week Steve Jones talks about the query store after an article was released describing it.
2015-02-23
220 reads
Blogs
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...
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...
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