The Bad Data Shutdown
Not more hacking, but rather a data error in some cars is disturbing to Steve Jones.
2016-07-05
131 reads
Editorials
2016-07-04
85 reads
An example of how networking netted a new job
Today we have a guest editorial as Steve is away on vacation. You often hear about how important it is to network. This is a story of how my network helped me get a new job.
2016-07-01
99 reads
Monitoring and Alerting
Knowing what is happening on your systems, and being told when a system is not behaving normally is very important for administrators. Steve Jones has a few thoughts on monitoring today.
2016-06-30
272 reads
Email or Username
One of the things that can be an issue in database design is the data used to identify a user.
2016-06-29
120 reads
Democratic Data Science
Data science is hot now, but work is being done to use the power of software to handle some of the grunt work with data analysis problems.
2016-06-28
100 reads
DevOps and Security
Are DevOps and security diametrically opposed? An interesting pieces says no, and Steve Jones comments.
2016-06-27
86 reads
SQL Server 2016 is Out and It's Fabulous!
On the First of June, SQL Server 2016 was officially released. While it is still early days to measure the full impact of the release, the one thing that is exceedingly clear is that this is a very successful software release. There have been very few complaints online beyond the standard heard during any upgrade: […]
2016-06-27
168 reads
Have You Designed a Database from Scratch?
An interesting question from Steve Jones today, asking what is your experience with designing databases.
2016-06-24
191 reads
Why Use R Services?
R Services were added to SQL Server 2016, and there are customers using this feature to improve their business processes.
2016-06-23
194 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