Thanks for the feedback Brian.

I'm glad you used the article to consider your approach, as it was my intention to get people thinking about code structure rather than prescribing the...

Is this an April fool?

Covering the += operator might have been a nice way of demonstrating whats happening.

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/string-concatenation-equal-transact-sql

Great article Mr Pollock.

Well written SQL code is often an over looked art and solving the problem is the primary in the developers mind, as you'd expect. But...

I appreciate this work is six years old. But the diagram is not good.

I'd take this down and re-publish once the diagram is re-worked. Otherwise you're  better off...

Hmm, a little harsh.

"

November 27, 2017 at 3:08 am

#1969478

Can anyone recommend a free data generation tool?

Hi,

I have a suggestion regarding script 9...

"Script 9

Execute the test-query and filter for any customer you like. The index will not be used, no matter what your choice. It...

Thanks Chad, this is exactly the sort of article I want read. It took me about 5mins to read and learnt a valuable lesson

Your example uses AdventureWorks2012, which suggests you're using SQL2012.

Then why aren't you using [sys].[all_sql_modules] or [INFORMATION_SCHEMA].[ROUTINES] ???

Creating a new custom sp_helptext seems a fruitless endeavour. I'm struggling to find something...

Steve Jones - SSC Editor (2/24/2015)

There...