2016-10-14
456 reads
Editorials
Developer Deployment Frustrations
SQL Server should work to make it easy for developers to work with it, and include versions like Express in their applications.
2016-10-11 (first published: 2010-09-08)
374 reads
Bingle is my Senior DBA
When working with SQL Server, many people don't need the search engine to be their junior DBA, they need it to be their senior DBA.
2016-10-10
162 reads
DBA Support
This Friday Steve Jones talks about your support load. Let us know how many databases you support and what the load is like.
2016-10-07 (first published: 2012-10-26)
252 reads
A Software Warranty
Steve Jones says that developers should take responsibility for the code they deploy, perhaps with a warranty of sorts inside their company.
2016-10-06 (first published: 2012-10-22)
163 reads
Do you have DBA syndrome?
Sometimes DBAs become resistant to change. When they lose focus on their full purpose they may have DBA syndrome.
2016-10-05
156 reads
Questioning the Interviewer
Asking questions in an interview is important, but there can be issues. Steve Jones talks a little about how to approach this.
2016-10-04 (first published: 2012-10-15)
567 reads
Coming Attacks
What happens if we can't access the Internet? We should be prepared, at home and work. Steve Jones has a few comments.
2016-10-03
103 reads
Intelligence from Data
This week Steve Jones looks at the idea of using AI and machine learning with your data to develop amazing new insight.
2016-10-03
56 reads
The Exciting World of Data
Steve Jones gave a keynote, and has a little fun this week with the topic of his talk.
2016-09-30
85 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
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