thanks... i had to read BOL to get this right... 🙂

thanks :)... i m trying to configure it on my sql server enterprise edition now...

thanks 🙂 didn't know about this...

thank you :-)... i have been using this script from the time it was first published... is there any change from the first query ?

thank you... however i will take some time to understand this query ... :-D.. still not so perfect.

very well said... absolutely correct...:-)

Rick Todd (5/11/2010)

---

ziangij, I would definitely recommend reading through some of the comments, but here's my summary:

If you have other logic to prevent/handle collisions, checksum might be fine. If you...

thanks :-)... was really not aware of this stuff... also a good interview question...

i generally don't use recompile option for my procs... execution plan is created the first time stored proc is executed and then it takes less time to execute...

plz. suggest... what...

good question... didn't know about this... but was wondering has anybody implemented this peer stuff in their organisation and how does it perform vis-a-vis the existing systems ?

thanks..:-) good question

I actually use checksum function for ETL jobs. Can anybody throw some light which one is better ? Checksum or Hashbytes...

great article... thank you 🙂

got to learn something new today... thanks 🙂

thanks for this wonderful question 🙂