The SQL Connectivity Team wants your opinion
Take this survey from the SQL Server developer team at Microsoft.
2009-10-06
907 reads
Press Release
TSQL Challenge #14
A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12
2009-10-01
3,616 reads
Free Training in October - SQL Saturdays Around the US
There are a number of SQL Saturday events around the country in October: Redmond, Gainesville, Orlando, Louisville, and Cedar Rapids. Read more about these events.
2009-09-24
1,911 reads
Grow Your Network - Come to the PASS Summit!
The 2009 PASS Summit is Nov 2-5, 2009 in Seattle. Come and grow your network, while learning about SQL Server.
2009-09-17 (first published: 2009-05-12)
728 reads
T-SQL Challenge #13
Take T-SQL Challenge #13, Break a batch of invoices into multiple parts based on rules.
2009-09-15
4,471 reads
Less Than a Week - PASS 2009 Summit
A last push for the 2009 PASS Summit before registration goes up.
2009-09-10
19 reads
SQL Bits
The next SQLBits conference is being held Nov 19-21, 2009 in Newport, UK. If you want to attend or even speak, read more about this event.
2009-08-27
1,542 reads
SQL Lunch with the Baton Rouge Area SQL Users Group
It's on Livemeeting and open to everyone. Get some lunch time training in with this group.
2009-08-25
411 reads
The 2009 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
2009-08-19
96 reads
TSQL Challenge #12 - Build sequential ranges of dates with propagation to missing values
Take the new challenge from MVP Jacob Sebastian. Deadline is next Monday.
2009-08-18
4,515 reads
Blogs
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
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...
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