JOIN HINTS

Using hash values in SSIS to determine when to insert or update rows

A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing

Comparing a hash

RE: Permissions and DBO question

Thank you one and all.   I was a little leary about changing the DB owner to another Domain Account - even one that is a member of the local admin group and one that starts the Services.  I kinda walked into a mess here and I have Databases 'owned' by 3 or 4 people that […]

RE: Question of the Day for 07 Sep 2004

The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column will be filled with 'N' automatically as such.Regards

RE: Yukon Passwords

The article is a good summary, but the fact that it covers SQL 2005 leaves me wondering how relevant it is.  Come back in nine months and it may be more relevant, but even then it will be another six months before we upgrade our systems.

RE: Should DBAs attend Development Meetings

Most DBA's I know only care about their precious database and how well it runs. Weather this is because they have always been excluded from the commercial side of things or they are genuinely not interested in going to these meetings I have never asked them. However, I’m a strong believer that all stakeholder areas […]

RE: Printing Out A dB Schema

Yes I don't have a plotter here, and I need to take the file to a blueprint office to get it printed, I need to know which file(s) I should take that would have the schema in. Thanks CJ

RE: Using DTS in an off the shelf application

Before you get too heavily tied into using DTS as part of your application, take a look at the following. Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface