Becoming a Data Scientist
The path to becoming a data scientist isn't simple or easy, but it might be for you.
2017-04-26
193 reads
Editorials
2017-04-25
281 reads
Have you ever given up on your brainchild
Have you ever given up on your brainchild? If yes, how did you deal with it?
2017-04-24
125 reads
It's all about Customer Service
Grant Fritchey on the lessons all DBAs can learn from the recent Public Relations disaster for United Airlines.
2017-04-24
91 reads
How do you come up with creative ideas?
It takes a creative mind to come up with new ideas. So how do you do it?
2017-04-21
120 reads
2017-04-20
381 reads
SQL Server Telemetry
SQL Server captures information about usage and send it to Microsoft. Is that a problem? Not for Steve Jones.
2017-04-18
873 reads
Liable for Data Loss
Today Steve Jones looks at some data loss lawsuits against Microsoft, but asks the general question of whether software vendors need to be more liable (and careful).
2017-04-17
76 reads
More Power in Your BI
This week Steve looks at all the information and learning available for Power BI.
2017-04-17
126 reads
The Cost of Database Downtime
Do you know what the cost is for your database going down? Maybe more interesting, is do you want to know?
2017-04-14
152 reads
Blogs
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...
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...
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