The Security Payoff
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
2015-07-30
115 reads
Editorials
Hiring for Culture
Steve Jones discusses the decision to hire someone that fits in with your culture at work, and what that means.
2015-07-29
157 reads
Visualizing in Space
An amazing visualization of basketball players has Steve Jones encouraging you to find your own pet project and showcase some skills.
2015-07-28
148 reads
No Downtime Deployments
Can you deploy your database changes without any downtime? Steve Jones has a few notes.
2015-07-27
128 reads
What We Want and What We'll Pay For
The challenges of getting enough resources for our projects aren't always apparent.
2015-07-27
148 reads
Is Skynet Coming?
The poll this week looks to the future and artificial intelligence. Steve Jones wonders if we'll ever really see this.
2015-07-24
163 reads
The Evolving DBA
The job of the DBA is constantly evolving, but one thing has always been critical: access to data.
2015-07-23
248 reads
There Are Always Constraints
We must learn to deal with the reality of our situation, along with the limitations.
2015-07-21
125 reads
Are DacPacs ready for prime-time?
DacPacs have been around for a while but DBAs have not, in the past, taken them particularly seriously. Is it time to get involved and influence the way the technology develops?
2015-07-20
187 reads
Presenting Data
One important skill is for the DBA or developer of the future is being sure they can present data to clients in a way they can use it.
2015-07-20
203 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