Frustration with Bad Design
It can be frustrating to deal with poorly implemented systems, but Steve Jones notes that you can't take things into your own hands.
2014-07-28
306 reads
Editorials
Frustration with Bad Design
It can be very easy for technology experts to get frustrated when they see bad design and practices, but you must be careful with how you go about trying to influence change.
2014-07-28
27 reads
Summer, Summer, Summertime
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
2014-07-25
111 reads
2014-07-23
751 reads
2014-07-22
262 reads
A IT Consultant for our Times
Phil Factor explains that being a consultant in the latest IT hot topic is a worthy role. Someone has to do it, and Phil explains why.
2014-07-21
183 reads
2014-07-21
167 reads
What Is the Hardest Feature to Learn About SQL Server?
SQL Server is a complex product and many of us work with only a small part of the product. However many of us will have exposure to quite a few features inside of the platform. Today Andy Warren asks you if there is some feature that's harder than others.
2014-07-18
532 reads
Access Disdain
Today Andy Warren looks back at his career with Access and why he doesn't see it as a tool to be avoided.
2014-07-17
246 reads
Not Good Enough For Government Work
The complexity of financial trading systems is too much for an amateur approach, as the losses of various Bitcoin exchanges show.
2014-07-15
344 reads
Blogs
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...
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...
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