How do you know when it is time to leave a job?
Today we have a guest editorial from Ben Kubicek as Steve is traveling out of town. I discovered I had stayed at a job about two years too long. Why was that?
2016-07-22
217 reads
Editorials
The Relentless Cloud
The march to the cloud is ongoing and Steve Jones says you should prepare yourself. Even if your company doesn't move.
2016-07-20
114 reads
Scary Deployments
Today Steve Jones talks about the problem of having code that people are afraid to change or deploy.
2016-07-19
143 reads
Security is Getting Serious
Today Steve Jones notes that back doors could be inserted into chips, which would be a huge problem.
2016-07-18
96 reads
The Remote DBA
This Friday, Steve Jones asks if you're like to work remotely. With the trend moving this way, mostly for extra hours, maybe you'd like to move that way for most of your work time.
2016-07-15
211 reads
Losing Rows
MongoDB can lose some rows in queries run very close together. Is that bad? Steve Jones thinks so, though this doesn't mean you shouldn't use MongoDB or any other NoSQL database.
2016-07-13
127 reads
2016-07-12
207 reads
New Mobile Attack Vectors
With many mobile phones containing malware, Steve Jones notes this could be a problem for data professionals.
2016-07-11
57 reads
The Need for Database Intelligence Software
A brief editorial on future database engines having built in intelligence.
2016-07-08
204 reads
Fuzzy Processing
There are times when you don't want to get exact mathematical calculations in data processing, and Steve Jones talks about one of them today.
2016-07-07
121 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
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