Spool Operators: Eager Spool, Lazy Spool, Row Count Spool There are a lot of operators in the query execution plan that we generally overlook (I do this for those operators which I have no clue about). Sometimes these operators prove out to be pivotal in the performance of the query and we are forced to take good care of them....

New Features of SQL Server Denali By Kautuk Pandey We have just been greeted by another new version of SQL Server in the form of SQL Server 2012/Denali. This release comes with a number of new features. In this article I talk about a few of them. AlwaysON is definitely going to be one of the most exciting new things...