It can be 800TB, but that is huge. Are you sure you're not mistaking the size by a factor of 10?

Also, I'm curious how you are backing up the log...

Or you could start here: http://www.sqlservercentral.com/articles/Stairway+Series/69801/

We...

Hate the UK. It's not the US 😉

Thanks for the link, Joie. I think that's a relatively recent change on MS's part to support VMWare, and I'm glad to see it.

I worked for a small company years ago (2002) and we had 5 instances of the server, I'd consider crucial. Numerous Personal editions, but on servers we had

1. Primary web...

Rockies have a 5-0 pitcher. That's kind of amazing. http://espn.go.com/mlb/players/profile?playerId=28625

I'm hitting .375. Went 3-3 last week, 3HR, BB, so I'm hot. A nice game after an 0-5, BB start...

Jim,

I think you're confused. The patches are built upon other changes, and contain the previous CUs. They're just not overly tested.

CU5 for SS2K8 SP1 isn't built on SP1, it's built...

James Goodwin (4/28/2010)

---

I disagree with regular service packs with the following justifications:

Service Packs should be rolled up and tested when the accumulated changes are sufficient to warrant it not...

It's a bug: https://connect.microsoft.com/SQLServer/feedback/details/492452/generate-identity-value-is-incorrect-after-set-identity-insert-on-on-an-empty-table

Noted as fixed in the next version (SQL 11, I think).

I'm confused. What is using the space? You said it didn't have any mdf/ldf files.

Correct, SQL licenses on sockets, not cores. I think this is why it seems a lot of larger companies are buying 2 or 4 socket machines and sticking in dual...

Yes, that's what it's supposed to do. Didn't realize that, but it's listed here in the SET IDENTITY_INSERT page. So if you insert a larger value, it should update things.

However...

What's more interesting is that if I do this:

set identity_insert #aa on

insert into #aa(id) select 8

set identity_insert #aa...

Steve Cullen (4/28/2010)

---

As long as CUs are being released, there should be a regular SP release.

When the product becomes so stable that no CUs are created, then no SP is...