SQL Saturday #231 Cocoa Beach
Join us for a free day of SQL Server training and networking on July 27 in Cocoa Beach, Florida.
2013-07-16
2,065 reads
Press Release
SQL Saturday #230 Rheinland
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jul 13 2013 at Grantham-Allee 20, Sankt Augustin, Cologne/Bonn, Rheinland, 53757 , Germany.
2013-07-09 (first published: 2013-07-05)
331 reads
New SQL Monitor Custom Metric: Untrusted Check Constraints
This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.
2013-07-08
2,585 reads
SQL Saturday #214 Louisville KY
Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13.
This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.
2013-07-02
2,303 reads
Free eBook - Control Your Transaction Log so it Doesn't Control You
Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.
2013-06-27
5,550 reads
New SQL Monitor Custom Metric: Database Autogrowth
This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.
2013-06-25
4,095 reads
SQL Server Luxembourg User Group
Come join the SQL Server Luxembourg UG for free training and networking on June 27th at 5:30pm. Soren Nielsen will take a Deep Dive into SQL Server 2012’s “Always On” High Availability technology. This will be followed by Vern Rabe of the SQL User Group in Portland, Oregon, presenting “Data Types - Think You Know It All? Think Again”.
2013-06-25
2,225 reads
SQL Saturday #226 - South Florida
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 29 2013 in Davie, FL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.
2013-06-21
1,808 reads
Attention users running SQL Server 2008 & 2008 R2!
Updates to the latest CUs for SQL Server 2008 and SQL Server 2008 R2 from Aaron Bertrand.
2013-06-18
11,220 reads
PASS Data Architecture Virtual Chapter presents Steve Simon
On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.
2013-06-18
3,871 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