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 🙂

coffee

That's funny. I wonder how many people will go there right away and not get it?

that URL, for x64, has two conflicting items. There is a para that says: "Windows Server 2003 R2 Datacenter x64 Edition supports up to 2 terabyte (TB) of RAM (with...

The SQLGuru has hit this nail on the head. If you have a failure after TRUNCATE ONLY and before your next full backup, you can lose a lot of data.

You...

The munitions are the code used, so if you write code that does encryption, you need the license. I believe Microsoft has this, so I don't think you're in trouble...

The hard part about profile is scaling it up. If you double or triple up the trace, you need other clients. I'd think that a tool like this would be...

Nice job, Jeff. Learned a few things myself.