Post reply

TempDB

  • September 28, 2011 at 9:39 pm

    #243803

    Comments posted to this topic are about the item TempDB

  • September 28, 2011 at 9:40 pm

    #1388172

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

    M&M

  • September 28, 2011 at 11:23 pm

    #1388180

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

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • September 28, 2011 at 11:35 pm

    #1388184

    Nice straight forward question. Thanks.

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

  • September 28, 2011 at 11:51 pm

    #1388189

    Nice question. Thanks.

  • September 29, 2011 at 12:39 am

    #1388192

    Lovely!

  • September 29, 2011 at 12:47 am

    #1388196

    Thank you - good to review the basics.

  • September 29, 2011 at 1:47 am

    #1388209

    Thanks for the QOTD.

  • September 29, 2011 at 2:08 am

    #1388214

    Nice question.

  • September 29, 2011 at 2:15 am

    #1388217

    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

  • September 29, 2011 at 3:19 am

    #1388243

    doh!

    must. read. the. question. properly.

    ---------------------------------------------------------------------

  • September 29, 2011 at 5:18 am

    #1388281

    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.

  • September 29, 2011 at 5:47 am

    #1388294

    very good 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!

  • September 29, 2011 at 5:47 am

    #1388295

    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

  • September 29, 2011 at 5:48 am

    #1388298

    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.

    :laugh:

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

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

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

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