What's in a Name?
Today we have a guest editorial from Andy Warren as Steve is speaking at SQL Intersection today. Andy talks about how names can impact our world.
2013-10-28
144 reads
Editorials
Image is Everything
How much does the image you project at work matter? Is it more important than the work you do? Steve Jones asks for your opinions for this Friday poll.
2013-10-25 (first published: 2009-01-09)
602 reads
Up Your Value
With the economy in a recession, how should you be managing your career? Steve Jones talks a little about building your brand and showing value to your employer.
2013-10-24 (first published: 2009-03-05)
453 reads
Recharge and Relax
Steve Jones has vacation planned for the remainder of the year and encourages you to make sure you are taking your own time off.
2013-10-23
118 reads
Minor Problems
Steve Jones encourages you to write today on your blog. Don't worry about what anyone else writes; share your own stories and knowledge to grow your brand.
2013-10-22
143 reads
Database Queries and Scalability
Does the database limit the scale of your application? Without a doubt, but that doesn't mean you shouldn't use an RDBMS.
2013-10-21
295 reads
Grow Your Family
This Friday Steve Jones asks you to network at your next event and meet more people in the amazing SQL Server community.
2013-10-18
123 reads
Open Arms
Steve Jones looks back at a networking event this week in Charlotte. Networking is valuable to your career and it can be a tremendous amount of fun as well.
2013-10-17
130 reads
Four Years Later
Are we thinking cloud first for database servers? Steve Jones reflects on predictions made four years ago and thinks about how the world has changed for the cloud.
2013-10-16
153 reads
The Cloud of Destiny
Is SQL Server going to move to the "cloud?" Steve Jones thinks it is and has a few thoughts as he starts off with "cloud week" here at SQLServerCentral.
2013-10-15 (first published: 2009-04-13)
602 reads
Blogs
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...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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