I'm assuming the goal here is to consolidate multiple OLTP databases into one OLTP database, and each existing line of business application will (at least for now) continue it's own...

Matt Miller (#4) (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the...

David.Poole (2/9/2016)

---

I heard a story that an analysis of coin composition revealed the state of a nation's armament capability.

Data is like fissile material. Once it gains critical mass it's...

Have you ever wondered how much an IT staff member working for Department of Homeland Security earns?

http://php.app.com/fed_employees11/results.php?fullname=&topagency=DEPARTMENT+OF+HOMELAND+SECURITY&agency_name=%25&job_title=INFORMATION+TECHNOLOGY+MANAGEMENT&statename=%25&Submit=Search

🙂

Steve Jones - SSC Editor (2/9/2016)

---

Eric M Russell (2/9/2016)

---

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions...

ThomasRushton (2/9/2016)

---

Eric M Russell (2/8/2016)

---

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due...

...That's scary, though potentially not a problem. A number of states publish voter data as public records. A few might have restrictions on the use of that data, but the...

There has been explosion in the number of relational SQL databases developed over the past 20 years. The broad sentiment that RDMS don't scale is due to the unfortunate fact...

If employees have interesting projects to work on, are well compensated, and generally happy with the direction of the organization, then having a "corporate culture" in place will give them...

Basically what you're describing is the underlying tables of a "distributed partitioned view" design pattern.

https://technet.microsoft.com/en-us/library/ms188299(v=sql.105).aspx

What you'll need to do is have each table insert identity values within a unique range....

Beatrix Kiddo (2/8/2016)

---

Thanks; I hope you're right. I'm very concerned that I'm getting de-skilled here. It's really sad; nobody cares, nobody wants to do anything well, nobody wants to improve...

roger.plowman (2/5/2016)

---

Eric M Russell (2/3/2016)

---

As a DBA, if I get a 2am call that a critical application is down, because a select in a stored procedure is missing a join...

TomThomson (2/4/2016)

---

Eric M Russell (2/4/2016)

---

Some good ideas (like open source software, open IT floor plans, and telecommuting) come out of startups and are adopted by the larger corporate establishment. However,...

It sounds like your concerns are to load data from old table into a new table while mimimizing transaction logging, downtime, and risk.

Consider this approach.

1. Using BCP, bulk copy your...