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