Thank You all for the reply.

I am specifically looking for any document published by Microsoft regarding T-SQL standard coding guidelines or best-practices, so that I can suggest developers use...

Thanks for all the suggestions that every one has given me. I have replaced the code for table variables with temp tables. Now it is running fine in prod in...

Load is probably 10% less on the day I was testing. Also the production server is pretty huge server when compared to UAT.

I completely agree with all the arguments/suggesstions that every one has made here. My doubt is the same number of rows are retured for table variable in UAT( which...

Do you mean keep the non-clustered index as is and create a new non-clustered with SKU column and INCLUDE class column?

I'll try these options.

Thanks again for your replies.

Why Class column? Its not used in the where clause right?

I have to check whether we can do this as there will be other SQL statements that might be...

Yes I agree. When I look at the deadlock graph in the management studio, it says that the Process running the Proc has owner mode: U on one of the...

Here is the deadlock xml file. My question is why is Update lock(U) showing up for a SELECT query?

That SELECT query is using non-clustered index of Table2 (which is also...

I have already read this article but this doesn't answer my question(s). Sysperfinfo table gives the info about buffer pool usage by different components.

I am actually looking for how...

Thanks for the reply. But my first question is still a question. Also the other question is what is the performance impact of using the encrytion during Selects, Inserts and...

I donot see any Mail Area in the control panel?

If we are going to use xp_sendmail, then there is no other way than using outlook 2003 client, right? Is ther any other client than this?

We have corporate exchange server,...

I didn't understand about synchronous responsiveness you are talking about? Is there a scenerio which can explain that?

Are there any security vulnerabilities using xp_sendmail? as we will be sending emails to outside users regularly.

But as one of you mentioned above,we will create a wrapper stored proc in...

Users are sometimes complaining that application is running slowly. We did 2 tests but we didn't find any long running sql statements except for one which is running for 5...