Sorry, that was the test schema I used. I replaced the E2E text elsewhere with MySchema, but omited doing that for the testing section.

I've edited my original post to...

You could create your tables inside a schema and then give them a SYNONYM on that table in DBO. You'll need to watch out for your schema level security...

Why can't you write one SQL query to pull all results in one shot? Can you post the table DDL for your staging table and some sample data? ...

How much data are you trying to move?

Is there a...

Is your package using config files or expressions?

I've never used software for this. In fact, I was not aware that software existed that had the ability to enforce coding standards.

We have always handled coding standards enforcement...

From BOL on Column Considerations for non-clustered indexes:

Lots of distinct values, such as a combination of last name and first name, if a clustered index is used for other columns....

Duplicate post, please follow this thread and reply here

You're almos there.....

SELECT MediaBuyer,

[1/7/2009],

[1/9/2009],

[1/11/2009],

[1/13/2009],

...

Rick Bailey-440858 (1/13/2010)I was told that the poor performance was due to a record by record insert vs. a bulk insert.

OK.... but why can I use the same method to...

I would not recommend attempting to use the max degree of parallelism setting to micromanage your thread priority.

xuejianpan,

These data loads that you're asking about:

1. how often do you...

xuejianpan (1/13/2010)

---

I'm so sorry to post duplicate messages and cause the confusion. but John's link points to my other topic "How to switch data online". So let's discuss just talk...

Creating the XML in that format should not be very difficult, but I'll need some more information from you to continue. Can you post the table DDL for the...

Omaha, Nebraska.

I would recommend looking into SQL Server Table Partitioning for this solution. You don't need multiple servers, multiple databases, or multiple tables. Just a well-designed partition strategy (possible...