The first week of November, we’ll be at the PASS Summit inSeattle, WA. This is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in. We have a lot of fun, and so I’d like to draw your attention to some of the better bits. Taking part, if […]
Category: sqlserverpedia-syndication
Tip: Concatenate rows with XML, or COALESCE
Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query. Concatenate rows with XML I still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a list. The T-SQL Cheat Sheet example uses a parent-child table combination, […]
Why don’t they make the optimizer faster? (An essay on nested views)
We got a question recently that basically boiled down to this: Nested views shouldn’t be such a performance suck. Why doesn’t Microsoft make the optimizer deal with nested views better? We’ve looked into this a good deal – nested views are one of my pet peeves, and I’ve blogged about it at least a couple of times (see Detangling Nested Views and […]