That's interesting, Johan. Never knew that, but it's a handy piece of advice to keep in mind.

Does this still apply in a CI db?

She says that Jack, but let's see if she invites you to train on Tues or Wed night ...

Most of the audience here are database professionals. I can assume they understand and can set up RAID systems.

I'm asking what they use at home, and if they want to...

control panel, windows firewall

Excellent! This should be required in all companies and governments.

Be careful with triggers here, especially if they could get multiple rows updated. I say that because many SQL novices don't write triggers well.

Perhaps you could explain what you...

Martin,

nice summary. Thanks

Is the firewall blocking 1433?

It's not a skill set issue, necessarily, it's a need/want issue. I'm looking for a central backup solution that I don't have to manage. WHS does that. I have seen...

congrats on the book, and hopefully you'll get a few people coming by.

As Gail mentioned, you might need locking. In a multi-user system, 2 or more people could select the max value at the same time. That's the power of SQL, multiple...

xp_delete_file has some strange restrictions. I think it only deletes certain types of files, regardless of extension.

You ought to script this with filesystemobject/VBScript or Powershell

If you want to simulate more real time work, add a waitfor() inside the transaction for a random delay and then commit the transaction. Wrap that in a loop, perhaps...

I think I'd disagree. A few people have pointed out mis-information, or incorrect information regarding WHS...

That's what I want to do, and I think is what will happen when we remove dups.

However the issue has been the front end being coded to handle that. I...