Oh, where is my crystal ball again? Couldn't you at least tell us on which column you had the non-clustered index? Even better, share the actual query plans for the...

So I gave some hints in my post.  I also have an article on my web site where I discuss parameter sniffing in more detail, http://www.sommarskog.se/query-plan-mysteries.html.

Yes, with this pattern you can get problems with parameter sniffing. Say that you first run the SP with @kind = 1 and you pass @startday and @endday as NULL....

I can't see any relation to your original question here. You should probably have started a new thread.

There is nothing wrong with the pattern above. In fact, I would say...

You don't need to, but you can change the CATCH handler to:

BEGIN CATCH
   ROLLBACK
   ; THROW
END CATCH

; THROW reraises the error message exactly...

Obviously, we cannot answer any questions without knowledge of what is going on. Wait until you have the issue again and use my beta_lockinfo and share the output so we...

Yes, string_agg is much more straightforward to use.

There are a few things that have been removed since SQL 2008, but not a lot. The COMPUTE BY clause, which I hope...

There is one alternative. But it is worse than the CLR. You can call extended stored procedures from SQL functions, so you can call xp_cmd.... I think I stop there.

(I...

So have you tried troubleshooting the issue with my beta_lockinfo yet? http://www.sommarskog.se/sqlutil/beta_lockinfo.html.

There is no one here can answer what is going on without access to your system - or...

If you look at my example, you see that I have a binary column, you have a string column. When you encrypt data with any of the cell-level encryption methods,...

Why are you starting a new thread on the same question?

Why lock on one particular table is not released(in our case extended property update query)?

Do you seriously believe that anyone...

Your concerned about the performance in .NET? Didn't you complain that the query you had crafted from Brian's input was very slow? Or were you able to resolve that?

My position...

I only write C# left-handedly, so I may not be the best person to ask. Then again, how difficult can it be? You have a data table - transform it...

Scott, with that kind of stack dump, it is clear that "IT Researcher" is working from a GUI and not a query window. In any case, the error details makes...

You can use my beta_lockinfo to find out about locks and blocking in the system, http://www.sommarskog.se/sqlutil/beta_lockinfo.html.