Some Important Points from “SQL Misconceptions” Session from Pinal Dave and Vinod Kumar

I attended session of Pinal Dave and Vinod Kumar on SQL Misconceptions. Few of points from that session is as following SET ROWCOUNT and TOP and OrderBy is not same. Set RowCount , Top and OrdetBy gives different execution plan Misconception is Cluster Index gives the result out in Order. It sort and gives result … Continue reading Some Important Points from “SQL Misconceptions” Session from Pinal Dave and Vinod Kumar