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 statistics for?
During execution of any query, query optimizer is trying ...
December 01, 2015
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 same table. For this purpose, we will use the Python Generator being a part of ...
November 30, 2015