SQL Saturday #48 - Columbia
SQL Saturday Columbia, SC gives you a chance to get a full day of free SQL Server information, lectures, and seminars from the experts on the East Coast.
2010-09-10
1,014 reads
Press Release
Webinar: Turn your backups into live databases with SQL Virtual Restore
Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
2010-09-09
1,099 reads
TSQL Challenge 38 - Calculate SQL Stars awarded to the Winners of TSQL
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,479 reads
Introduction to SQL Server Statistics
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
2010-09-03
4,097 reads
SQLBits - The 7 Wonders of SQL
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
2010-09-03 (first published: 2010-07-29)
4,130 reads
SQL Saturday #50 - East Iowa
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
2010-09-03
954 reads
Tracy Hamlin, Exceptional DBA of 2010, on what it means to go the extra mile
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
2010-08-24
2,734 reads
Tracy Hamlin elected Exceptional DBA of 2010
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
2010-08-23
1,560 reads
TSQL Challenge 37 - Calculate the downtime and duration of servers bas
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,522 reads
Improving database development with SQL Source Control
A webinar sponsored by Red Gate Software showing you how easy it can be to source control your database code. Thursday, August 19, 2010 12:00 PM EDT
2010-08-17 (first published: 2010-08-05)
4,666 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