HASHBYTES limits

HASHBYTES

How to implement SHA-2 in SQL Server 2005 or 2008 with a CLR assembly

SQL Server 2012 supports SHA-256 and SHA-512 through the HASHBYTES() function, but earlier versions of SQL Server do not. SHA-256, SHA-384 and SHA-512 can, however, be implemented in SQL Server 2005 or SQL Server 2008 with the CLR assembly described in this article.

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.

An in-depth look at change detection in SQL Server - Part 02

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

An in-depth look at change detection in SQL Server - Part 01

Auditing, conflict resolution, tamper & concurrency protection are some of the most common requirements for any enterprise system – this 2-part series presents an in-depth look at the various change detection mechanisms available within SQL Server.

Hashing

HASHBYTES can help quickly load a Data Warehouse

Data warehouse loads can be time consuming - this method can be used in some instances to help speed things up.

error: 17883,severity 1

Howdy I have noticed the following error message in sql server logs. I'm hoping someone can shed some light on this and explain what it means. error: 17883,severity 1, state: 0 Process 68:0 (86c) UMS context 0x12200d30 appears to be non-yielding on schedule Sql server 2000 standard sp3a Thanks

RE: LEFT OUTER JOINS turns to INNER JOIN automatically ????

Hi Prateek, Check this articlehttp://support.microsoft.com/default.aspx?scid=kb;en-us;176480Well it doesnot really elaborate on the internal logic and implications of AND and WHERE clauses for Outer Joins but it does throw little light on how they work.