Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
999 reads
Using CROSS APPLY to calculate an aggregate across a single row.
I’ve had CROSS APPLY on the mind recently. You could probably tell since its been the subject of my last...
2013-05-28
1,484 reads
SQL Server – Filtering objects in Object Explorer – Management Studio
When you are working on a database with a large number of objects sometimes it becomes a challenge to locate...
2013-05-28
1,031 reads
Using the SSIS Object Variable as a Result Set Enumerator
In the first post in this series, I covered the basics of object typed variables in SQL Server Integration Services,...
2013-05-28
1,890 reads
Investigating Plan Cache Bloat
SQL Server includes a DMV, sys.dm_exec_query_stats, that returns performance statistics for each query plan cached in memory. However, it can...
2013-05-28
1,149 reads
SQLPerformance.com
I have had the opportunity to go through the first three SQLSkills Immersion Events, and one of the side benefits...
2013-05-28
616 reads
Sum Result of SSRS LookupSet Function
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return...
2013-05-27
7,578 reads
Recap of our SQL Saturday #225 in Kosovo, Prishtina
SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan...
2013-05-27
1,237 reads
How to Size the SQL Server Memory & Why is it important?
The following blog post has 2 objectives.
1) How to size the memory correctly ( or atleast being close to correctly )
2)...
2013-05-27
2,935 reads
Security Questions: Difference between sysadmin and CONTROL SERVER Permission
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-27
865 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...
Using CHOOSE()
Comments posted to this topic are about the item Using CHOOSE()
Re-Seeding a Broken Log Shipping Secondary (Without Touching the Primary)
Comments posted to this topic are about the item Re-Seeding a Broken Log Shipping...
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