No one else has had a go, so I will try to help.

I use log shipping all the time.  It is lightweight and works effectively.  That said, I always roll...

Its a long shot, but you could check open transactions on the database in question.  Perhaps something has been left open...

you could restart the server, as this rebuilds tempdb from model.

Unless anyone knows why you can't?

Yes I thought so too.

However:

tells me that public has exec granted.

The following:

what permissions do you need to successfully run xp_fixeddrives on 2k5?  I find that a basic user ends up with an empty result set but no error messages!

well, if you can sensibly cluster on the your core search requirements then there is a good chance of a significant benefit.  As I say, it all depends on how...

yes.  but make sure your server supports the usb drive.  If you have more than a couple of gb of data avoid usb1 .... its embarrassing.

Sounds facetious, but the answer is that it depends.

If you post a sample create table script with some typical usage queries and data population statistics we can give you some...

or you could just exec sp_rename...

If you create a unique clustered index on this you will have a serious impact on the server, and probably gain nothing.  The identity value you put on will not...

Surely your choice of index for the large range could have been better?  Yes the highly specific reversed order may be better for a particular lookup, but for a ranged...

Its not viable.  Pretty much anything (including count(*)) on this table provokes instability, and it takes 30m inserts a day, mission critical.  The pure and simple problem is that the...

Ahaha ok, it seems there is a rowcnt column as well as a rows column,  rowcnt is bigint rows is only int.

I shall mod my procs to use rowcnt where...

anyone from the objectVerb, no prefix school looking for a job in london?

Aye, I agree with Eddie, can't stand these daft prefixes people get taught at university/polly.

Plural/Singular it doesn't really matter that much, as long as it scans well.  Closer you get...