What is a Database Administrator today?
Today we have a guest editorial from Jim Youmans that asks "what does it mean to be a DBA today?"
2013-12-06
414 reads
Editorials
Competition or Cooperation
Would you rather work with people, or compete with them? Steve Jones has comments on the Microsoft Stack Ranking system that seems to encourage the latter.
2013-12-04
166 reads
Going over their heads: IT Decisions
Phil factor points out that Marketing people who appeal directly to enterprise CIOs are generally wasting their time, and are better off convincing IT people in general.
2013-12-02 (first published: 2013-11-02)
155 reads
Is Your Data Relational?
An RDBMS is a good fit for many database problems, perhaps as Steve Jones thinks, the best fit for most. However NoSQL systems have a place, we're just not sure where.
2013-12-02
237 reads
The Abstract DBA
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
220 reads
2013-11-28
108 reads
Visitor Parking
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
184 reads
Checking Up on Developers
This Friday Steve Jones has a poll about developers. Help compile a good list of common mistakes made in SQL Server.
2013-11-26 (first published: 2009-05-08)
514 reads
Content in the Cloud
Steve Jones has some concerns over new options in SQL Server 2014 that might lead some customers to experiment in a way that causes them unexpected pain.
2013-11-25
84 reads
Vendor Value
Software maintenance is often required when purchasing software packages. But do the vendors deliver value for this charge? Steve Jones has a few thoughts on the subject.
2013-11-25 (first published: 2009-05-18)
150 reads
Blogs
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...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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