SQLServerCentral.com Blogs
They're here, ready and waiting for the community to dig in and enjoy. Read a little about them and how you can get your own SQLServerCentral.com blog.
2005-07-14
3,255 reads
Press Release
The Last Day To Save
If you have not registered for the 2005 PASS Summit, today is the day to do so. The conference fee goes up after today, so call your boss and get registered.
2005-06-30
2,869 reads
The July SQL Server Standard - Replication
We've just sent the July issue of the SQL Server Standard to the printer and it should be shipping out to you subscribers next week. The e-version should be in your virtual briefcase and it should be at the PASS and MCP sites soon. Read the editorial and see what's in this issue.
2005-06-23
4,588 reads
Help Us Out For A Free Gift
We would like to offer a free copy of the May 2004 SQL Server Standard magazine to everyone who can take a couple minutes to update some demographics for us.
2005-06-08 (first published: 2005-05-25)
6,381 reads
A Look Back at the 2005 PASS European Conference in May
Kurt Windisch, Vice President of the Professional Association for SQL Server, recently returned from their European Conference. He shares a few notes on the event which was held earlier this month in Germany.
2005-05-31
2,885 reads
SQL Server Standard for MCPs
It's back after some negotiating the myriad of groups at Microsoft, the SQL Server Standard is back for Microsoft MCPs.
2005-05-31
6,014 reads
The SQLServerCentral.com IT Research Library
We've partnered with BitPipe and TechTarget to bring a huge collection of white papers and other valuable information to you for free!
2005-05-12
3,682 reads
The BestOf vol. 3 and Stumpers Vol. 2
New books from SQLServerCentral.com. The latest versions of our very popular SQL Server reference materials are now available.
2005-05-11
5,080 reads
SQL Server 2000 Service Pack 4
It's now available!! Find out what's in there and where you can get it.
2005-05-09
22,019 reads
Steel City SQL
If you're in the Birmingham area, a new SQL Server users group, affiliated with PASS is forming. User groups are a great way to meet people and do some networking in your area. The first meeting is later this month, so if you can, drop by.
2005-05-05
3,073 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