you need to enable awe

There has been a misconception that awe can only be used with memory over 4Gb - this is not true. In a server with 4GB of ram you have two...

performance isn't too good - you might want to consider using virtual pc or server

yup, I've dropped sp_  into master, works the same as before.

Probably < grin > it's almost textbook question. I usually designate clustered index where it resolves my worst performance \ most important query. If you've got an ascending key on...

I have to be honest that I partitioned the partitioned views, rather than going for one big view I created a series of views with a hierachy for searching and...

A colleague had sata disks on his san -- a TB of storage is almost normal for home use now - certainly I almost have that sort of storage on...

unless you want to degrade performance in which using functions badly will certainly achive this!

not all table variables are created in memory and not all #temp tables are created on disk. Depends upon available resource.

With large data sets you can run into problems with...

Microsoft have indicated to me a max of 10 mirrors per instance and you need a really good line/link . I was hoping to find evidence of users deploying mirroring...

Cheers Ed

I've spoken to Hitachi and they have some excellent solutions, and I got to speak to people who could explain to me what I was asking. More than can...

I wouldn't even consider trying that way. I'd advise you to move your databases by detach / attach, script your logins. your dts packages won't properly convert anyway and the...

You'll never know until you apply a service pack - Ithink sp1 for 2000 expected the system databases to be in the default install location - if they were not...

Yes I read somewhere that you musn't attempt to modify or maintain partitioned views through EM. I sort of wish I'd had some of this dialogue a few months ago...

hmm, interesting, I've moved on to another contract now but I'm told the pv's are working a dream. I wasn't too concerned but it was the fact that the plans...