How do you deal with disappointment?
Disappointment is hard, but you get to choose how you react to it.
2018-05-14
125 reads
Editorials
2018-05-11
81 reads
Power BI Desktop on the Mac
Power Bi is one of the neatest tools that Microsoft has built for data professionals. It allows anyone to build fantastic interactive visualizations that can help tell a story and help someone make decisions. There have been some amazing demo visualizations from Microsoft customers. I've seen a predictive maintenance visualization for airplanes, one for diabetes […]
2018-05-10
3,628 reads
Anonymisation Confusion
Steve talks about the difference between anonymisation and pseudonymisation, which can be confusing.
2018-05-09
85 reads
Reading Through the Logs
The problems at TSB Bank in the UK have Steve worried about his own records.
2018-05-08
97 reads
2018-05-07
82 reads
The Technology Journey to Disaster
Phil Factor on a journey that started with a decision to introduce a new IT platform, and ended in a disaster that left TSB customers locked out of their accounts, experiencing problems such as zero balances, incorrect currencies, and massively inflated mortgage amounts.
2018-05-07
320 reads
2018-05-04
151 reads
Reasons to Upgrade
There are always reasons to upgrade or avoid upgrading to a new version. Steve Jones has a few thoughts.
2018-05-03
76 reads
Would You Move to Linux for Price?
There's a sale on the price of SQL Server for Linux and Steve wonders if people will move.
2018-05-02
72 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