Bias, the Serial Killer of Diversity
Today we have a guest editorial from Kellyn Pot'Vin that tackles the tough topic of diversity.
2016-05-27
168 reads
Editorials
Should I Stay or Go?
Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.
2016-05-26
165 reads
The Clustered Index is not the Primary Key
As the title says, the clustered index doesn't have to the primary key and vice versa.
2016-05-24
1,504 reads
Boundless Opportunities
There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what's on her current learning list and why.
2016-05-23
171 reads
The Politics of SQL Security
Dealing with SQL Server security when the application it uses is full of security holes.
2016-05-23
211 reads
What's Your Test Plan?
This week Steve Jones looks at the formal way in which you might verify changes to your system. Do you have a process?
2016-05-20
240 reads
The Complexity of Branches
Branching code creates complexity to development and should be undertaken with caution.
2016-05-19
101 reads
Half Baked Features
Steve Jones notes that some features aren't fully developed, but that's not a reason to avoid releasing them.
2016-05-17
161 reads
Software Maturity with Release Management
Adding a release management tool to your software development is a sign of maturity.
2016-05-16
75 reads
SQL Server RTM - June 1
The next version of SQL Server 2016 will be released on June 1, 2016, which means you can start planning those upgrades.
2016-05-16
121 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