Porting SQLServerCentral
Steve talks about the project underway to port the SQLServerCentral codebase.
2018-12-27
139 reads
Editorials
Better Static Code Analysis and Security Scans
One of the best ways to improve software is to evaluate it sooner, which includes static analysis. We don't have many tools for database code, but we need more.
2018-12-26
47 reads
2018-12-25
42 reads
2018-12-24
72 reads
2018-12-24
65 reads
2018-12-21
904 reads
Spend More on Security
With a data breach at Marriot, there is a call from one person for companies to spend more on security.
2018-12-20
42 reads
Get Patched If Not Supported
Many organizations that run older versions of SQL Server are not patched.
2018-12-19
64 reads
2018-12-18
59 reads
Deploy the Database First
Steve Jones thinks it's important that we be able to deploy almost any changes to our databases without breaking applications.
2018-12-17 (first published: 2015-01-26)
193 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