Hugo Kornelis (7/31/2016)

---

I think you already nailed it in your very first reply, but the OP either misunderstood...

Piling on Kevin's fine answer; production system tuning should not be an trial & error process but rather information gathering with careful interactions and modifications to the system. Knee jerks...

Slightly different flavor with the addition of "valid groups" instead of hard coding which values to combine

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA(StateID,DistrictID,CityID,Grp,VoteCount) AS

(

SELECT 1 AS StateID, 1 AS DistrictID, 1 AS...

Feel free to pitch in, someone not having a great day😀

😎

joejuska (7/30/2016)

---

No I DO NOT WANT TO HASH ONLY THE FIRST 50 CHARACTERS. I WANT TO HASH THE ENTIRE FILE BUT HAVE THE RESULTANT FIELD NVARCHAR(50) OR CHAR(50) INSTEAD...

In this case there is no difference between an assumption and a casual observation, nothing solid to proof anything.

😎

Here are two test harnesses, a) measures the difference between calculating the...

joejuska (7/30/2016)

---

You said "I'm not to keen on a calculated column for the hashes, performance being an obvious one" the theoretical performance hit is extremely negligible to the point of...

joejuska (7/30/2016)

---

You said "The length of the output has nothing to do with the input lenght" but that seems to be what is happening. How else do you explain...

IIRC, prefixing it with sys. did the trick => sys.sysarticles

Could be wrong, just have this recollection.

😎

Here is a suggestion towards a solution or rather a sketch of one which simply outlines one method of finding multiple overlaps. Since it works on the interval of minutes,...

Quick thoughts;

The HASHBYTES has the 8000 and 4000 character limits for VARCHAR and NVARCHAR data types respectfully. This means that if one wants to create a hash of character strings...

You're very welcome,

and thanks for the feedback.

😎

First...

The simplest way is normally to update the related (foreign key) tables, making certain that the values exists before attempting the insert / update of the other tables which have...

komal145 (7/27/2016)

---

My query column coversion to varchar :

CONVERT(varchar(19),[Date],0) =2016-07-05 02:38:52

Before conversion date column value in table: 2016-07-05 02:38:52.1900000 -04:00

Since there is change in flat file columns, i changed datatype...