Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
12 reads
Jack Corbett
- Interests: Sports, books, Bible
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions...
2011-01-05
813 reads
Who Should Vote for PASS SQLRally Sessions
Adam Machanic (@AdamMachanic) asked on Twitter if people who aren’t planning on attending PASS SQLRally should still vote for sessions on the schedule. My answer is a resounding...
2011-01-05
11 reads
PASS SQLRally Update–Voting Pushed Back
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. ...
2011-01-04
374 reads
PASS SQLRally Update–Voting Pushed Back
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. Unfortunately we are having to push back the voting...
2011-01-04
7 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals,...
2011-01-03
455 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals, and I read Brent Ozar’s post, Goals? Where we’re...
2011-01-03
8 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did...
2010-12-30
1,427 reads
Reviewing My 2010 Goals
You can go over my goals here. I’ve really hesitated to do this post because, in my opinion, I did so poorly. Here’s what I did: Community ...
2010-12-30
9 reads
PASS SQLRally Call For Speakers Update
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over...
2010-12-13
329 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