• psingla (7/5/2013)


    does it always skips 1000 rows or any random number?

    SQL Server 2012 uses blocks of 1000 in a cache. When you restart the SQL Server service the next block of 1000 is used.

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]