Following up on Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates, I provide four real-world examples where grouped concatenation allows you to avoid the monotony of cursors and while loops.
Monthly Archive: August 2014
I team up with Grant Fritchey to share an ice cold video for the #iceBucketChallenge, trying to help raise awareness for #ALS, and challenge some colleagues to follow our lead.
Tip : SQL Server Video – Tricks to play on your DBA – 1
I take a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.
Microsoft has released Cumulative Update #3 for SQL Server 2014. Important! This Cumulative Update includes MS14-044, which I blogged about here and also mention here. KB Article: KB #2984923 32 fixes listed publicly at time...
If you are running 2008 SP3, 2008 R2 SP2, 2012 SP1 (SP2 is not affected, RTM is no longer supported), or 2014, you'll want to check out Security Bulletin MS14-044 for details on a...
I use a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.
I show the safest and most efficient ways to perform grouped concatenation in SQL Server.