Machine Learning Challenges
Machine Learning is an exciting branch of computer science, but it doesn't solve all our problems.
2018-04-17
82 reads
Editorials
Desperation on the Forums
Grant talks about the challenges of helping people in online forums and getting them to learn rather than grab the first solution.
2018-04-16
150 reads
In Depth Learning at the PASS Summit
The pre-conference sessions for the 2018 PASS Summit were released.
2018-04-16
77 reads
2018-04-13
81 reads
Considering Other Views
When we build software, are we empathetic to how others (literally) view our software?
2018-04-12
87 reads
2018-04-11
66 reads
2018-04-10
178 reads
Stumbling over Words
Phil Factor argues that the ability to write simply and expressively is a much under-valued skill in IT, and explains the main traps to avoid.
2018-04-09
123 reads
What's Downtime?
Steve asks the question today of how you might measure downtime and the scope you are concerned about.
2018-04-09
116 reads
One Size Does Not Fit All
Today we have a guest editorial from Derik Hammer that reminds us that there isn't one solution that will fit all your solutions.
2018-04-06 (first published: 2014-07-16)
208 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