Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

Archives: March 2012

Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.

some key books/links on this topic are given in reference section for further read.

Some properties of Tempdb Properties


1. Tempdb is recreated everytime SQL Server starts.
2. Simple recovery mode. No Full/Log… Read more

0 comments, 1,238 reads

Posted in LivingForSqlServer on 15 March 2012