Excellent article. You did a great job of explaining why table variables often perform poorly when they have many rows and are joined, especially in complex T-SQL. I did run...

I assume you created a login, and then created a user account mapped to that login for at least one user database. do they have this database defined as their...

You will have to either get the source code from the contractor or decrypt the trigger yourself. I attached code you can use to decrypt objects, but you will have...

What do you get if you execute sp_helptext [triggerName]?

One option would be to spread tempdb over more spindles. Another alternative would be to install an additional instance on the server and place the tempdb for that instance on...

Yes. My understanding is that he is already recompiling the procedure each time and that hasn't solved the problem.

1. If I keep the recompile code, is...

Why do you say that?[/quote]

Parameter sniffing is the process whereby the optimizer uses...

Can you send the xml of the actual execution plan.

One possibility is to use the option (optimize for (@var = value)) query hint. This might work if the distribution/frequency of the parameter you are using is in fact average...

You could apply the additional hotfixes, but I wouldn't do that, I would just leave it alone.

I use several methods for doing this including SSIS, OPENROWSET, C#, and replication. I'll discuss the factors that lead me in one direction or another briefly.

If the source table...

These are just different cumulative update packs for service pack 3. Check out Steve Jones post:

http://www.sqlservercentral.com/articles/Administration/2960/

As long as they are all on Service pack 3 you should be good. The...

Couple things to check. Go to configuration Manager and check the protocols. Make sure Named pipes and TCP/IP are enabled under SQL Server Network Configuration and under SQL Native Client...

While user connections do take up a small amount of memory in SQL Server instance, it is for the most part insignificant. A better way to calculate how much memory...

You got me! I was starting to get into the groove of my day and after several jokes I had temporarily forgotten what day it is. . . Your article...