Alvin,

Stay out of the post office out there. Sounding dangerous in dem dere parts: http://www.comcast.net/articles/news-general/20101018/US.Post.Office.Shooting/

Aren't most trees green?

The color doesn't matter. I think there's a sentiment here that makes sense, but like most advocacy groups, they take it to an extreme. They are no...

I have used GUIDs in similar situations to what Grant has. When you have offline work, or remote clients that need to generate a "key" of some sort for a...

tdennis-674196 (10/17/2010)

---

I've been thinking about this issue for a few days. Like everyone, I accept that using a single integer field is going to be the best performance, but...

I tend to agree with Bill in that you rise to the occasion and look to improve things. Try to find the best in the situation and improve things.

However, I...

Alvin Ramard (10/18/2010)

---

Jeff Moden (10/17/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

The green value, if there is one, comes not from you getting ebooks, but from 1000s of people doing this. Less...

There are some articles here:http://www.sqlservercentral.com/articles/Administration/

Might try these:

http://www.sqlservercentral.com/articles/Administration/70129/

http://www.sqlservercentral.com/articles/Administration/63042/

Doh! Forgot to setup 3 positions and still within 20 points. Guess it's time for an Outlook reminder.

I was just wondering if each location could generate sequentials from .NET. They wouldn't be all sequential, but you'd get "bunches" from each location, and that might limit, not eliminate,...

Intereseting, I have friend running almost exclusively blades. Of course, that limits the size of the host, and then the VMs, but they have been happy with blades. I think...

From what I've read, the OP needs his old schema back, but needs to move data entered since rollout back to that schema. So moving good data out is what...

That's a reasonable strategy, and it's how people tend to deal with lots of inserts that might cause page splits.

Can you do sequential GUIDs in the remote locations? That might...

WayneS (10/15/2010)

---

I don't...

LOL, that's great!

I would have thought so, but if people entered data in a new system, you can't restore without losing that data. So you need to migrate backwards the data.