SQLServerCentral.com Email Changes
As we begin a migration to a new hosting facility, we'll keep you informed. The first step is an email migration.
2007-03-07
1,508 reads
Press Release
Upcoming Meeting for Southern New England SQL Server User Group
If you are near Rhode Island, there's a new user group available with SQL Server Guru Grant Fritchey presenting.
2007-02-28
1,179 reads
The 2007 PASS Summit Is Coming to Denver
Register now and Save $300!!! And also come to the SQLServerCentral.com party!
2007-02-20
1,585 reads
SQL Maestro Offers SQLServerCentral.com Members a Discount
SQL Maestro, maker of tools for a variety of database platforms, is offering a 20% discount on their tools to the SQLServerCentral.com
community.
2007-02-07
1,513 reads
Product Discussions, Questions, and Comments
In response to a number of suggestions, we have setup new forums where you can ask and comment about the various third party products that you use with SQL Server.
2007-01-02
1,378 reads
Updated Terms
A few minor changes to our privacy policy and terms, but in the spirit of disclosure, we're making the announcement.
2006-12-22
1,558 reads
Free Phil Factor eBook: Confessions of an IT Manager
Download a 108-page eBook in which Phil Factor lifts the lid on the victories, defeats and absurdities of a career spent in the rough-and-tumble of the IT industry. The paperback will to available to buy from Lulu.com shortly ($25), but the eBook is free for registered Simple-Talk.com users
2006-12-18
2,541 reads
A Special Announcement from Andy, Brian, and Steve
It's been five and a half years since SQLServerCentral.com was founded by Andy, Brian, and Steve. We've greatly enjoyed the time and we're looking forward to many more, but a major announcement today changing the way we will operate in the future.
2006-11-14
11,866 reads
Book Sale
We've put together some great new sale items for that SQL person on your Christmas list. Even if that person is you!
2006-11-10
3,258 reads
Get Your SQL Server Standard Electronically
We've moved the subscriptions for the SQL Server Standard to it's own site and just completed the November issue. Read on for how to access your subscriptions or subscribe today.
2006-10-25
2,127 reads
Blogs
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...
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...
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