You cannot count on the larger file being more recent. Use the RESTORE HEADERONLY commands to determine the content.

Hasn't come back to haunt me. I almost never use that stuff. I backup to disk files, name them by date, use that for restores.

deletes

Most DR solutions include log shipping...

• This reply was modified 7 years, 7 months ago by Steve Jones - SSC Editor.
• This reply was modified 6 years, 3 months ago by Dave Convery.

Yes, the ramification is that you can't query for what is contained in a backup or have SSMS automatically do a restore. The history cleanup task in the maintenance plans...

I have had some people say they burned up SSDs, but I think that was under extreme load. I have had a few people say they have used SSDs in...

I think something like a SQL Refactor from Red Gate would do this.

Are you not using Source Control? I would make sure you're doing that, and then I would look...

I would follow Lowell's advice. You need a unique constraint to ensure your data is intact, but there's no need to copy all that data over to a FK table.

You don't necessarily need to tune the design. I would move to varchar as it can save some space, which might end up making your rows denser on the tables.

If...

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