How Far are You Willing To Go To Get Something?
There are important things in life and in our career, how far are you willing to go to get them?
2017-10-30
127 reads
Editorials
Perspective
I find it extremely easy to sometimes lose sight of the important stuff. The day-to-day grind can seriously get in the way. I think this is a big part of how we find ourselves having so many silly intra-organizational turf wars. The developers don’t like how the DBAs do things. The DBAs are frustrated with […]
2017-10-30
88 reads
Physical or Virtual Storage
This week Steve Jones talked about physical hardware, asking who might still pay attention.
2017-10-27
215 reads
Unstructured Data
Unstructured data can be misleading. Steve Jones has a few thoughts today on how he sees this term.
2017-10-26
90 reads
2017-10-25
391 reads
2017-10-23
70 reads
Tell the Judge You Have No Backup
The NYPD is claiming there isn't a backup for one of their databases.
2017-10-23
143 reads
The Remote Balance
Telecommuting and remote work are growing in many fields, but especially technology. However the practice needs to be balanced with the notion that you still have a life outside of work.
2017-10-20 (first published: 2014-02-20)
197 reads
Top Talent Leaves
Why do employees leave their companies? There are a variety of reasons, but when your most talented people leave, that's a concern. Steve Jones comments on what we might do about this.
2017-10-19 (first published: 2014-02-10)
409 reads
Software Patents
Patents are one way that governments can spur innovation. However many people think software patents should be eliminated. Steve Jones doesn't think so, but would like reform.
2017-10-18 (first published: 2014-01-30)
168 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