commits won't do anything - if you were running with uncommitted transactions then your app wouldn't work anyway. So what is actually running that causes the growth? Are you making...

not always, you'd be surprised - but this is a desperate measure, after all.

The reason you will struggle to find such a tool is the limitations that compressed text would place on your logical operations, you would only be able to search by...

I think profiler still creates files even if writing to a table. I'd have thought the message was clear enough  although another process could have required disk space.

Beware of killing processes without knowing what they are.

If you have backups and/or don't mind the risk, rebooting your server may help.

I've used Idera Diagnostic Manager for around 8 years, ( it was sql probe originally ) Beware of Spotlight products they can impose around 10% load when running, I've always...

This is pretty basic T SQL, could I suggest that if you have to ask this then the purchase of a couple of good books or a training course would...

If you check Technet you'll find an article on how to interpret the datra stored within sysperfinfo, which isn't stored quite how you might think it is!

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

Yes I use...

I agree with Rudy, batched bcp. I have moved 100Gb tables about and I always take the batch approach. You could probably have done it by now < grin >

I...

Best is to use seperate account for each server and place them in a group. I've never yet used different accounts for agent and sql, but I can see reasons...

you can't do what you're asking as such. Turning the destination database to simple recovery will decrease the effect of logging in the transfer. You could bcp out, zip, transfer,...

sam you're right, unless you use dirty reads writers block readers, especially those bringing back multiple rows.

rohini you need to read up on transactions and isolation levels to understand how...

OK first point .. if your table is fragmented at leaf level and is a heap ( no clustered index ) then no matter how many times you rebuild indexes...

The only comment I'd make is that the order of columns in a covered index "just depends" , generally the most restrictive ( selective) is best placed first - but...

Hmmm .. that's at the top end of what a permanent DBA might get in the UK, I work as a contractor so my earnings are all based upon different...