Enabling AUTO_CLOSE is a bad idea?
From a personal perspective, allowing a production database to run with AUTO_CLOSE option is not the best practice. Let me explain why you should not enable AUTO_CLOSE and the consequences of using this ...
February 12, 2016
What is faster inside SUM & AVG: 0 or NULL?
There are three aggregate functions that are most often used in practice: COUNT, SUM and AVG. The first one has already been discussed previously, while the other two have interesting performance nuances. ...
January 18, 2016