While we're happy that local (Cincinnati) talent Barry Larkin has made it to the HOF, we are happier that Ron Santo FINALLY was...

Some things missing in this performance analysis (in addition to definitely checking top wait states)...

- How many logical processors on this server?

- Are you seeing CPU pressure on the server?

-...

Oh, yeah - one more (sorry, can't limit it)

CherryHolmes.

What's in my traveling pack now...

1. Asleep at the Wheel - Live & Kickin'

2. Riders in the Sky - Silver Jubilee

3. Erich Kunzel & Cincinnati Pops - American Jubilee

4. A...

Trader Joe's 50% less salt dry roasted Almonds.

Valrhona (also from Trader Joe's) 71% Cacao chocolate bar (2 squares).

Celestial Seasonings Bengal Spice tea.

I agree with Vladan. 

If this is a staging table to be refreshed then used for validation, it appears that loading the text files into a table with no index,...

Chuck,

Because you specifically asked whether it was more efficient to load the table before or after the clustered index was created, I have to take exception with some of the...

Since you are getting the log full message when running the DTS package, I assume the correlation that the DTS package is loading/updating something that is causing the log file...

See KB article http://support.microsoft.com/kb/897572/en-us

FIX: You may receive a memory-related error message when you repeatedly create and destroy an out-of-process COM object within the same batch or stored procedure in...

I just can't quite wean myself away from the keyboard.  What spare time I have is spent with digital photography and scrapbooking - any of my 8 cats being my...