Michael J. Swart

September 7, 2010

Invitation to Participate in T-SQL Tuesday #10 – Indexes

Filed under: SQLServerPedia Syndication,Technical Articles — Tags: , , , , — Michael J. Swart @ 10:00 am

T-SQL Tuesday Logo

What are your thoughts on Database Indexes?

(Update 09/20/2010: Find the roundup here) September already! Summer holidays are over and that means no more lazing around. The second Tuesday is fast approaching and that means that T-SQL Tuesday is almost here. And this month I will be your humble host and the topic is Indexes.

A book index

A book's index is not that different than a database index.

Indexes

Indexes are strange things. You never need to explicitly create one to create a fully-functional database, but if you want a database to perform well, they’re indispensable.

And there are so many aspects to write about! Like internals, covering, clustered, xml, fulltext, b-trees, hints, maintenance of, included columns, filtered, redundant, missing and tons more.

In fact my SQL Server 2008 Administrator’s Pocket Consultant (The first handy textbook I could grab) has an index entry on “indexes” that has 22 sub-entries.

About T-SQL Tuesday

For those not familiar with T-SQL Tuesday, it’s an idea hatched by Adam Machanic (Blog|Twitter). A monthly event, T-SQL Tuesday is a chance for any blogger to write and post an article on a single topic determined by the host (i.e. yours truly). Leave a comment here on that day and a day or two later, I’ll include your post in the round up.

Follow These Rules

  1. The post must go live on your blog between 00:00 GMT Tuesday, September 14, 2010 and 00:00 GMT Wednesday, September 15, 2010.
    In other words, set your sql server date, time and timezone properly and run this script:

    IF GETUTCDATE() BETWEEN '20100914' AND '20100915'
    	SELECT 'You Can Post'
    ELSE
    	SELECT 'Not Time To Post'
  2. Your post has to link back to the hosting blog, and the link must be anchored from the logo (found above) which must also appear at the top of the post
  3. Leave a comment here (below) or I won’t be able to find your post. I expect trackbacks work properly, but if they don’t check back here just in case and leave a comment if necessary.

We also encourage you to …

  • … include a reference to T-SQL Tuesday in the title of your post. (The more we bloggers advertise T-SQL Tuesday, the more we bloggers get T-SQL tuesday readers)
  • … tweet using the hash tag #TSQL2sDay to follow links and other relevant conversations.
  • … consider hosting T-SQL Tuesday yourself. If you’re interested let Adam Machanic Know. If you’ve participated in two T-SQL Tuesdays previously and you don’t let your blog go stale (blog once a month for the last six months) then he’ll put you in the rotation.
  • And out of curiosity… Are you team indexes or are you team indices? Personally I’m team indexes but I work with a guy who seems to be so team indices that I’ve caught him saying indice for the singular!

That’s it! Good luck! Can’t wait to see what you guys have in store.

Your humble host,
Michael J. Swart

45 Comments »

  1. [...] by the Database Whisperer, Michael Swart (Blog).  We have been given the challenge to write about indexes err indices err indexes – well, you get the [...]

    Pingback by September TSQL Tuesday | SQL RNNR — September 8, 2010 @ 4:52 pm

  2. [...] Invitation to Participate in T-SQL Tuesday #10 – Indexes – from Michael J. Swart [...]

    Pingback by Weekly Challenges – 9/10/10 « SQL Feather and Quill — September 13, 2010 @ 12:41 am

  3. Hi Michael…

    Great topic with oodles of possibilities!

    Looks like the clock went past midnight, so here’s my entry:

    http://bradsruminations.blogspot.com/2010/09/t-sql-tuesday-010-little-known-index.html

    –Brad

    Comment by Brad Schulz — September 13, 2010 @ 8:29 pm

  4. My post’s at http://sqlblog.com/blogs/rob_farley/archive/2010/09/14/table-no-such-thing.aspx – thanks for hosting Michael!

    Comment by Rob Farley — September 13, 2010 @ 9:16 pm

  5. [...] 14, 2010 by pinaldave This blog post is written in response to T-SQL Tuesday hosted by Michael J. [...]

    Pingback by SQL SERVER – Disabled Index and Index Levels and B-Tree « Journey to SQL Authority with Pinal Dave — September 13, 2010 @ 9:31 pm

  6. Hello Michael, here’s my post…

    http://noelmckinney.com/2010/09/constraints-unused-indexes/

    Thanks for hosting, this is my first T-SQL Tuesday participation, it was fun and helpful to have a deadline!

    Comment by Noel McKinney — September 13, 2010 @ 9:35 pm

  7. T-SQL Tuesday #10 – Applying Indexes To Replicated Tables…

    It’s T-SQL Tuesday time again! This month Michael J. Swart (blog|…

    Trackback by English To SQL — September 13, 2010 @ 11:20 pm

  8. Thank’s for hosting this great event Michael, here’s my first T-SQL Tuesday post:

    http://sql.richarddouglas.co.uk/archive/2010/09/t-sql-tuesday-10-unused-indexes-indices.html

    Rich

    Comment by Richard Douglas — September 14, 2010 @ 4:08 am

  9. Thanks for hosting this month, here is my first TSQL Tuesday post:

    http://www.erinstellato.com

    Happy reading everyone!

    Erin

    Comment by Erin Stellato — September 14, 2010 @ 6:35 am

  10. And following the rules… Here’s my post: Guts of a Clustered Index

    Comment by Michael J. Swart — September 14, 2010 @ 8:50 am

  11. [...] , SQLServerPedia Syndication , TSQL Tuesday with zero comments This post is my contribution to T-SQL Tuesday #10, which is being hosted by Michael J. Swart (blog | [...]

    Pingback by Potty Chairs and Duplicate Indexes | Bob Pusateri - The Outer Join — September 14, 2010 @ 8:55 am

  12. Thanks so much for hosting, and excellent topic!

    http://www.bobpusateri.com/archive/2010/09/potty-chairs-and-duplicate-indexes/

    Comment by Bob Pusateri — September 14, 2010 @ 8:58 am

  13. here you go http://facility9.com/2010/09/14/t-sql-tuesday-indexes

    Comment by Jeremiah Peschka — September 14, 2010 @ 9:00 am

  14. [...] Michael J Swart asked me to take part in T-SQL Tuesday #10 – Indexes, I was incredibly flattered. [...]

    Pingback by T-SQL Tuesday – Indexes | Jeremiah Peschka — September 14, 2010 @ 9:05 am

  15. [...] blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for T-SQL Tuesday #10, with apologies for being too gosh-darn busy to write something [...]

    Pingback by SQL Awesomesauce » Blog Archive » Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10! — September 14, 2010 @ 10:27 am

  16. Here’s my first T-SQL Tuesday post.
    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    Comment by Gail Shaw — September 14, 2010 @ 10:35 am

  17. [...] I heard about the upcoming T-SQL Tuesday from the Database Whisperer himself and decided that I would take the time to participate in the discussion for the first time. [...]

    Pingback by Big Mac Index | SQLRockstar — September 14, 2010 @ 10:56 am

  18. Oh, I love this topic!!! So much I finally decided to write my first T-SQL Tuesday post: http://www.dianemcnurlan.com/2010/09/tsql-tuesday-worst-indexing-practices/

    Comment by Diane McNurlan — September 14, 2010 @ 11:06 am

  19. Trying to write more posts so here is my try for TSQL Tuesday.

    http://sqlaj.wordpress.com/2010/09/14/t-sql-tuesday-10-indexes-101/

    Comment by SQLAJ — September 14, 2010 @ 11:09 am

  20. [...] a comment Go to comments This post is for T-SQL Tuesday #10 hosted by Michael J Swart twitter | blog. [...]

    Pingback by T-SQL Tuesday #10 – Indexes 101 « SQL AJ — September 14, 2010 @ 11:29 am

  21. [...] Index on Indexing #TSQL2sDay September 14, 2010 Here we are with another T-SQL Tuesday and time for my entry into the fray.  This month we are talking about indexes.  This is great [...]

    Pingback by An Index on Indexing #TSQL2sDay | Strate SQL — September 14, 2010 @ 1:02 pm

  22. The theme for this month’s T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices for fill factors on indexes actually does to the structure of those indexes.

    http://adventuresinsql.com/2010/09/how-is-fill-factor-impacting-my-indexes/

    Comment by Dave Levy — September 14, 2010 @ 4:18 pm

  23. Thank you for hosting this month!

    http://jeremycarterblog.com/2010/09/tsql-tuesday-cut-your-index-bloat/

    -Jeremy

    Comment by Jeremy Carter — September 14, 2010 @ 5:55 pm

  24. [...] Tuesday #010: Partitioned Indexes and Data Types This month’s T-SQL Tuesday, “T-SQL Tuesday #010: What are your thoughts on Database Indexes?” is hosted by Michael J Swart (Blog/Twitter) aka the Database Whisperer.  The topic is: [...]

    Pingback by T-SQL Tuesday #010: Partitioned Indexes and Data Types « SQL Feather and Quill — September 14, 2010 @ 6:33 pm

  25. Based on your script, I’ve still got time! So here’s my submission. Thanks for hosting.

    http://www.sqlfeatherandquill.com/2010/09/14/t-sql-tuesday-010-partitioned-indexes-and-data-types/

    Comment by Andy Lohn — September 14, 2010 @ 6:35 pm

  26. To Be or Not To Be (a B-tree): http://www.sqlsoldier.com/wp/sqlserver/tobeornottobe_ab-tree

    Comment by Robert L Davis — September 14, 2010 @ 7:28 pm

  27. [...] Anyway, I don’t have any more time to spend on this post, gotta get my code ready in case I need to fill in tomorrow for someone during the 24 Hours of PASS, so I’ll just publish it and wish you all a Happy T-SQL Tuesday. [...]

    Pingback by SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V — September 14, 2010 @ 7:58 pm

  28. Great job everyone. I’ve got a good deal of reading ahead of me. I’ll repeat the same thing in a couple of days during the roundup but I wanted to thank each one of the bloggers here who participated for making this TSQL-Tuesday what it was.

    (And thanks to spammers who seem to have held off spamming while I turned off comment moderation)

    Comment by Michael J. Swart — September 14, 2010 @ 8:09 pm

  29. Thanks for hosting, Michael!

    Comment by Rob Farley — September 14, 2010 @ 8:40 pm

  30. I hope you’ll accept mine.
    http://jasonbrimhall.info/2010/09/14/tsql-tuesday-indexes-and-blobs/

    Comment by Jason Brimhall — September 14, 2010 @ 9:31 pm

  31. Hey i just see this site today
    really great and nice stuff…
    Thanx..

    Comment by learntsql — September 15, 2010 @ 1:29 am

  32. [...] Invitation to Participate in T-SQL Tuesday #10 – Indexes – Here’s my pick of this months T-SQL Tuesday posts: [...]

    Pingback by SQL Server Links and news the week 17/09/10 | John Sansom - SQL Server DBA in the UK — September 18, 2010 @ 6:28 am

  33. [...] your host for T-SQL Tuesday for the month of November. And an amazing 22 bloggers responded to that invitation. I want to thank each of the bloggers for the time they put into their contribution. We really had [...]

    Pingback by T-SQL Tuesday #10 Round up, An index of participants | Michael J. Swart — September 20, 2010 @ 8:19 am

  34. [...] (invitation, roundup)August, 2010: Beach Time (invitation, roundup)September, 2010: Indexes (invitation, roundup)October, 2010: Misconceptions in SQL Server (invitation, roundup)November, 2010: Why Are [...]

    Pingback by Adam Machanic : A Year of Tuesdays: T-SQL Tuesday Meta-Roundup — December 7, 2010 @ 1:44 pm

  35. [...] invitation is here, and time is running out to participate, but if you want to blog, you can do it today before this [...]

    Pingback by T-SQL Tuesday #10 – Indexes « Voice of the DBA — January 11, 2011 @ 6:51 pm

  36. [...] T-SQL Tuesday #010 – Indexes [...]

    Pingback by T-SQL Tuesday Topics « Voice of the DBA — January 21, 2011 @ 1:51 pm

  37. [...] T-SQL Tuesday #010 – Indexes [...]

    Pingback by T-SQL Tuesday Topics – Feb 2011 « Voice of the DBA — February 11, 2011 @ 11:30 am

  38. [...] T-SQL Tuesday #010 – Indexes [...]

    Pingback by T-SQL Tuesday #18 – My CTE « Voice of the DBA — May 10, 2011 @ 8:52 am

  39. [...] you were just too busy when Michael Swart invited everyone to write about indexes. Or maybe you weren’t quite happy with the CTE post you came up with when Bob Pusateri [...]

    Pingback by TSQL Tuesday #026 – Second Chances | Dave's SQL Blog — January 3, 2012 @ 9:11 am

  40. [...] to. Well, not really anything, but any of the 25 previos T-SQL Tuesday topics. I picked two topics: Indexes by Michael Swart and Misconceptions in SQL Server by Sankar [...]

    Pingback by Index Misconceptions [TSQL Tuesday #026 - Second Chances] | sqlity.net — January 10, 2012 @ 12:08 am

  41. [...] B+ tree structure, and how that is different from a standard B-Tree. Original T-SQL Tuesday 10 / [...]

    Pingback by T-SQL Tuesday #026 – The Wrap Up | Dave's SQL Blog — January 18, 2012 @ 9:59 am

  42. [...] T-SQL Tuesday #010 – Indexes [...]

    Pingback by T-SQL Tuesday Topics – Febuary 2012 « Voice of the DBA — February 7, 2012 @ 11:43 am

  43. [...] http://michaeljswart.com/2010/09/invitation-to-participate-in-t-sql-tuesday-10-indexes/ [...]

    Pingback by #Meme15 Meets #T-SQL Tuesday « Chris Shaw's Weblog — April 23, 2012 @ 10:43 am

  44. [...] T-SQL Tuesday #010 – Indexes [...]

    Pingback by T-SQL Tuesday Topics – December 2012 Update « Voice of the DBA — December 10, 2012 @ 4:39 pm

  45. [...] This months subject is “Indexes” (however I’m one of those annoying people who prefer to call them “Indices”), our gracious host is Michael J Swart (Blog|Twitter), if you’re quick you may still be able to participate: Invitation to Participate in T-SQL Tuesday #10 – Indexes [...]

    Pingback by T-SQL Tuesday #10: Unused Indexes (Indices) — July 31, 2013 @ 12:17 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress