September 28, 2011 at 9:40 pm
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
Ah, a good precise question that doesn't require me to parse a T-SQL batch in my head. Nice.
September 28, 2011 at 11:35 pm
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
Nice question. Thanks.
September 29, 2011 at 12:39 am
Lovely!
September 29, 2011 at 12:47 am
Thank you - good to review the basics.
September 29, 2011 at 1:47 am
Thanks for the QOTD.
September 29, 2011 at 2:08 am
Nice question.
September 29, 2011 at 2:15 am
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
doh!
must. read. the. question. properly.
---------------------------------------------------------------------
September 29, 2011 at 5:18 am
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
very good question!!!!
September 29, 2011 at 5:48 am
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 31 total)
You must be logged in to reply to this topic. Login to reply
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