SQL Social in Kent
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
2010-08-10
1,683 reads
Press Release
TSQL Challenge 36 - Create a graph/Chart with TSQL
This challenge invites you to create a graph/chart using T-SQL
2010-08-09
3,807 reads
Million Dollar Challenge, The Sequel
Red Gate Software is having another million dollar challenge. If you work for a small software company, or have a software product of your own, read about the challenge.
2010-08-06
4,013 reads
Vote For The PASS SQLRally Logo
Take a moment and vote on the new SQL Rally logo that will be used for the event next spring.
2010-08-06
1,762 reads
Parallelism and Performance: Are You Getting Full Return on Your CPU Investment?
A webinar from the PASS Performance VC on Aug 3, 2010
2010-08-02
3,198 reads
TSQL Challenge 35 - Find the total number of 'Full Attendees' in 24HOP
This challenge has a (fake) reference to the 24 Hours of PASS event and your task is to count the number of attendees who watched the complete presentation of each speaker.
2010-07-26
1,476 reads
Top Ten Reasons to Attend the 2010 PASS Community Summit
There are some good reasons to think about attending the 2010 PASS Community Summit.
2010-07-23 (first published: 2010-02-25)
3,782 reads
TSQL Challenge 34-Search for two keywords within the maximum distance
This challenge is all about searching for two keywords in a string with a maximum distance of 'one word' between them.
2010-07-12
1,702 reads
Performance Impacts Related to Different Function Types
The July 2010 PASS Performance VC Presentation by Jason Strate on July 6th 12:00 PM EDT (GMT -4).
2010-07-06 (first published: 2010-07-01)
3,242 reads
Come Vacation on the SQL Cruise
This fall you have the chance to learn from a number of SQL Server experts and get a little vacation at the same time on a SQL Cruise.
2010-06-30
1,786 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