SQL Server Execution Plan – Part 1 (Basics)
Hi geeks, First of all I would like to make an apology for not posting any blogs for the last two months (was busy with my work) but it’s better late …
Read MoreTag: query optimization
SQL Server 2012: Generating Dummy Data using Sequence Objects
When posting my last blog on sequence I realized that sequences can also be used to generate dummy data for test tables. On further analysis I found that it’s faster than …
Read MoreSQL Server Add Not Null Column to Existing Table
Most of you must have come across the pain of adding a not null column with a default value to an existing big table. It takes minutes to SQL Server Add …
Read MoreSQL Server: Joins Hints, joins algorithms, and Join hint syntax explained
Join syntax when specifying join types. Hi everybody. This is my first blog, so be indulgent about me as a first time author. The idea of this article spurred to me …
Read More