Do a google search for expanding hierarchies for some good examples of an iterative process replacing a recursive one.

As with most things Jim - "it depends". A lot of thing can be written using either notation with no difference in execution (derived table vs CTE), but there...

And while you're there - you might care to change the growth factors to something more intelligent than 1MB (so you don't fragment the heck out of the disk subsystem.)

You also might care to read the part about Notification Services being discontinued in SQL Server 2008. That would put a crimp on things......

Common Table Expressions are a new feature to SQL 2005. That syntax does not work on SQL 2000.

.....Which also might be a necessary "evil" if the table is a "mapping" table (the intermediate table used to create many to many relations). Of course if would then...

Like Antares - I can't say I've tried, but my understanding is that while you can install 32-bit on a 64-bit OS (using WOW), you cannot install the 64-bit SQL...

The main thing that scares me about virtualization (and an issue I am still fighting today) is that while it can work incredibly well in organizations that put a lot...

To add to the list of questions (for mgmt):

- are you expecting the issues to be discovered by the customers and brought to our attention? Who's in charge...

Please - don't cross post. they all get read....

Answered by gilaMonster over here:

http://www.sqlservercentral.com/Forums/Topic446867-65-1.aspx

I was a bit curious about that too, but I'm seeing what Grant mentioned: when you add the separate configurations, some amount of that info seems to be put directly...

oh I'm not saying they do it out of the goodness of their own heart. However, there are lots of cost/benefit analyses to show folks that rotating through staff...

Access ghosts in a copy of the "table structure" (or view in this case) at the time of creation. It also asks for you to confirm what the Primary...

Linked tables don't automatically update when there are DDL changes, so dropping the linked table and recreating the link is the best way to clear that up.

What I'm trying to get at is:

A process where the date increments along with the shift number would yield the same result as a process where the date decrements...