Browse by Tags

• Database Administration
• Internals
• Miscellaneous
• SQL Server 2008

• Does tempdb Get Recreated From model at Startup?

  In my last post Does the tempdb Log file get Zero Initialized at Startup? I questioned whether or not tempdb is actually created from the model database or not at startup.  There is actually an easy way to prove that this statement, at least internally Read More... Posted Friday, May 14, 2010 7:32 AM by Jonathan Kehayias | 3 Comments Filed under: Database Administration, Did You Know, Internals

• Does the tempdb Log file get Zero Initialized at Startup?

  While working on a problem today I happened to think about what the impact to startup might be for a really large tempdb transaction log file.  Its fairly common knowledge that data files in SQL Server 2005+ on Windows Server 2003+ can be instant Read More... Posted Thursday, May 13, 2010 9:13 PM by Jonathan Kehayias | 9 Comments Filed under: Database Administration, Did You Know, Internals, Miscellaneous

• SQL Server Enterprise Edition and Windows XP, Windows Vista and Windows 7

  I’ve seen this a couple of times now online so it’s worth blogging about.  The Enterprise Edition of SQL Server is not supported on client OS's like Vista, XP, or Windows 7. Developer Edition is supported on the client OS's and allow you to develop Read More... Posted Thursday, January 28, 2010 8:00 AM by Jonathan Kehayias | 4 Comments Filed under: Did You Know, SQL Server 2008

• DYK: Restoring a Database Retains Index Fragmentation

  I am not sure where the “myth” that restoring a database removes the index fragmentation, or that restoring a database causes a database to become fragmented came from recently, but twice in the last few days I have seen questions asked about the impact Read More... Posted Wednesday, January 27, 2010 9:43 PM by Jonathan Kehayias | 9 Comments Filed under: Database Administration, Did You Know

• Did you Know: There’s more to using Search Engines than just words?

  Ever feel like the guy in the Bing Search Overload commercials?  You are not alone.  It’s happened a couple of times recently that someone has been looking for something online and couldn’t find what they were looking for and in a few quick Read More... Posted Monday, September 14, 2009 11:32 PM by Jonathan Kehayias | 0 Comments Filed under: Did You Know, Miscellaneous

• DYK: Maintenance Plans have Owners

  I never knew this until I read a forums post today, but Maintenance Plans have owners in SQL Server.  Beyond that, there is no way to change who the owner of a Maintenance Plan is in SQL Server Management Studio.  Generally speaking when a DBA Read More... Posted Monday, May 04, 2009 2:59 PM by Jonathan Kehayias | 2 Comments Filed under: Did You Know