Do you want to delete matching NULLs? Use an OR clause -OR (a is null and b is null)

A separate array helps, but only during backups. You don't have heads moving for two separate processes. Not sure how noticeable it would be.

However it's a bad idea. If the...

That's what I would think. Some process outside touching the files.

James,

Didn't realize that and good information to have. It's good to know since it might mean that you can your vacation back if you have to work.

I have turned my...

Not sure what you mean by "how it process". You can get the execution plan, which will tell you what work is being done. Queries can be processed different ways,...

http://www.sqlservercentral.com/scripts/Backup+%2F+Restore/30043/

Uses PKZip, but you can modify to use the command line for WINRAR.

You can run frequent diffs, but they'll get larger and larger. For that matter, why not run a full every hour? You could do that and it would let you...

As mentioned above, a simple in the WHERE clause should do this.

This sounds like some test question or interview question. We are happy to help, but we want to...

Good points on your value and something I hadn't considered.

As an FYI, I actually have a balanced NCA where the I have to give xx notice and the company must...

RE-uploaded the file for the WMV. Hope that works.

localhost/mssqlserver is a named instance. (local) defaults to local (I think 127.0.0.1)

The /mssqlserver isn't necessary for a default instance. You'd just connect to the Windows machine name.

If you want to...

Agent shouldn't restart SQL Server. If it is, I'd call MS. Perhaps keep an eye on it to be sure it wasn't coincidence.

There are very few secrets. Is SQL Server doing something that Oracle can't? Hardly.

I heard Jason Fried of 37 Signals speak last week. He talked about how often they blog...

Thanks Keller, I've updated the feed. Not sure it's working, but that's the one I have from Mevio.

Feed broken at times, working on that, or I've been trying to get...

Read the articles by Jeff Moden. He covers some great basics you might want to avoid.