When we look to improve software, we are often expressing our opinion on which items need to be handled first. It's helpful to keep in mind that it's an opinion being expressed, and not a vote, no matter how much it is solicited by a company.
2017-08-17 (first published: 2013-08-19)
134 reads
2017-08-16
929 reads
Hiring a diverse group of people can make your team work better. Steve Jones has a few thoughts today.
2017-08-15 (first published: 2013-07-22)
204 reads
Hiring senior people is hard, but Steve Jones stumbled upon an idea that compares hiring technology people to hiring a senior level technology expert.
2017-08-14 (first published: 2013-07-11)
362 reads
Phil Factor advocates paying attention when it doesn't matter to prepare for when it does.
2017-08-14
121 reads
For today's Friday poll we have a guest editorial from Jeff Moden. The head of the anti-RBAR alliance has spent a lot of time trying to help others write better T-SQL and solve their problems with code that performs well. However this Friday Jeff asks about the CLR and how you are using it, or not using it, in the real world.
2017-08-11 (first published: 2009-12-11)
774 reads
There are any number of ways to help your career move forward. Steve Jones talks about one way you might not have thought about today.
2017-08-10 (first published: 2013-04-23)
455 reads
Phil Factor's a 'tethered goat' database taught in the value of database intrusion detection and of "defense in depth".
2017-08-07
113 reads
Redgate is hiring someone to manage Simple Talk, a job just like the one Steve has with SQLServerCentral.
2017-08-03
100 reads
2017-08-02
77 reads
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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