2016-10-31
63 reads
Editorials
Analysis Services Lives On
The release of Analysis Services in Azure means the platform has a future.
2016-10-31
78 reads
Emotions and Decision Making
Today we have a guest editorial from Grant Fritchey that looks at emotions and how they can affect our decision making.
2016-10-28
115 reads
Wasting Time
Things at work that waste your time are impediments to actually getting work done. Management ought to be in the business of removing as many of these things as possible.
2016-10-27 (first published: 2012-10-11)
425 reads
Who is that masked man anyway?
If you are holding, in your organisation, personal data about real people or commerce, it is wrong, and in many cases illegal to do database development work or testing using your production data. This, of course, probably applies to a minority of database systems, but data breaches caused by attacking backups or copies of production […]
2016-10-24
95 reads
Where Do You Run Your R Scripts?
Executing R scripts can be a heavy load. Today Steve Jones wonders if SQL Server is the best place to execute these.
2016-10-20
452 reads
One Million
The number one million has special meaning to many people. And it's a heck of a metric to achieve in a measurement on a database system.
2016-10-19
88 reads
2016-10-18
162 reads
2016-10-17
110 reads
2016-10-17
170 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