Your Job Description
This Friday Steve Jones talks about job posting and descriptions. This is the chance to think about what you do and how you might describe this to your replacement.
2017-06-16
116 reads
Editorials
Securing the Things
The Internet of Things is coming, and bringing lots of data, but security needs to be included as well.
2017-06-15
58 reads
2017-06-14
1,395 reads
2017-06-13
70 reads
Guilty of Over-Customising
Am I guilty of over-customising software? Read this and let us know what you think.
2017-06-12
116 reads
The Value of Surveys
Phil Factor on the perils of trying to squeeze good insights out of bad surveys.
2017-06-12
78 reads
SQL Server is Getting Smarter
SQL Server is becoming more capable all the time, requiring fewer human resources for basic management.
2017-06-08
93 reads
2017-06-06
111 reads
2017-06-05
89 reads
Wanna Cry? Me too
I don’t doubt for a minute that on a certain level you’re sick to death of people talking about the Wanna Cry ransomware. However, bear with me, we need to go through it just a little more because it actually has some bearing on us as data professionals. OK, more than some bearing, it’s a […]
2017-06-05
200 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