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.

Is the parameter declared as nvarchar? It should just work if your driver supports it.

Have you tried a straight insert?

There is some legal reason, but I don't buy it either. It's just for patches that aren't completely tested.

QOD points as well. We're looking to also add the ASK reputation somehow and calculate some "engagement index"

I understand the issues with the original questions, and the critics made their point. I changed it in a way that I think addresses their issues, but also then continues...