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

image

I attended session of Pinal Dave and Vinod Kumar on SQL Misconceptions. Few of points from that session is as following

  1. SET ROWCOUNT and TOP and OrderBy is not same.
  2. Set RowCount , Top and OrdetBy gives different execution plan
  3. Misconception is Cluster Index gives the result out in Order. It sort and gives result
  4. Seems due to parallelism Cluster Index does not gives result in order
  5. Cluster Index assure u sorted result only if you are explicitly using order by in the query
  6. Precision of small DateTime 31 sec rounded to next minute and 29 sec gets truncated to orevious minute
  7. As of textbook cluster index physically store the data.
  8. Cluster Index does not store in physical order
  9. Go 10 will run 10 times
  10. In simple recovery model your transaction log is as big as longest transaction run in the system.

 

I hope this quick post is useful. Thanks for reading.

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

  1. Thank you Dhananjay for this excellent list. Wow – you really paid attention to details.

  2. […] They showed some nice demo on SMALLDATETIME, Clustered Index and a lot more. you can read this BLOG  from Dhananjay Kumar. This was a much awaited session and the room was full […]

  3. Nice points. Just thought would share the blog post which I did last year on “Does Clustered Index physically orders the data within a table? – http://vadivel.blogspot.in/2011/09/does-clustered-index-physically-orders.html

    –Vadivel
    MVP SQL Server

  4. Thanks for doing one of a kind thing at #TechEdIn. This is was an awesome experience to see the love and support. Thanks 🙂 …

  5. Dhananjay Kumar

    thank u sir 🙂

  6. […] will not try to rehash the content here. But Dhananjay Kumar did a live blogging of this session here. That gives you a quick list of what we […]

  7. […] Some Important Points from “SQL Misconceptions” Session from Pinal Dave and Vinod Kumar […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s