Pages

Sunday, September 15, 2013

SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used | Journey to SQL Authority with Pinal Dave

"What will be the order of the result set of SELECT statement on clustered indexed table when ORDER BY clause is not used?" I was asked this question by one of the smartest tech team manager in my company. I really enjoyed answering the question. The common misconception is: If ORDER BY clause is not… Continue Reading...

Source: SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used | Journey to SQL Authority with Pinal Dave