TomThomson (8/31/2016)

---

It's certainly indisputable that Microsoft (or was it the SQL Standards committees?) has completely screwed up fixed point arithmetic by having insane detemination of the precision and scale resulting...

I'll have to disagree with you there, ol' friend. Automatic truncation to a scale of 6 isn't correct. At least not in my book. If a dollar store calculator did...

Create a job which every minute records current time and ident_current('session').

When you encounter the issue again - check when the identity was reseeded.

That must give you a hint who's the...

Jeff, what do you say when somebody complains that he/she cannot find today's transactions by querying...

Jeff, I usually quick on blaming MS for this and that.

But in this case they cannot be blamed.

They did not create any mess.

Because there is no mess.

It's all done right,...

The Dixie Flatline (8/30/2016) if you are willing to pay the price in disk space, it's possible to generate a routine that will generate the typo patterns I handle with...

Grant Fritchey (8/31/2016)

---

Sergiy (8/30/2016)

---

A clustered or covering index having the column used for the range selection as...

RonMexico (8/30/2016)

---

I'm reaching out looking for pointers as I'm starting to brainstorm ideas how to handle a task that has been presented to me. We receive a set of...

A clustered or covering index having the column used for the range selection as a first column...

Oh, gosh.

No wonder our industry has a bad name.

Tom, here is something for you (and others) to think about.

And verify your instincts.

DECLARE @d DECIMAL (38, 28), @f FLOAT

SET @d...

if you're sure that no even would ever take longer than 24 hours then you can use this trick:

SELECT (24*60 + DATEDIFF (MINUTE, '19:00' , '00:00'))%(24*60)

But anyway, I'd recommend you...

Probably not...

Grant Fritchey (8/30/2016)

---

Problem is that the allocated space on the log would still be there, even if the log was truncated. From the stand point of the file system, they...

Pivot-156509 (8/30/2016)

---

@matt-2 Miller (#4): no

@Sergiy, @Lynn Pettis: because the SESSION's row are delete few time after, you can see this on code. When a new row is inserted the previous...

Solomon Rutzky (8/30/2016)

---

It strikes me as odd to hear that the FLOAT / REAL datatype is "precise" when by definition it is "imprecise". The following quote is taken from the...