From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).

It doesn't matter how well code may be written, that generally...

Of course we don't know the proc parameter types, nor the column types, but I think those are critical to properly understanding whether or not SQL can properly use...

From the nature of some of the code, it looks like all parameters are being passed as NVARCHAR(4000).

It doesn't matter how well code may be written, that generally means that...

Please understand that, due to the nature of your question, I believe this post is the first of one-two spam punch.

If you are not a spammer or a bot, then...

You cannot do INCLUDEs on Clustered Indexes, period.  The reason why is that the Clustered Index IS the table and it already includes all the data.

I posted a...

@lan2022nguyen ,

Thank you for the feedback.

You cannot do INCLUDEs on Clustered Indexes, period.  The reason why is that the Clustered Index IS the table and it already includes all the data.

I posted a link further...

Speaking of volunteers, the Ohio North SQL Saturday (formally SQL Saturday Cleveland) by the Ohio North Data Training group (formally, a PASS group that continues because of people like Grant...

I've not ever had to do this before.  I started at sys.schemas and worked by way up to the other two sys views but, like I said, I've not done...

Ah.  Got it.  Thanks.

You might want to...

First, let me say that I have a grand and genuine appreciation for people that write tools and share them.

I don't, however, have an appreciation for code that doesn't even...

@rajemessage ,

I've found that most people that want to know how to do this are solving a problem the wrong way.  What is the end use of this concatenated string...

@AG , It was running as  legacy. I just took over..I have removed 'Index Maint' from the activities..and also i m not getting any complaints on performance, suggesting ,...

BTW and just to be sure... I totally agree with that statement and so do...

Thanks for the reply Grant.  I agree using this data must be used with caution.  My goal now is to make the stored results more aware of these situations...