Let’s forget about performance for a moment, or even user-facing processes at all. A lot of tasks are admin-related and require at least the concept of looping, if not an explicit loop or cursor (or multiple). Think about how you would do these things in T-SQL otherwise:  The search ultimately needs to check every string column in … Read more 4 Practical Use Cases for Grouped Concatenation

What Prompted This Post? As lots of you know already, Kevin Kline has joined us here at SQL Sentry. I’ve followed Kevin myself for a good while, so I’m really excited to have him here with us. One of the first things Kevin asked of me was to list the top 5 technical issues we … Read more The Top 5 Most Common SQL Server Performance Problems