ah the joys of rollbacks and killed users!! sadly rollbacks seem to take so long - if you get all other users out of the DB it may help! ...

I fear to ask why!! Can you define what you mean by duplicate exactly.I tend to support apps which have no named users as they come through a web...

I still think it was a valid comment, maybe your question could have been worded differently? I'm not trying to put anyone down but see it another way - suppose...

The whole point about performance tuning is that it's not just a case of running a few dmv queries and there's no magic solution - you only get to learn...

is there actually anything in the log? Just cos it's 150GB doesn't mean there's any data.

Other point is that you should check for aged open transactions as the log cannot...

the safest way is to use output variables or return values ( if one number ) to get that sort of info.

Generally you'd want to have set nocount on in...

good move - don't understand why anyone uses 32 bit any more.

isn't a bit scary when a DBA asks this question?

kindle is very good - long battery life and easy to read.

I carry my work/docs on dvd, memorystick and portable hard drive

well I sort of have this problem with linked server calls ( but not with views ) you can name your linked server to be anything .. in...

If only it was that simple! What seems like a good idea with a couple of rows in each table turns into a nightmare 5 yeears later!

Without breaking confidentiality --...

Usually with mixed versions you put the lower version on first. I must admit I'd be reluctant to adopt this even though I believe it can be done. I must...

cpu reported inside sql server dmvs has little bearing on anything you can relate to the cpu %age counter in perfmon. Most of these measurements are cpu milliseconds with some...

generally I always considered that the speed of the t-log was key - no transaction is complete until it's been logged, not that I've even been able to improve t...

hmm .. tricky. The boxes shouldn't make any difference - that's the joy of log shipping, I've used since sql 6.5 but my own implementation.

I usually check the headers as...