I typically just setup a couple of maintenance plans. One of which is setup to run every 10min and commits the log files and removes them. This makes...

Wow, I never knew someone would use EAV so extensively! Usually the only time we employ such a scenario is when we have a need for "Customer-Defined Fields" (CDFs...

I was working on a more "set-based" approach to my above comment. However, the FLWOR statements in SQL don't seem to be working correctly.

For example, this works:

SELECT TOP 1...

Good article. I've noticed that the "modify" function can only contain one operation per "SET". However, I want to delete multiple nodes in a piece of XML and...

First off, nice post, I will start playing with this some more. Also, I do agree with some of the others who have mentioned that this solution does not...

One thing to watch out for here with "processing a file as soon as it arrives" is that you don't know if that file is done copying or not. ...

When SQL 2005 came out, I cringed at the way SQL Notification services worked and basically threw it out the window as an option for change tracking. However, I...

Wow, thank God someone...

Actually, "roger.plowman" brings up an interesting idea. I've also used a design in the past with 2 tables (ExternalLinks, and ExternalValues). Basically, we had many different external systems...

Right, I've seen it mentioned on here as well, but we use GUID COMBs as well (a GUID which has as it's basis a stamp in time). We have...

Obviously, this is an old post and one I would have been interested in 2 years ago. So great article! One thing I'd like to mention is that...

Well, not entirely useless, I got a good laugh as I thought about this 'ole job. Moved on to bigger and better things...so the advice was taken 😛

If you're referring to DBPro, yeah, we've been using it for years, quite successfully too. It allows us to move our databases from source control to dev/qa/staging & out to...

I'm really surprised that no one has mentioned using "Database Projects" in Visual Studio (2003 - 2008). Unfortunately, Microsoft has removed this Project Template with VS 2010+ but I...

Eric Inman (7/4/2009)

---

The Insert Update and Delete are of course set based, parsing the DOM is about as RBAR as you can get. Who cares if its not apparnt to...