I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...
2020-06-18 (first published: 2020-06-04)
431 reads
2020-06-04
86 reads
Databricks is fantastic, but there is a small issue with how people use it. The problem is that Databricks is all things to all people. Data scientists and data...
2020-06-03
18 reads
Databricks is fantastic, but there is a small issue with how people use it. The problem is that Databricks is all things to all people. Data scientists and data...
2020-06-03
204 reads
I wrote about sequences in an editorial recently and decided to start using them. Creating one turned out to be surprisingly easy. I had a table I’d been logging...
2020-06-19 (first published: 2020-06-03)
363 reads
An online conference is coming on June 17, 2020 that is full of high level content. It’s the type of event that I think contains information relatively few people...
2020-06-03
86 reads
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever...
2020-06-03
340 reads
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
18 reads
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
177 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-03
18 reads
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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