SQL Server Tools
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...
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,...
How to Build a Database from Source Control
There is no doubt that database developers can and should benefit from using source control systems. Regardless of the type of source control system, developers...
How to reduce MSDB size from 42Gb to 200Mb
Recently I've got a spare minute to see why an old test server was running too slow... I had nothing to do with this,...
XML, XQuery & Performance Issues
In this article, we will discuss some pitfalls related to XML and XQuery that may lead to performance issues.
The following code will generate a test...
Devart was the Sponsor of Ukrainian Data Community Kyiv
We were more than happy to take part in the New Year meeting of Ukrainian Data Community in Kyiv on 15 Dec 2015. It...
What is the fastest way to calculate the record COUNT?
I have always liked simple questions with lots of pitfalls. Here is the one: how do you count the total number of records in...
Devart was the Silver Sponsor of SQL Saturday #426 at Lviv
Devart was a Silver sponsor of SQLSaturday #426 that was held on 5 Dec 2015 at Lviv, Ukraine.
We would like to thank the organizers: Sergey Lunyakin, Andrey...
SQL Server 2016 CTP3.1 – What’s New for Developer?
Not that long ago, I remember Microsoft's CEO Satya Nadella has been announcing a new version of SQL Server 2016. And all of a...
IT NonStop 2015 – Kharkiv (Ukraine)
The international IT conference IT NONSTOP was held in Kharkiv (Ukraine) on November 28, 2015 and gathered a lot of enthusiastic participants.
A speaker of...
