SQL Saturday #222
SQL Saturday is coming to Sacramento on July 27, 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday also features a paid-for full day pre-con session with Kalen Delaney
2013-07-17
429 reads
Press Release
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
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)
332 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
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Alamat BCA KCP Cideng Timur Telp:0821-8200-203
Telp/Wa 628218200203 Jl. Cideng Timur No.11 F, RT.5/RW.4, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Alamat BCA KCP KEM Tower Telp:0821-8200-233
Telp/Wa 628218200233 Kem Tower, Jl. Landas Pacu Barat No.Kav 2 Blok B, RW.10, Gn....
Question of the Day
Using CHOOSE()
We have this code that sets some status values and then queries them using the CHOOSE() function in SQL Server 2025.
CREATE TABLE Status
(
StatusID INT,
StatusDescription VARCHAR(20)
);
GO
INSERT dbo.Status
(
StatusID,
StatusDescription
)
VALUES
(0, 'Uncategorized'),
(1, 'Active'),
(2, 'Inactive'),
(3, 'Temp');
GO
SELECT CHOOSE(StatusID, 'Unknown', 'Active', 'Inactive', 'Temporary')
FROM Status;
When the SELECT runs, what is returned? See possible answers