One suggestion to keep the values in "sync" between the two tables, if I'm understanding things correctly, might be to just remove the Identity column from the archive table.

When you...

Steve Jones - SSC Editor (8/8/2013)

---

It's a balance.

Can you afford it, does it cause issues, what does this do to your life. Balance the joy/excitement with the costs. The real...

So now the wife, who raised the idea in the first place, is trying to make it *MY* fault that I'm hooked on car shopping...

Sheesh, wimmin...

:hehe:

Another idea, to at least try to narrow down the scope, can you re-schedule the 3:30am job? Maybe move it to 4:00am so it's going after the backup runs?

If...

Stefan Krzywicki (8/8/2013)

---

jasona.work (8/8/2013)

---

Well, it's "budget" in comparison to a "typical" mid-life crisis car:

Corvette

Porsche

Ferrari...

😀

Actually, the BRZ is about $3-4K less than what we paid for our Charger, and about $2k...

Well, it's "budget" in comparison to a "typical" mid-life crisis car:

Corvette

Porsche

Ferrari...

😀

Actually, the BRZ is about $3-4K less than what we paid for our Charger, and about $2k more than the...

*sigh*

My wife is either teasing me, or just an outright cruel, heartless, b**ch...

She brought up the possibility of trading in our older car ('06 Dodge Charger R/T) and getting something...

Stefan Krzywicki (8/6/2013)

---

I'm going to be working on a website that is currently on a Linux machine that has HTML, CSS and some javascript. The site needs a database. If...

D'OH!

Sometimes the simple solutions stare you in the face, and you still don't see them...

Thanks!

Something I found amusing on LI is that everyone at my old employer, doesn't actually work there...

The company hasn't / doesn't have an LI profile, but there's another company with...

So, like an Id10T, I went to the gym last night and for the first time in almost 2 years lifted weights. Well, OK, used weight machines, but still...

Now,...

I'd say the first thing to do, is see what SQL says is the reason for not re-using the log space:

use [master];

select name, log_reuse_wait_desc from sys.databases;

Could be a long-running transaction,...

The rule of thumb would be to set it large enough that it doesn't need to grow, with a little headroom to handle "bursts" of transactions.

It's the sort of thing...

Nuns

jcrawf02 (8/2/2013)

---

we'll send you some fresh cream, and you can enjoy...