Maybe, but the SP isn't necessarily that which CU 4 is developed against. Neither is an individual patch. They might be developed again CU3 or CU2. Otherwise it would be...

I agree with you morally, but once you start to get into policing ethics and morals, you are potentially opening yourself up to some legal actions. I can't imagine someone...

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