Ah - it's over folks. I've made cranky comments on forums before too. And despite using SQL Server since version 7 (though mostly as an evil dev) this...

I think I need an umbrella.

Thanks Luis.

Ouch! Nevermind.

That's interesting. If I run this with execution plans turned on it does indeed do a clustered index scan with ID as the predicate from #TEST_A and do a...

I wrote the T-SQL Flex SSMS add-in to help script selected data to INSERT statements, get highly accurate schema for data returned (including for arbitrary queries, functions, and SPs), and...

The answer to the question "how do I get this complicated query to run faster?" with SQL Server is far too often "repeat yourself".

There is a runtime performance penalty to...

Funny you didn't link to the best product around for Source Control and SQL Server!

http://www.red-gate.com/products/sql-development/sql-source-control/

Thanks for posting this. I am really pleased to see that this exists, and it sounds like BIML may fill the hole with SSIS that has frustrated me for...

This was interesting. Thanks for writing this article.

I do slightly disagree with one part of what you've said which is that SQL doesn't support temporary views. While this...

Thanks for writing this very interesting article!

Interesting article. Regarding the paradox of semicolons on CTEs - the rule is "the statement before the CTE has to end with a semicolon". The reason is that...

I would like to say that this will never happen, but I believe that "workstations" will only get 2 TB of RAM only when it becomes economically sensible to stop...

The difficulty of getting the column headers to repeat with SSRS 2008+ is downright disgraceful. I can't believe this is still an issue in R2. There is no...

My limo (the B train) picks me up every morning and drops me right underneath my building. Then it picks me up and drives me home again at night....

Passing a table valued parameter to a table valued function. OH YEAH!!!