responsiblities for TempDB

• mohan.bndr

  SSCrazy

  Points: 2360

  More actions

  January 21, 2014 at 12:45 am

  #150014

  Hi All,

  Can you please describe the responsibilites of TempDB in 2005/2008....

  Thanks in advance.

• BrainDonor

  SSCoach

  Points: 19259

  More actions

  January 21, 2014 at 1:34 am

  #1681761

  This Technet article is a good starting point - http://technet.microsoft.com/en-us/library/ms190768(v=sql.90).aspx

  Steve Hall
  Linkedin
  Blog Site

• Sreekanth B

  SSCertifiable

  Points: 6145

  More actions

  January 22, 2014 at 12:12 pm

  #1682548

  Brent has an amazing 20 mins video...on this topic.

  http://www.brentozar.com/archive/2013/12/video-the-secrets-of-tempdb/

• Jeff Moden

  SSC Guru

  Points: 1004582

  More actions

  January 22, 2014 at 4:59 pm

  #1682624

  mohan.bndr (1/21/2014)

  ---

  Can you please describe the responsibilites of TempDB in 2005/2008....

  You really should do a Web Search for things like that. Seriously.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)