My security officer decided that accessing cloud CRM should happen from the DMZ. Kind of gives him tight control of information reaching the DB server. The DB server is within...

Consider you have a hung transaction. This may hold the temp table open for a long time.

True, we still need the correct way to drop temp tables.

The dirty way...

I have a report (SP) on global views that union 10 companies.

Now I took the monthly backups of these companies and try the same on the last 6 month.

So each...