Tara,

Here is a very good KB about shrinking tempdb.

http://support.microsoft.com/kb/307487

As you see Methods 1 and 3 require a restart.

The issue with Method 2 is that if your system is quiet and...

Here is a good link about deadlocks - http://msdn.microsoft.com/en-us/library/ms178104.aspx

Grant

The load on tempdb absolutely increases. You have to be sure that you have that configured correctly and that you can support more space in tempdb. Other than that, it...

Second the nomination for Full Text Indexing. I have seen tremendous improvements when using it.

This is a great article, and well thought out. I have been in the process of writing something that I can use here - but not to this extent.

I am...

Have you checked your indexing on the replicated data as well as statistics and fragmentation?

yet another one who thought GREAT, a really simple one! to find that we must read minds to know what the real question is.

Excellent question. Got it wrong - but learned a lot.:-)

Good luck

Carol,

Have you tried to use Bulk Insert, setting a batch size?

This will control the growth of the T-Log as well as potentially increase performance of your insert

I agree totally with Howard, except that if I have a candidate who has proven experience and one with a certification and can't prove their experience I would take the...

Especially if I don't see real experience with it.

I have had both work for me...

There are numerous circumstances which can cause locking as well as lock escalation.

I thank all of those who made their comments but have finally found the answer to my question,...

The /3GB switch is not set. The locking is occuring during the weekly load which is performed using an openrowset from various other servers. Once we are through the load,...

This box is being running our datawarehouse currently. in the future it is being transformed into the central distribution for our replication.

please state why you think...