SQL Server Tools
SQL Server 2016 RC0
The news about Microsoft's intention to "chum" SQL Server with Linux keeps floating around. But I haven't heard a single word about SQL Server...
Backup and Restore Databases in SQL Server
In this article, we will talk about the benefits of backing up SQL Server databases, different backup types, and backup strategies.
The immediate purpose of...
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...
