It's not really clear what you are asking here. You need to provide some more details.

[Moved to design forum]

I'd second a read on those articles.

You're going to face some contention no matter what. One thing to minimize it is get the audit tables onto another filegroup/disk.

You could look at an SSD drive for tempdb, which might provide some speed boost as well.

The answer is arguably correct since an exception occurs and is handled in the code. The order of what appears, and where, depends on your client.

The question has been edited...

I would lean towards Lynn's thoughts. Typically maintenance plans kick off a midnight, so it's possible that you have something occurring around that time. Note that the full backup does...

I don't think a trigger is the place to do this. Instead, I'd build a job that can read AD, and update changed rows once a day. Knowing who owns...

The question has been changed. It was edited to say SS2K5 and the answer moved to 1,1. All points have been awarded back.

I believe I tested this, but it was...

I don't believe that you can change the existing shortcuts. I will check around, but I think you are stuck with them. If you look at the list of shortcuts...

Not sure what you can do with that guy except ignore him.

Geolocation is a start here in automatically gathering meta data. There are even some software systems that can determine the location from the image. Add in grabbing faces, date/time, etc....

If you read the explanation, you'll see that we "voided" this question because of the ambiguity. Hence the "right answer, wrong answer" answers that are listed.

I didn't really want to debate this particular instance as being good or bad. Schneier has a good writeup and makes some points about why this might not be a...

Rows in a table have no order, unless you specify an ORDER BY. If you import into a table that has something like an identity, then you'll have a way...

I think the biggest issue with SQL Injection is the front ends. It's not SQL. Even if I have a good proc, spDoSomethingCool, if I call it as

SETDim MySQL as...

Grant does have an excellent point. You need to test restore, or you should think about it, before moving.

In terms of application changes, it depends. If your applications depend on...