Post reply

Indexes

  • October 5, 2011 at 8:46 pm

    #259913

    Comments posted to this topic are about the item Indexes

  • October 5, 2011 at 8:47 pm

    #1391058

    Nice straight forward question

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 6, 2011 at 12:50 am

    #1391079

    Thanks - straight forwards point today

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • October 6, 2011 at 12:58 am

    #1391081

    Nice question

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • October 6, 2011 at 1:05 am

    #1391082

    Nice question, thank you

    Iulian

  • October 6, 2011 at 1:36 am

    #1391089

    Nice question compared to yesterday!

  • October 6, 2011 at 2:55 am

    #1391104

    Could you imagine the I/O on a bulk insert to a table with 999 nonclustered indexes though?

    I think the DB engine would actually explode. 🙂

    ---

    Note to developers:
    CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
    So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

    Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
    My blog: http://uksqldba.blogspot.com
    Visit http://www.DerekColley.co.uk to find out more about me.

  • October 6, 2011 at 4:15 am

    #1391123

    Got it right--for SQL Server 2005 😉

    Thanks for a straightforward question.

    And you might find this link helpful as well.

    Regards,

    Michael

  • October 6, 2011 at 4:52 am

    #1391136

    Thanks, easy question.

    M&M

  • October 6, 2011 at 5:36 am

    #1391145

    This will help the swelling go down after yesterday's injuries. Thanks for the question!

    I didn't learn as much as I have with other QOTDs, but sometimes it's nice to see "You got it right!" first thing in the morning. Good way to start the day.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • October 6, 2011 at 5:49 am

    #1391150

    Needed an easier question after yesterday. Couldn't imagine ever needing 999 indexes on a single table though.

    http://brittcluff.blogspot.com/

  • October 6, 2011 at 5:52 am

    #1391151

    nice question!!!!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • October 6, 2011 at 7:16 am

    #1391189

    Good question, although I rather my ERP developer not know about this limit, it seems they are trying to get there.

  • October 6, 2011 at 7:49 am

    #1391197

    Britt Cluff (10/6/2011)

    Needed an easier question after yesterday. Couldn't imagine ever needing 999 indexes on a single table though.

    I agree. That seems like a crazy high number.

  • October 6, 2011 at 8:31 am

    #1391227

    nice question... tks.

    I'm sure someone out there is quite proud of being able to make full use of this! 😀 😛

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy