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

I have awarded back all points to people as of now. Apologies for the delay, but this was not the high priority of the day.

The question was reworded to use...

Couple other questions. When activity is occurring in this database, is it one large transaction that might be occurring? Or implicit transactions set on?

How many log files do you have?

Definitely...

I agree with Gail. You don't usually need duplicate indexes.

I think it's cool both you and your wife have knives 🙂