The other place not yet mentioned where this gets even more important to consider is when you use a table-valued function within a CROSS APPLY clause. It's in those...

Jeff Moden (1/22/2008)

---

I'll add a couple of more...

Everyone who doesn't telecommute will hate you (for obvious reasons).

Everyone who doesn't telecommute will perceive you as a slacker unless you produce double...

I don't think it would be efficient. It would be something like a recursive back-reference, and then you'd be doing math on string values, etc... A tally table...

Well - using the function in the JOIN will prevent using any indexes to do the work, so it's going to hurt performance. If the tables are small -...

I've had that issue as well on a few singular machines in here. In those cases, I simply uninstall the Dev edition, then go into the VS install...

Sounds like we might need a test to find out....

ahem...

With a large enough set of numbers - wouldn't you want to be able to leverage an index on your tally table? Although I conceptually like the CTE -...

Keep in mind that the Dev edition, although it ships with Visual Studio, is a separate install from the main VS install. You need to grab that separate DVD...

True - a lot of organizations are in the business of making money (not all, thankfully). But within those for profit organizations, some are smart enough to know...

Just curious - why not drop the table and create the table all over again? with the new seed?

Jason - I'd recommend just right-clicking on the database and running some of those reports under standard reports. Focus on the transaction ones, but also the disk usage by...

You need the outlook client with a profile set up that can actually send and receive mail. Is that set up at this point? Sounds like you might...

Glad to hear it helped! Thanks for the feedback.

Why not just completely lock down access to xp_cmdshell? You're going to destroy your ability to ever do replication, resolve login if you attach a foreign DB, and scuttle...

There's really nothing tricky to it: you simply create a package, which has a source DB object connected to the 2005 server and a destination object pointing to the...