A more common scenario would be something like this, given the facts that:

a) Inserts and update are relatively inexpensive

b) Data comparison is relatively expensive

c) Good enough algorithms...

jasona.work (9/16/2015)

---

Ed Wagner (9/16/2015)

---

jasona.work (9/16/2015)

---

Hmm...

The server is a *little* bit loud...

Like, sitting on the workbench, basement door closed, can still hear the fans roaring on the main floor loud...

This...

Could be...

Utopia

Sean Lange (9/16/2015)

---

I have a very awful table structure that I have to deal with. This is in an ERP and I can't change the tables...yes I know how completely...

tauseef.jan (9/15/2015)

---

hi,

I have a table in PRODUCTION server with more than a billion records. I am running the below query to check the exact number of records in it.

select count...

Minnu (9/16/2015)

---

Hi Team,

I have a database with Name 'Marketing' and i have created another database 'Marketing1' in same instance.

i want to bring the 'Marketing' database offline and alter 'Marketing1' to...

pietlinden (9/15/2015)

---

Anybody using (and like) PowerView? Are there any good resources on it? I kinda like PowerPivot (just having a hard time getting my head around it)... but PowerView...

Rumble

In the case of using the convert function on the column in the where clause, I would only consider it if there are relatively few rows being sought, as those...

Jeff Moden (9/15/2015)

---

Heh... remind me not to even attempt such questions in the future. I mentally added "and do it right" to the question which, of course, would have...

Steve Jones - SSC Editor (9/15/2015)

---

The idea in checksum is to reduce work. ALL hashing algorithms have the possibility of collisions. The faster/shorter/cheaper the algorithm is, the more likely there...

Commute

Trying this out :Whistling:, I'm wondering on what kind of logic Bobby is using.....

😎

USE tempdb;

GO

SET NOCOUNT ON;

;WITH T(N) AS (SELECT CONVERT(TINYINT,N,0) FROM (VALUES (1),(2),(3),(4),(5))AS X(N))

,BASE_DATA AS

(

SELECT

...

Same column order rule applies there too;-)

😎

robin 66943 (9/15/2015)

---

This makes no sense to me. If the checksum is calculated differently, then when the checksums match that will most likely imply the data is different, not the...