Try to focus on the positive
When we focus on negative things we get more negative. Be thankful for something positive.
2014-06-10
180 reads
Editorials
2014-06-09
195 reads
Motivating the Team
It's easy to get excited if you work at a startup, or a software company. But for corporate workers that toil in IT departments all around the world, how do you keep them motivated? Steve Jones has a few thoughts about simple things that make workers feel better about their jobs.
2014-06-06 (first published: 2009-10-07)
301 reads
IT and the Older Generation
David Poole looks at the interactions of technology across generations in this guest editorial.
2014-06-02
243 reads
Should your Source Control System understand your code?
Phil Factor ponders why improvements to source control and versioning so often lag behind the pace of progress in development as a whole.
2014-06-02
158 reads
2014-05-30
352 reads
No Works of Art
Manual deployments and configuration of software is akin to creating works of art. Not exactly what Steve Jones would like to see if we are to practice software engineering.
2014-05-29
114 reads
2014-05-28
606 reads
Patching Problems
After some issues with a recent Windows patch, Steve Jones is concerned about the future of software updates.
2014-05-27
372 reads
2014-05-26
170 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