it could be there is an alias defined , have a check.

you may want to try sp_updatestatistics @resample='resample'

and/or dbcc updateusage(0) with count_rows;

one might observe that not knowing the answer led to the correct decision! Be aware that when I interview I always ask how after getting the answer to a...

irritating those type of errors! You don't have it open in another mapped file/drive?

I usually try to rename a file in this type of situation and see what info...

you can usually track those who think becoming a MVP is just making lots of posts on forums!

All I'd say about MVP status is that you have to be nominated/recognised...

well windows 2003 will go out of support very soon

Make sure you choose 2008 R2, windows 2008 is old technology now.

windows 2008 R2 has a bunch of features that w2k3...

if you're running on a server go into the server diags and check for hardware warnings/errors in the server logs. Open Manage for DELL and HP Server Management on...

I believe ( maybe ) that a cluster can only "see" one nic per network. You may need to create a second vlan before the cluster will see the other...

I always assume that a service pack install will require a service restart - if it doesn't then that's a bonus - but most likely you will need a restart....

this happened to me once and I'm trying to remember what the solution was! Sure it was something to do with how the resource was allocated in cluster manager. ...

sorry should have added - clusters generally don't "see" anything until you define it as a resource.

why are you using w2k3 it must be almost out of support?

as far as I know, as I only have w2k8 clusters, you have to add a nic as a...

I think you're confusing data compression within the database and compressed backups.

Compressed backups are fine, but if you want to use page or row compression ( depending on your sql...

to be honest the best way to do this is to call a proc with the info you want ( from the being called procedure ) which writes to a...

to be honest raid 5 isn't very good for anything except read only databases. There is a big overhead on writes for a raid 5 or raid 6. There...