From your later posts it sounds like you're supporting another group remotely. If that is the case, or code changes are not an option to add logging, then might I...

If a deadlock were occurring I would expect the SSIS package to fail if it were chosen as the victim, or proceed if it survives the choice. How long does...

I'll agree it is confusing. The article uses "SSDT" to refer to the whole product, including the SSIS development tools, however what they really mean when they say "target" is...

Very well done. I especially like the comparison table you produced. I have plans to refer some developers to read this article as the misuse of Table Variables is rampant...

inHouseDBA (6/7/2012)

---

Thanks again.

Few more questions about Stats:

1.How about replacing or creating useful statistics from _WA_Sys_ auto created system stats?

Is it recommended to replace an old auto stat (_WA_Sys_) with...

Yes. Any auto created or manually created column stats.

If the heap has column-stats on it, yes, it...

How is prototyping progressing?

In case anyone else finds this link in the future the download is available here:

Microsoft SQL Server 2012 Feature Pack > Microsoft SQL Server 2012 Upgrade Advisor

You're welcome.

Permissions Required to Run SQL Server Profiler

SQLCrazyCertified (6/7/2012)

---

opc.three (6/7/2012)

---

jitendra.padhiyar (6/7/2012)

---

OPC.Three:

You are correct that clustering can be used. And I said clustering will ensure hardware availability, but its not 100% DR, thats why I said clustering alone...

jitendra.padhiyar (6/7/2012)

---

OPC.Three:

You are correct that clustering can be used. And I said clustering will ensure hardware availability, but its not 100% DR, thats why I said clustering alone can not...

jitendra.padhiyar (6/7/2012)

---

SQLCrazyCertified (6/7/2012)

---

Hi opc.three, I just want to make sure something.....Is it 100%...

Eugene-928407 (5/30/2012)

---

Using the semicolon has done the trick. Thanks for that. I hadn't actually seen that kind of syntax previously. I figured I needed to terminate the previous statement, but...