In which Phil ruminates on the ridiculous idea that we in the West suffer from an IT skills shortage. In truth we have a very blinkered idea of the sort of person who would succeed in an IT Development role
2014-03-31
222 reads
Steve Jones talks about the women in technology, and other efforts to help minorities.
2014-03-31
144 reads
All our environments for SQL Server are different, but Andy Warren wonders if each of us might have a "perfect environment." Would things be standardized to make administration consistent? Or perhaps flexible to allow each instance to be tailored to its own needs.
2014-03-28
178 reads
Steve Jones notes that security can be a reason to upgrade your systems, but it can also result in an endless cycle.
2014-03-26
127 reads
Day 2 at the PASS Summit provides some inspiration for Steve Jones at the Women in Technology luncheon.
2014-03-25 (first published: 2009-11-05)
152 reads
Schemas may be largely irrelevant to small databases, where it is no trouble to assign permissions to individual objects, but they are vital for a hard working corporate database that is being actively developed and used by several applications, with thousands of objects that must be assigned the correct permission.
2014-03-24
222 reads
Testing our applications is important, but at what level do we need to test? Steve Jones talks about unit testing today, and wonders if this is prevalent for SQL Server developers.
2014-03-24 (first published: 2009-11-10)
537 reads
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
2014-03-20
111 reads
2014-03-19
477 reads
Many people have been unsure of cloud computing and what it means for your particular application. Steve Jones notes there's a great new demo that can help you get started exploring the Azure offerings.
2014-03-17
180 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