Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Stairway to SQL Server Indexes: Step 1, Introduction to Indexes Expand / Collapse
Author
Message
Posted Monday, February 14, 2011 10:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 23, 2012 10:54 AM
Points: 8, Visits: 23
Comments posted to this topic are about the item Stairway to SQL Server Indexes: Step 1, Introduction to Indexes
Post #1063688
Posted Wednesday, March 16, 2011 12:31 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:36 PM
Points: 5,299, Visits: 1,378
Great article...Well written.


Post #1078802
Posted Wednesday, March 16, 2011 9:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:16 PM
Points: 15, Visits: 75
Well written; excellent analogies.

I've known of indexes for quite some time (nearly 20 years; oh I'm getting old[er]!) and have implemented and used them countless times.

I'm confident I implement indexes reasonable enough (), though will definitely benefit becoming more technically knowledgeable of them.

Starting at Level 1 and moving forward, all the while with the mindset I'm 'learning' something new, will reintro and expand my skill set on the topic.

Thx.
Post #1079061
Posted Wednesday, March 16, 2011 11:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 12:47 PM
Points: 1, Visits: 12
Thank you for your article.
I would appreciate some information on how to choose a clustered index and constraints.

I have read articles about hotspots and not choosing a incrementing id and then other articles that say this was meant for 6.5. So please explain I really don't have to deal with transactional data even for my data tables so I'm not sure that hotspots are something I need to worry about.

I created a clustered index on the id and set is as my pk and a non clustered unique constraint on several columns that by definition have to be unique. I have read some things by Celko that I believe says incrementing fields are extraneous and he would prefer just using the compound pk. But, I like my id for foreign keys.

I also read that size matters and if it's a small table a full table scan takes place anyway. My look up tables are small but my data tables house millions of records.

Post #1079126
Posted Thursday, March 17, 2011 12:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, April 16, 2011 10:43 PM
Points: 19, Visits: 39
gr8, well written

www.sqlsuperfast.com
Post #1079495
Posted Thursday, March 17, 2011 2:58 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 15, 2012 5:05 AM
Points: 195, Visits: 77
Great article. Very apt Waiting for the other all sequences
Post #1079524
Posted Tuesday, March 22, 2011 12:31 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
Thanks, I think this is the first index article genuinely written with a n00b in mind.

I'm waiting for your next StairWay. Any idea when we should expect that?


--
Post #1082246
Posted Tuesday, March 22, 2011 12:43 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:16 PM
Points: 15, Visits: 75
Do a search on SqlServerCentral for:
Stairway to SQL Server Indexes

There seem to be 7 Steps so far.

Also, consider checking out this entire "Stairway" series at:

Stairway Series
(http://www.sqlservercentral.com/stairway)

Post #1082254
Posted Tuesday, March 22, 2011 12:48 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 31, 2011 1:10 PM
Points: 480, Visits: 1,163
Oh nice! Thanks for the link.

--
Post #1082260
Posted Tuesday, May 24, 2011 12:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 23, 2012 10:54 AM
Points: 8, Visits: 23
Gary,

There will be 15 levels (articles) in the indexing Stairway. I have delivered all 15 to the editor, Kalen Delaney, and I believe she has passed them all on to Redgate. There is always some delay while Redgate proof reads, adds graphics etc. But, I would expect to seem them all on the Stairway soon.

Dave Durant,
Author.
Post #1114294
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse