Yes, that is a LOT different to the original question! 🙂

I agree with what Kraig has said, but I would add that jumping in to the ETL process as the...

Why do you want to have separate staging databases for each source? Seems overkill to me. Remember that SQL Agent is just used for running scheduled or ad-hoc jobs; the...

I concur with Grant about the lack of decent support for ERWin from CA, having experienced it myself. :angry:

Can you move the files to another folder once you've imported them? If not, how about writing the file names into s table as/after you process them and then do...

In addition to what Gail said, you might want to consider reorganizing indexes instead of rebuilding them, depending on the level of fragmentation. As a rule of thumb, use REORG...

Okay, not sure that I understand fully, but I always try and do as much as possible in my Source query so assuming that you are specifying a SQL query...

Do you want to create a derived column based on other columns or do you want to direct data down different paths depending on column/derived column values? If the former...

Just above the Conclusion section there are two DROP INDEX statements....

Koen Verbeeck (6/10/2014)

---

If I recall it correctly, some SQL Server Agent jobs owned by the DBA at a previous project started giving issues when the DBA was fired and his...

It could be that Max Degree of Parallelism (MAXDOP) is set to 1 at the instance (server) level, but as others have stated, parallelism is not edition-specific.

Regards

Lempster

EDIT: Didn't read the...

Are...

Cliff O'Reilly (6/6/2014)

---

I think auditing the history of data is important. It's not something that can be added retrospectively so the sooner you implement a solution, the better.

My personal preference...

SQLRNNR (6/4/2014)

---

We can't tell you how to fix it because we don't have near enough...

Well, if you are using either a local login mapped to a remote login or have the 'be made using this security context' radio button checked, the password(s) will be...

Ah, okay, you're running out of space on that drive because of the mdmp file. Do you have any of the following trace flags enabled?:

Trace Flag 2551: Produces a filtered...