OK, I see both sides of this argument, and I'm not sure either side is correct. The question is confusing, IF you do not see the point of the question....

Oleg,

I think I addressed this by moving the values to variables. Is that not correct?

There's a link in the article to their site at http://www.worktamer.com/

I guess it's possible there is still being copy work done on the sparse file, but I wouldn't expect that. My thought was that a update/delete in the original file...

You're late, Jason. I whacked the post.

5GB/month, 60GB a year, not that much.

Do you mean you have client apps connecting to SQL Server across the Internet? Nothing in the way to secure it? I assume a...

Can you create a new snapshot, same name, different file?

This does sound strange. When you start the instance, the file goes in use, correct?

I'm not sure I completely understand your rules, but you can calculate all the values and then use a CASE that will pull back the value you want in the...

This somewhat looks like homework, so I'll give you some hints here.

I'd build an aggregate query that uses COUNT() to determine how many times each name appears. That it a...

Mike, that's really interesting. Want to write that up as an article?

That's not bad. I'll see if I can structure something that won't upset everyone around me.

What is your app structure? The way that most people have done this < SS2K8, is to feed the "path" of the file back to the application. The path being...

I struggle with this a little. I want to allow people in the community to interact, which includes vendors. At the same time, Red Gate does regulate and want to...

With replication, the log cannot clear until the transactions are sent across through replication. If they don't get marked as replicated, they stick in the log. Be sure the log...

I think the problem with many of the "considerations" or "rules" that GQSquared listed is that they don't mean anything if you're ignorant. What is "appropriate" if you're new to...