<quote>From the Last Sentence of the Conclusion in the Article...

To maintain the best precision of the final result all intermediate calculations must be performed on numbers in floating point...

Also, if you do the research you will also find the banker's round, also called round to even is used in signal processing as well.

There are numerous articles on...

dont know what to say here.

Ok....

• This reply was modified 4 years, 5 months ago by  Sergiy.

sorry about that. Supposed to be copy-paste, something went wrong.

Corrected the article. Should be updated soon.

If it happens on weekend only, then it's most likely an index maintenance job.

or a massive update on a "main" table.

I've got a shorter version of that procedure. No update required.

USE [tempdb];

GO

--==== Remove existing objects
IF (OBJECT_ID('tempdb..#LOANS','u') IS NOT NULL)
BEGIN
DROP TABLE #LOANS;
END;

IF (OBJECT_ID('tempdb..#LOAN_CUSTOMERS','u') IS NOT NULL)
BEGIN
DROP TABLE #LOAN_CUSTOMERS;
END;

IF...

• This reply was modified 4 years, 6 months ago by  Sergiy.
• This reply was modified 4 years, 6 months ago by  Sergiy.

I prefer not to depend on DATEFIRST settings in my code.

There are several pretty simple techniques to make your code independent of it.

For example, using system variable @@DATEFIRST in your...

Yeah.

Still the future...

No need to pile on for the following but, because of things like this, security breeches in the world just don't surprise me anymore.

https://www.sqlservercentral.com/forums/topic/only-one-expression-can-be-specified-in-the-select-list-when-the-subquery-is-not

How do these people get...

It's funny, the most obvious option of not using lousy Windows interface on...

/shrug I think that the fact that dictionaries are maintained transparently in the internal guts of column store indexes vs having to maintain and join a lookup table by hand...

Thanks Frederico. Cool stuff.

I only made one change to your script:

            
December 27, 2019 at 2:39 am
            
#3710634

            
            
                                                
        

Columnstore would work by tokenizing and limiting the repetition of values. A simple example is gender. Say we have 3 values (M, F, Other). If we had these...

Frederico, do you have any test case to support your speculations?

I (and I guess Jeff Moden too) would be particularly interested in a test script which demonstrates advantages of splitting...

Steven,...