Transact-SQL in 2005
The March issue of the SQL Server Standard is now available for purchase, download, and should arrive in your mailbox any day. Check out the Table of Contents and read the editorial.
2006-02-22
7,103 reads
Press Release
Free SQL Server Event in Jacksonville, FL
If you live in Florida, join our SQLServerCentral.com's Brian Knight for a Jacksonville SQL Server launch. This free event for developers and DBAs has loads of excellent content from Microsoft and area consultants.
2006-01-27
1,178 reads
Learn SQL Server Management Studio
The new central tool for SQL Server 2005 is the SQL Server Management Studio and you can do most anything with it. Learn about this new utility and get a head start on SQL Server 2005 with a new book from SQLServerCentral.com by Dale Elizabeth Corey.
2006-01-23
23,424 reads
New 64-bit sqlSentry Enhances Performance and Scalability
sqlSentry, a leading developer of management solutions for Microsoft SQL Server, today announced that it has released the 64-bit version of its industry-leading scheduling and notification management system for SQL Server 2005, supporting both x64 and Itanium-based systems.
2006-01-11
2,715 reads
Securing SQL Server
the January magazine is being printed right now and should be mailed out early next week. Read the editorial and see how you can get you e-copy now!
2006-01-03
4,847 reads
Pro SQL Server 2005
Apress is giving away some copies of this book on SQLServerCentral.com by sponsoring our Question of the Day. A sample chapter is also available online now!
2005-12-15
4,654 reads
SQLDBControl BETA Testers Wanted
A new product has just been released in Beta to help you with source control for your SQL Server development. Beta testers are wanted, so if you're interested, read on.
2005-12-01
3,729 reads
Cryptography In The Database
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
2005-11-07
3,855 reads
November SQL Server Standard - Business Intelligence
The November issue of the SQL Server Standard is out and being mailed to everyone. Read the editorial and get the table of contents.
2005-11-03
3,304 reads
New Survey: Why Upgrade MS SQL Server?
Take this survey for a chance at a $20 gift certificate from Amazon. Give your reasons to upgrade and your insight on performance issues.
2005-11-01
4,583 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