Yes, thank you very much.

Lowell,

Hey yeah your right, thanks.

Whatever happened to your Dog Avatar? I liked it. What model is that Gas:-) Mask? I did not see that one before.

Geoff A (4/5/2012)

---

well, if you want to use Profiler to capture blocks, you have to first turn it on via sp_configure.

SP_CONFIGURE'blocked process threshold',10 ;

GO

RECONFIGURE

;

GO

this sets the process...

I do not see a Blocked Process Report Event in SQL Server 2008 R2?

Thanks...

Thank you for the response.

Do you have a little more detail or could you please point me to an article that lists actions required Step By Step?

Our counter response to Architectural Preference is going to be Customer Mandate.:-P

ok, I would probably have the Database in Full Recovery but change it to Simple before the load and change it back to Full then perform a complete Backup.

That way...

Lynn Pettis (4/4/2012)

---

Still need to run t-log backups or you could run out of disk space as the log file keeps...

Lynn Pettis (4/4/2012)

---

Not...

Bulk-Logged Recovery Model is always an option, right?

Regardless of the recovery model I want the Staging and Data Warehouse to be in separate Databases. I want smaller backups and faster recovery times.

opc.three (4/4/2012)

---

Welsh Corgi (4/4/2012)

---

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in...

I like sp_WhoIsActive.

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full recovery mode....