Thanks for all the feedback, much appreciated.

As I said previously, writing an article for a SQL Server forum that has enough detail to convey an understanding of a subject, but...

Thanks muhammad.yasir, good spot!

I've looked into this and perhaps the following would more accurately solve the problem....

declare @product_id1 int = 170, @product_id2 int = 169, @class_id int = 1;

SELECT COUNT(*)

...

Adam is my brother, an awsome System...

Adam is my brother, an awsome System...

I include the encapsulation of the query in a TVF in my demo code, because that's how I would use it in the real world.

Not because a TVF with the...

Morning all,

And thanks for the feedback.

A big concern I had with writing the article was it length. The original article was 30 pages long and I knew I had to...

Great article, thanks ed

One question: You said the DLL are machine code. So just to clarify you get a machine code dll and not a clr assembly?

create schema String

go

create function String.SingleQuote() returns nchar(1) as Begin return char(39) end

go

alter function String.QuotedSingleQuote() returns nchar(2) as Begin return replicate(String.SingleQuote(), 2) end

go

select replace('gary''s gary''s', String.SingleQuote(),String.QuotedSingleQuote())

Surely we can find someting more...

Secondly I feel that if you had made the main focus of your article about the solution you've developed for monitoring and analysing indexes that you would have found a...

Thanks for sharing this article with us Daniel.

There is one statement you make which I found interesting.

"It doesn't make sense to maintain one set of indexes for all copies...

Happy new year to everyone.

I have taken some time to look at language trends using google's online trending app. If you view the trending graph in the link, you'll see...

@teodorom

Dude I've been adding in smiley faces with my comments to indicate that I'm being friendly and my comments are in jest. People visit this site to get...

If Alberto Ferrari or Marco Russo were unable to convince you of the languages merits then I very much doubt I can. I feel sorry that you get no satisfaction...

Thanks for the article,

Consider using strongly typed xml and discarding fuzzy checking like datalength > 10

So you're SP's input parameter might be something like @parmeters XML (DOCUMENT dbo.MyXSD)

http://technet.microsoft.com/en-us/library/ms184277.aspx

You...

Thanks for all your feedback (both positive and negative). I've made a correction to the code sample that Christian and others highlighted (thanks).

Regarding the question around the motivation to learn...