Many people will recognise a crisis of confidence and feelings of being on your own. But they affect people differently - some adjust their attitude and reconnect with colleagues,...

Thanks to both:

Rudy, I will look into (i) flushing tempdb somehow when closing SQL Server (maybe just a restart followed by shutdown, to leave it fresh and empty - the words...

Steve also mentioned "put in a spare":  not sure if he means Hot Spare, but I would recommend always populating an array as the disks you need plus a Hot Spare.  Then...

Knowing it would be better for the long term, I recently recast a bunch of 'old' style stored procedures to use JOIN.  Most SELECTed... WHERE against an input parameter from the result of...

I am fairly new to SQL2K5.  The various accounts and local Groups look more complicated but work fine, and it's great to rely on Configuration Manager to handle the group memberships.

After installing Management...

I'm not up to date, but a couple of versions back it was a complicated business creating a database clone in Oracle.  9i is meant to have improved things, but I...

For years it seemed odd that we still saw the Microsoft Mouse and, later, the Natural (in the "not at all" meaning of the word) Keyboard.  And then came the XBox...

Then again,...

Hmmm... testing backups, there's a good idea...

Steve's question "How Often..." surely deserves It depends...  But I like his point that you have to avoid making routine something that you will called upon to do only in a...

Our standard practice is to take nightly tape backups after the Maintenance jobs have generated their .BAK files, and once a week to Net Stop the SQL Server services before running the...

I agree with Ian, above.  It's not how the world works - IT in particular - but wouldn't it be nice to get to a good and useful product and just......

I agree with the last two posts, and Steve's earlier response:  I had just this situation when I converted an MS Access database to SQL2K tables linked to Access and secured...

The two statements do not do the same thing.  The first tests the value twice, the second tests it once. 

If both statements were written to achieve the same thing I doubt that there...

As it stands it does sound baffling.

I think I would be looking at reindexing rather than just updating stats, but maybe there are good reasons why you don't.  I would...

Perhaps the reference to a number that you are not doing any math against means that the "advisor" was thinking of the need to distinguish mathematical values from numeric strings such as...

It is not clear whether your Delphi apps are local or remote, but since they are scheduled runs could there be occasional clashes with

• SQL Server hits from internal jobs (eg log or...