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...

Gail has listed some of the things to think about. If you want to split for performance, you are looking to (usually) separate out data and/or indexes to separate spindles...

I think you might need to provide more information on your design.

You could still use Carolyn's version concept, add a version to both tables, copy the data on edit to...

It's a good debate, but it's a far cry...

Gary Istvan Varga (11/19/2009)

---

No language can stop the rubbish this industry produces. Nor is it primarily languages' flaws at fault. Some of these so called faults are language features. Often...

Using an app the mutliplexes means you still must license all clients. It's not just the one connection.

http://www.microsoft.com/sqlserver/2008/en/us/licensing-faq.aspx

SQL Server will not spread out to these files automatically, though if they're in the same filegroup, SQL Server will use the space in a proportional manner related to sizes.

http://msdn.microsoft.com/en-us/library/ms187087%28SQL.90%29.aspx

You can also use SQLCMD to "pull" data from a scheduled task or on demand as a batch file to a flat file.