Protecting our physical systems usually involves some type of security at the office. For many of this, we have some type of key card system. Andy Warren asks today how you handle things and does it work well.
2013-10-14
155 reads
IT is an industry that hasn't adopted a union, at least not yet. Many IT workers hope it never happens, but what if it does? This Friday Steve Jones asks what benefits you might want from a union.
2013-10-11 (first published: 2009-03-06)
674 reads
In dealing with other professionals, you would like to think most people have good manners. Steve Jones looks to remind us this should apply on the Internet as well.
2013-10-10 (first published: 2009-04-06)
353 reads
Having employees leave your company is a reality of life. But how do you handle letting your IT workers go and protect your systems? Steve Jones isn't sure there is much you can do to prevent issues, but you can deal with them.
2013-10-09 (first published: 2009-03-16)
369 reads
Steve Jones starts the 2013 SQL in the City tour today. At least for him. He's on an airplane in order to be ready for the first US event tomorrow.
2013-10-08
174 reads
A recent survey says IT security is a major concern for many businesses. Steve Jones wonders why they don't make more of an effort to implement better security in their applications and processes.
2013-10-07
159 reads
How many developers does it take to overwhelm a DBA? It's an interesting question, and this week Steve Jones asks how many you actually support.
2013-10-04
188 reads
Writing secure programs is hard. Steve Jones has a few comments on what some of the issues are with training developers.
2013-10-02 (first published: 2009-03-19)
526 reads
Are tape systems obsolete? A recent incident has Steve Jones thinking perhaps not.
2013-10-01 (first published: 2009-03-26)
433 reads
Phil Factor reflects on how the people who made the industry great, in the past, were often eccentric, rebellious, odd, truculent, but all blessed with the gift of creating wonderful software. Today, such people would struggle to get pass the first interview.
2013-09-30
239 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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