Viewing 15 posts - 1 through 15 (of 256 total)
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...
December 16, 2016 at 7:34 am
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...
January 21, 2013 at 7:05 am
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...
August 17, 2012 at 9:33 am
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...
August 17, 2012 at 8:38 am
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...
July 5, 2012 at 9:25 pm
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. ...
July 5, 2012 at 9:13 pm
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...
November 28, 2011 at 6:58 pm
Since there tend to be many more FK records than PK records in your average database structure, the bloat compounds further, impacting performance as it does so.
Wow, thank God someone...
September 16, 2011 at 2:47 am
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...
September 15, 2011 at 7:30 am
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...
September 15, 2011 at 6:52 am
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...
August 20, 2010 at 8:36 am
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 😛
August 12, 2010 at 12:48 pm
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...
May 6, 2010 at 10:01 am
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...
May 6, 2010 at 9:05 am
Eric Inman (7/4/2009)
July 6, 2009 at 6:02 am