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...

Don't worry, Barry, we know who you are!

And I've got your blog in my DBW list, so you'll be showing up soon everywhere!

I'm not typically an early adopter. I did Win 95, but held onto that until W2K was about a year old. I did go with XP right after RTM, but...

Yep, dropped SS2K8 Dev on my desktop. Needs SP1 (for SQL)

Nice job. A good introduction to spatial features.

Well, Bob, you might be ".1" from now on :w00t:

Done! and thanks. 🙂

WHS uses a technology that duplicates data across multiple drives in software. It isn't RAID, and it is similar to what Drobo uses to ensure that different sizes of hard...

That's an interesting point of view. It seems to make sense to me, but I'm not sure I understand the issue. I think I'll send this to Bruce Schneier, I'd...

Hey, I came up first on Snitch! That doesn't happen often. Usually Steve Jones starts with the muscian, golfer, professor or basketball player.

Jeff,

You ought to look at Win 7. I moved to the RTM this weekend, and so far things are working well. It flies on hardware and seems much improved to...