Release Wednesday
One of the teams at Red Gate is releasing new changes every Wednesday, which reminds Steve Jones of a time earlier in his career.
2018-06-20 (first published: 2015-04-08)
112 reads
Editorials
After Six Months On The Job What Challenges Remain?
Today we have a guest editorial from Andy Warren that asks what you might do when you get settled at a new job.
2018-06-19 (first published: 2015-04-10)
252 reads
Providing Feedback to Speakers
One of the greatest things that has arisen in the past 10 years or so is a veritable stream of great conferences for people to learn how to write better software, many of them low cost or even free. In the Data Platform community, we have had nearly 800 free SQL Saturday events around the […]
2018-06-18
58 reads
State v Migrations
Steve Jones talks a bit about the difference between state based and migrations based approaches for deployment.
2018-06-18 (first published: 2015-04-09)
173 reads
More Query Tuning?
What types of sessions are important in a conference schedule? Steve Jones talks a bit about the lack of tuning sessions.
2018-06-15
98 reads
Building Test Data
Steve talks about the importance of test data and how to get it in development environments.
2018-06-14
77 reads
2018-06-13
99 reads
Machine Learning in the Database
Steve talks about Machine Learning Services in SQL Server and whether using this is a good idea.
2018-06-12
183 reads
Be Prepared with Baselines
Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.
2018-06-11
79 reads
2018-06-11
162 reads
Blogs
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...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
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