Database Engine

FLOAT datatype casting issue

FLOAT datatype casting issue

Do you use the FLOAT datatype? If so you had better read this…… Today I came across an issue somebody posted on the Microsoft Connect site citing a bug with how the FLOAT data type was calculating a value when being cast to various other datatypes. You can read the original connect item here – […]

Writing queries without data

Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This may be because you don’t have a machine with enough storage capacity, it might even be on a laptop so there is also the security aspect. So how do you address the issue of writing […]