How To
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,...
Increasing SQLite Performance
One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue.
Perhaps, a classic case everyone gets...
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...
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...
SQL Server Typical Maintenance Plans: Automated Database Backups
There are a lot of posts appealing to one simple truth – need perform backups on a regular basis. People will always be divided...
SQL Server Typical Maintenance Plans: Automatic Statistics Update
Some time ago, we reviewed the automation of index defrag. Now, it is time to look at statistics.
First of all, what do we need...
How to generate SQL Linked List Data with Python Generator
In this post, we would like to show how to quickly generate table values that are based on the values of another column of...
SQL Server Index Fragmentation In-depth
In this article, we will drill down into the SQL Server index fragmentation issue and how to tackle it. We will figure out why index fragmentation is a problem and how it affects overall performance and discuss how to detect and avoid it.
Using Batch Updates in Delphi Data Access Components
Data amount processed by modern databases grows steadily. In this regard, there is an acute problem – database performance. Insert, Update and Delete operations have...
