Search
READPAST: what is it good for?
After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system performance. Introduction SQL Server has a lot of working mechanisms. The lock mechanism is one of the most important mechanisms. Its goal is to keep and secure the data reliability and consistency. This mechanism is very complex and depends on many variables. The mechanism is designed to let the system work in an optimal way. It is based on th
Is it REAL?
I encounter too many databases in which numeric columns are defined as REAL or FLOAT. These data types are approximate, meaning they can only represent values approximately. They are meant to represent very large or very small numbers, and they should be used in databases where a very wide range of values should be expressed, such as scientific systems. In most cases, when we need to represent numbers, we actually need exact numbers, such as 15.873 or 98.2. Such numbers can r