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...

Rudyx - the Doctor (7/26/2016)

---

declare @CoverUp varchar(16)

select @CoverUp = ['True'|'False'] --> make your choice

if CoverUp = 'True'

...

Post what you have tried and the errors

😎

Piling on, sp_Blitz is good but one must thoroughly validate all settings and configurations on the servers in such a situation. Far too often have I seen simple mistakes like...

The calculation is quite simple, divide the number by 1000 to get the year and the add the remainder of the division - 1 as days, here is a quick...