2016-08-04
238 reads
Editorials
Moving Fast at Redgate
It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.
2016-08-02
97 reads
2016-08-01
75 reads
Passwords Under Pressure
Passwords are a problem, especially when we're in a hurry. What should we do?
2016-08-01
93 reads
How Far Have You Traveled for a SQL Saturday?
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
2016-07-29
111 reads
Too Much Information for Sports
Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.
2016-07-28
83 reads
Learning to Search
Today Steve Jones notes that the ability to search if invaluable as the amount of information, or even objects, we deal with grows.
2016-07-27
101 reads
A Buggy Release
Releasing software is stressful, and as Steve Jones notes today, can cause bankruptcy if you don't have a solid process.
2016-07-26
105 reads
2016-07-25
82 reads
Where's the Unit Testing?
Today Steve Jones wonders why we don't unit test more, especially for databases.
2016-07-25
129 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