October 23, 2009 at 2:35 am
hi
i am trying to find out differnece between Key lookup and RID lookup, but couldnt ?
can anyone tell me ?
also please tell me any specific differnce between index scan and table scan
thanks a lot in advance
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2009 at 3:07 am
BOL is your friend... look here
http://technet.microsoft.com/en-us/library/ms191158(SQL.90).aspx
October 23, 2009 at 3:12 am
Nice Link Ian, much appreciated. good reference to refresh my memory 😀
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 23, 2009 at 3:14 am
Silverfox (10/23/2009)
Nice Link Ian, much appreciated. good reference to refresh my memory 😀
My pleasure, Mr Fox;-)
October 23, 2009 at 3:24 am
No worries Ian, It is nice to look at BOL and suddenly realise that you dont know it all 😛
Your ever humble servant lol
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 23, 2009 at 3:27 am
Also, http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 3:33 am
I can always rely on you Gail to simplify everything down to idiot level 😛
When's the next article on aggregates, coming out... dont keep us waiting too long 😉
Good Articles, once again
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 23, 2009 at 3:42 am
Silverfox (10/23/2009)
When's the next article on aggregates, coming out... dont keep us waiting too long 😉
27th January last year.
http://sqlinthewild.co.za/index.php/2008/01/27/execution-plan-aggregate-operators/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2009 at 3:53 am
You need to update the page then, it didnt say it was available 😉
Just read all the remaining articles 😀
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 23, 2009 at 3:58 am
http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/ or look at the Execution Plan category. Looks like that was the only one missing a link.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply