the developer version of sql server is very cheap to buy, typically around £50 GBP ( about $100 us ) or you might want to consider buying a technet...

it depends upon a number of factors, such as table size and how fast your disk subsystem is and how busy the application is. Mostly index rebuilds are kept short...

please don't multiple post.

you'd have to use dynamic sql within your proc building your statements as you go and then executing the created script.

I'd say this would be the worst and most inefficient...

you have to be careful removing builtin admins ona cluster - there's some KB articles about this try KB 263712

Hmm I don't know what that says about us if we start checking which commands were used in older versions of sql server

I'm never too impressed with strings of letters in a post - but I do object to anything to do with guns - here in the UK we're suffering a...

as I say I think the table is too small to be effectively defragmented. I wouldn't worry about any figures returned from a 5 page table. Can't comment on a...

yes I know you have to learn. but as I say this isn't a "quirk" it's a lack of understanding - and it doesn't belong under performance.

you could merge/export your...

you need to make sure your mail admins keep the smtp mail queues tidy as well if you use smtp. I've got a couple of stored procs I use -...

I never use the buffer cache hit ratio preferring to watch page life as an indicator of use, microsoft say no lower than 300 but I've got to be honest...

I've got to admit I've forgotten which versions you should use with 2000, I thought we went checkdb in 7.0, newalloc in 2000 and back to checkdb in 2005. I...

most servers have server diagnostic software installed, that'll look after the server hardware. There's no golden check which will guarantee a system. I think in 2000 they recommend to...

you might do better to get a smtp mail proc - there's bound to be several on this site.

if this company is in the UK I might be available for consultancy

I feel for you and really the best I can suggest is you get hold of...