Thank you for the response, and sorry for the delay in replying to this.

The problem is that there are 4 files my ETL gathers from an access database. For...

Wasn't in the temp folder, but realizing I could see the queries from it I ran recently I just used the most recent expensive queries from the activity monitor and...

Yes sorry in SSMS a query window was closed.

Good article though the Except part at the beginning seems superfluous and unnecessary. If you wanted to compare data sets to see variation then I don't know why an Except...

Yes that is correct. And for some strange reason it just started working! I am not sure exactly what I did to get it to run other than I put...

It does and doesn't. If you can not restore only part of a database via file group...then what exactly is the functionality of making filegroup backups and restores?

Thank you for your response!

This does help me in the right direction however, while I do have a physical date dimension built that contains all our fiscal calendar and...

Yes and no. Yes SSIS executes the package, but the package is a stored procedure on the database which executes the Insert statement.

ALZDBA,

Thank you for the resources! However, I discovered the problem. It turns out that the column I am partitioning on can not accept a column that allows nullable values...

This is very strange,

So to prove it's not the tables themselves, I have utilized zprt.order_2 and zprt.order_3 with the original data to switch them over (as if they were...

Yes I do that with the tempdb and logs already :-D.

I was just curious if there was any sort of intuitive file/filegroup structure one should follow if designing a complex...

How would you handle best practices as far as database file structure if you merged databases to one and used multiple Schemas? For instance if I put 2 databases together...

As everyone has mentioned before, that is something you will have to feel out for yourself but I can give a little insight from my own personal experience.

As...

A #temp table. Typcially containing 50k rows and 5 columns.

That makes sense, the latter sound like a lock occuring that .01% of the time.

I figured out the solution. The database in question has forced parameterization, I decided to...