• Comments posted to this topic are about the item TempDB

  • Very good question. I never knew that there is this restriction in tempdb. Learnt something today. Thanks.


  • Ah, a good precise question that doesn't require me to parse a T-SQL batch in my head. Nice.

  • Nice straight forward question. Thanks.

    Jason...AKA CirqueDeSQLeil
    I have given a name to my pain...MCM SQL Server, MVP
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question. Thanks.

  • Lovely!

  • Thank you - good to review the basics.

  • Thanks for the QOTD.

  • Nice question.

  • Good question - thanks

    -------------------------------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

  • doh!

    must. read. the. question. properly.


  • Thanks for the question.

    But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"

    The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx) explains us

    tempdb supports only one data filegroup and one log filegroup.

  • very good question!!!!

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

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Nice question. Just the right amount of difficulty for my morning starter. Thanks.

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

  • SQL Kiwi (9/28/2011)

    Ah, a good precise question that doesn't require me to parse a T-SQL batch in my head. Nice.


    Agree. Easy and straightforward question that shows an important limitation of SQL Server.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst

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

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