SQL SERVER TRANSACTION ISOLATION LEVELS

SQL SERVER TRANSACTION ISOLATION LEVELS

by Mukiibi Ivan

On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if there is heavy traffic the safer and

Continue reading […] SQL SERVER TRANSACTION ISOLATION LEVELS […]

 

Why Do We Need Statistics and to be more specific SQL Server statistics

 

This post is written by Ivan Mukiibi, a young SQL Server professional based in Kampala, Uganda. Ivan is devoted to SQL Server performance tuning, SQL Server internals and also he is passionate about ETL solutions. At this early stage of his DBA carreer he has done an outstanding job researching and interpreting the facts in

Continue reading […] Why Do We Need Statistics and to be more specific SQL Server statistics […]

 

A bit more on recompilation in SQL Server

SQL Server takes care of compilation and recompilation automatically, as we all know. The first time a statement is executed, the SQL Server query optimizer checks if there is a plan already cached, looks at the statistics related to the objects involved in the statement and uses a sophisticated algorithm to decide whether it should

Continue reading […] A bit more on recompilation in SQL Server […]