Are...

Thank-you, all for your time and valuable feedback.

Yes, CHECKSUM fails to detect symmetric changes and has therefore been listed only as a "basic" change detection mechanism. The "ideal" one would...

Thank-you for taking the time out and reading it. I am glad that you liked it and that my article will be helpful to your team in the future.

Thanks again!

I did not know about these, so this question was a learning experience. Thank-you very much, Paul!

An easy one for the end of the year - thank-you!

Have a Happy & Prosperous New Year 2013!

Happy Thanksgiving!

Very nice question! With a little thought, I was certain about the answer. While this was the first time I heard about "halloween protection", the chain of thought I used...

Most administrators I have worked with are quite proficient in troubleshooting their area of hardware/software, however the one thing they would benefit from the switch over to development is understanding...

Nadrek (9/17/2012)

---

I'd have to rate the particular example selected as "Implement all the requirements to get system table updates to act as expected."

In this case, the failure wasn't in updating...

Thank-you, all for taking the time out and reading my article. I really appreciate it!

WayneS (9/17/2012)

---

Nakul,

Good Article. Thanks for pointing out other areas where updating system tables can cause issues.

Out of curiosity, is the sp_configure option for Allow Updates set to 1 on your...

For the better part of my career till date, I was working on sustenance assignments. These assignments required me to fix bugs in an application that was 10years old. Then,...

This is the "bell-curve" performance evaluation system that is unfortunately, in practice in most IT consulting service based organizations that I know of. The sub-processes have very attractive names, but...

Personally, I believe that formatting and local adjustments should be performed by the application/UI layer and not the database. Dates in the database should be stored as UTC and fetched...

paul.knibbs (7/13/2012)

---

Nakul Vachhrajani (7/13/2012)

The maximum supported number of logical processors by SQL Server 2008 R2 is 256 logical processors (which is a limit in-turn imposed by the operating system -...