2018-08-07
237 reads
Editorials
I'm Not a Lawyer, But...
Over the last 18 months or so, I’ve spent a lot of time reading about the General Data Protection Regulation or GDPR. If you don’t know about it, you live under a rock, are a very old school dba, here’s a reference to the law itself. If you’re working as a data professional, I’d strongly […]
2018-08-06
93 reads
Will Terminators Be Required?
The use of terminators in T-SQL is incredibly inconsistent. Steve Jones thinks it will always be this way.
2018-08-06
93 reads
Is SQL Server Mature?
This Friday Steve Jones is wondering if the SQL Server platform does the job well enough for most people, or are there holes that need to be filled with new features.
2018-08-03 (first published: 2014-09-26)
244 reads
Handling Inconvenient Requests
Brad gives a little guidance on how you might want to respond to inconvenient requests with an eye on doing yourself a favor.
2018-08-02 (first published: 2009-12-07)
438 reads
CI and CD Aren't Magic
The techniques for Continuous Integration (CI) and Continuous Delivery (CD) don't make software better by themselves. It takes some investment and work by your staff as well.
2018-08-01 (first published: 2014-10-27)
165 reads
Have You Been Hacked?
Security is a big deal, and Steve Jones wonders if most data professionals would be aware that they had been hacked.
2018-07-31 (first published: 2014-10-30)
239 reads
When someone asks you what you do for work, how do you answer?
In many ways job titles matter, just not when telling a stranger what you do for work.
2018-07-30
597 reads
Why Volunteering May be a Bad Idea for You
Recently, as I was doing some work for the upcoming PASS Summit, a question popped in my head: “Why am I doing this?” It reminded me of the time when I was young (and idealistic). I went to the leader of a non-profit group asked about making it my permanent vocation. The leader looked at […]
2018-07-30
85 reads
What's a Toaster?
There are always generic items that we encounter in life, things where it doesn't seem to matter to each of us what brand/price/model we pick. This Friday Steve Jones asks what you might consider to be generic in your job.
2018-07-27 (first published: 2010-02-05)
407 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