TempDB

Question

Post reply

TempDB

srawant

SSCommitted

Points: 1829
More actions
September 28, 2011 at 9:39 pm

#243803

Comments posted to this topic are about the item TempDB

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

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

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

M&M

Paul White SSC Guru Points: 150468 More actions · Answer 2

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

Paul White
All articles available on SQL.kiwi
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

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

CoolCodeShare SSCrazy Points: 2584 More actions · Answer 4

CoolCodeShare

SSCrazy

Points: 2584

September 28, 2011 at 11:51 pm

#1388189

Nice question. Thanks.

SaintGr8 SSC Veteran Points: 259 More actions · Answer 5

SaintGr8

SSC Veteran

Points: 259

September 29, 2011 at 12:39 am

#1388192

Lovely!

matt.bowler SSCrazy Points: 2677 More actions · Answer 6

matt.bowler

SSCrazy

Points: 2677

September 29, 2011 at 12:47 am

#1388196

Thank you - good to review the basics.

paul s-306273 SSChampion Points: 10730 More actions · Answer 7

paul s-306273

SSChampion

Points: 10730

September 29, 2011 at 1:47 am

#1388209

Thanks for the QOTD.

Alexandr Kipkalo SSC Journeyman Points: 82 More actions · Answer 8

Alexandr Kipkalo

SSC Journeyman

Points: 82

September 29, 2011 at 2:08 am

#1388214

Nice question.

Stuart Davies SSCoach Points: 19505 More actions · Answer 9

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

george sibbald SSC Guru Points: 104210 More actions · Answer 10

doh!

must. read. the. question. properly.

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

v_kozachuk SSCrazy Points: 2070 More actions · Answer 11

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.

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 12

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!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 13

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

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 14

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,

Andre Guerreiro Neto

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