That is possible.  Our stored procedures are not called systematically and the parameters are probably not checked for no data.  I guess just ignore those empty tables.

Thanks for the replies on the sanity check. That is what I assumed. Also I think we have way to many instances on a cluster. I will need...

It is not free form. It is similar to business objects that are simplified for a user to select.  Then the code generates the links and the select to get...

Thanks for the responses.  I already have a tool to extract the TSQL.  I have the statement in a table as a NVarchar(Max).  I was thinking of searching for commas...

Thanks for the reply.  This must just be one of those strange behaviors.  All three of those reasons I thought about and none of them are this case.  The client...

Hoping I can pull you guys back into this discussion because I was partially wrong.  It seems like the index is not this issue.  I recreate the index timing was...

Scott,

I just had a meeting and that is what I am going to try next is to make the index have the PK Auto Id in it.  That would make...

I know I am a bit late in replying.  My theory is correct in this case.  When the column was added the indexes became fragmented (Existing indexes can't find records)...

Thank you very much for these responses they are helping me  with next steps.  I have a baseline DB that when we upgrade (Several DDL scripts) gets the unresponsive query. ...

I do not think I can edit the original post.  I am talking about columns in the table.

These are scripts we run through a program to alter existing tables.  ie...

I solved it with what I have below.  Since I am going to get the DB locally I can take a few liberties with outputing files and such - 

In the SET my thinking is that the fields data is already in the SQL cache.  It would have to be because it is needed for any triggers also by...

Thank you very much

I think I have this in the wrong area.  After doing some looking I see extended event questions in the Admin forum.  If you do have an answer I am...

I did not use TSQL.  I used the gui to do my test.  The compatibility level is grayed out.  I bet you are right that the gui does not work...