<Sorry if I repeat, skipped many posts>

BI is by far the hardest job I've had. You need to know EVERYTHING about the business to do a good job. ...

Depends entirely on what the optimzer thinks is the fastest thing to do.

I'd suspect that if not filters are based on the xml then yes, those will definitely be procesed...

Any reason you can't just restore the latest prod backup to get everything back in sync?

I'd check the sql error log. Maybe there's info there.

If not do a search for files with mdf extension.

I never use between for dates (inclusive of both ends). I preffer this =>

where dt >= @StartDate and dt < (no equal) @EndDate

That way you don't have to worry...

There's an import wizard which works cross server.

right click on the db, tasks, import (or export) data. Then follow the wizard. You can save that package in case...

Profiler (server side trace) is very light.

This is exactly the kind of work it was built to do.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

I actually preffer that to the dmvs (just my own pref.)

Simple update or merge statement.

Checkout linked servers in books online. Pretty easy to set up.

SSIS is another option but it's a bit bigger learning curve.

sp_whoisactive is also very nice...

What you need is to make your own trace.

Openup profiler (windows, start, sql, performance).

then select what you need there. There are dmvs also but it depends on what kind...

See the ids in both tables. Maybe you got the joins wrong or there's no data.

Ya those exemples are harder to fin in the documentation (not in create trigger, but burried deep in a link).

http://msdn.microsoft.com/en-us/library/ms190752(v=SQL.90).aspx

If you turn that last inner join you added to a left join do you go back to 1 row being return? If so it means that you have...

Exrpess 2088 R2 has a 10 GB limit, but it still seems a little too low for your needs. Maybe time to use 2 dbs.

Respect and confidence comes from within. Do your job well and be nice is what makes a good co-worker.

Did your boss tell you he was afraid you were going...