Thanks for the blog, Jorg! I appreciate it!

WANT MORE FEATURES!!!!

Sorry, couldn't resist. @=)

The Scope Creep discussion reminds me of a moment at one job where the developers worked their butts off designing a website solution (tied to...

Glad we could help. @=)

Andy Warren said:

On the contrary, Andy. You definitely rank up there with those two! Your...

Unfortunately, using the LIKE operator always affects query performance. For one, if you use the wildcard on both sides of the search syntax, then you can inadvertantly generate tablescans.

The...

What error are you getting with the Flat File Source?

And what datatype is the column you're importing this data into?

I take it you don't have any previous backups (to the one you're currently using) that might have these 8 tables on it?

There are some disk recovery services that might...

If all else fails, change the order of your tables. @=)

Sometimes with INNER JOIN table order doesn't matter, but I usually go from the table that's likely to have the...

That's a good point, John. Unfortunately, when I was studying for my cert, I didn't know of any local users groups. They don't advertise very well in my...

If you're writting your syntax properly and not coming up with the result set you expect, there could be one of two problems.

1) You're using the wrong keys to join...

anjanasl,

To expand on what Matt said, probably you're saving your backup to a previously created backup device which itself has two media families. Are you doing this through the...

Just an FYI. If you want to append anything, dates, times, characters, to a name (table/column/backup file) in a SQL Script, generally you have to build it in a...

Or, would you break the mirror and use 4 disks to create a Raid 1+0 and then the other three disks for Raid 5 (for TempDB & the user logs)?

Break the mirror. Configure one side of the mirror for your Raid 5 (for the user databases). Detach the databases and move a copy of their data files...

I'm glad it worked.

One thing I would do, if I were you, is to head out to MS's bugs & suggestions forum and see if anyone has reported this as...