There are no obvious values or keys in the registry for this one, and SQL Server doesn't appear to search the registry when you query this way, so suspect it...

Just as a follow up to this, we saw the same problem on a brand new, 4 processor HP server. Doing very simple remote select queries on...

Keep up the good work folks

SSC's probably the most useful site on the net. Must be good as I come here first before...

Thanks guys. Yes Steve, so far as I know, DBCC commands are common to all versions of the database engine, although I would not rule out minor differences in the...

Yep, you definitely need a password in there unless as Ian says you've not got one (slap on wrist).  Remember, these things have a nasty habit of making it into...

Randy, I think Allen's on the right track. Have you checked that the user name under which the job is run has permissions to execute xp_cmdshell? And can you successfully...

Very useful and clear reference Greg, nicely illustrated too, I hope the guys think it's worthy of inclusion in next year's 'Best of' publication - I can never find this...

Just to clarify what sa24 stated, it's not a good idea to run AV against bak/ldf/mdf/ (or whatever database data file extensions you use) on *any* SQL Server, not just clusters. ...

Guys,

Whatever your opinions, you just don't know how lucky you are.

A few days back, I quietly posted my own sincerely felt tribute to the Republican Party's web site, commemorating the...

Yes, that's correct, and hopefully you can schedule a re-build of the indexes before the page splitting starts to occur.

The other downside is that less-full indexes also increase disk I/O. If...

David,

No, though that's the impression I got at first. The key to it is that the FILLFACTOR determines how much of the index is filled ***when it's first built***. After...

Completely agree, it's what's best suited to the app. being created.

I'd use Access (spit!) for certain things, but not for a serious app/site/amount of data.

I wouldn't expect to see the...

Sounds pretty similar to what's happening in the UK. Things have definitely firmed up in the IT jobs market, especially in the last 3-6 months, but it's still subdued. There's...

A very relevant article at present Steve. Just a few things to add:

Firstly, have the contact details for the site services people on the list, along with contact numbers for...

Good intro. article Brian, I look forward to the other 12

For anyone who's interested, the main page for SQL Server 2005 is at...