SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


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, 2,107 reads

Posted in LivingForSqlServer on 15 March 2012