Introduction to Indexes

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Gail Shaw » Introduction to Indexes

123 posts, Page 1 of 13

1 2 3 4 5 »»»

Introduction to Indexes

Rate Topic

Display Mode

Topic Options

Author

Message

GilaMonster

Posted Sunday, October 25, 2009 12:59 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 37,640, Visits: 29,895

Comments posted to this topic are about the item Introduction to Indexes

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #808389

rosh-396756

Posted Monday, October 26, 2009 2:59 AM

Say Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 19, 2012 12:30 AM
Points: 712, Visits: 930

Amazing Gail...
I have been looking for an article on Indexes as simple and exhaustive as this for long.

Looking forward to the next 2 parts.

Thanks

Post #808541

omkarred

Posted Monday, October 26, 2009 3:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, November 03, 2009 9:37 AM
Points: 3, Visits: 5

thanks Gail...

waiting for ur next post ...
please elaborate on the clustered & non clustered indexes & implementation of it in actual db

Post #808552

GilaMonster

Posted Monday, October 26, 2009 3:56 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 12:59 PM
Points: 37,640, Visits: 29,895

omkarred (10/26/2009)

please elaborate on the clustered & non clustered indexes & implementation of it in actual db

That's what parts 2 and 3 cover.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #808560

Grant Fritchey

Posted Monday, October 26, 2009 6:13 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:50 AM
Points: 13,371, Visits: 25,143

Excellent introduction. Nice job Gail. Couldn't ask for better.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #808618

roger_os

Posted Monday, October 26, 2009 7:02 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 30, 2012 10:30 AM
Points: 49, Visits: 529

Thankyou for this, the best I have read so far, all makes sense, looking forward to the next parts

Rog

Post #808650

TheSQLGuru

Posted Monday, October 26, 2009 7:08 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 8:50 AM
Points: 3,572, Visits: 5,106

Truly a case where pictures are worth thousands of words. Nicely done.

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail

Post #808652

Noel McKinney

Posted Monday, October 26, 2009 7:15 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

Thanks Gail for mentioning that "When an index scan is done on the clustered index, it’s a table scan in all but name." Many folks think that performance is always better with clustered index scan than a table scan.

Post #808662

Steve Jones - SSC Editor

Posted Monday, October 26, 2009 7:24 AM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

Excellent job, Gail!

We're publishing part 2 in a couple weeks and part 3 as soon as possible after that.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #808674

david.stein-1140863

Posted Monday, October 26, 2009 8:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 01, 2011 4:18 AM
Points: 7, Visits: 155

This article is fortuitous for me since I attended a SQL 2008 Development class on Saturday and this topic was covered most of the afternoon.

Thanks for the review. Smile

Post #808745

« Prev Topic | Next Topic »

123 posts, Page 1 of 13

1 2 3 4 5 »»»

Permissions