The Many Benefits of Money…Data Type!

  • Article

Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).


2,761 reads


T-SQL Tuesday #125 – Unit testing databases – we need to do this!!


Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...

T-SQL Tuesday Live–7 Apr 2020


Last week went a little crazy, and I learned something: don’t post a Zoom...

Getting Your dbatools Version–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs


Convert date value

By pwalter83

Hi, I have a requirement to convert a date value like '7th March 2020' ...

Partitioning table techniques which one is best way?

By Saravanan_tvr

Hello All, I am about to do partitioning for my DW tables based on...

MAXDOP and cost threshold for parallelism settings

By vsamantha35

Hi All, On one of our newly migrated sup-prod azure vm which is running...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers