March 2008 - Posts

• How do we know that Microsoft conducts performance tests?

  Funny comment in undocumented system stored procedure - and undocumented syntax of DBCC SHOW_STATISTICS. Read More... Posted Monday, March 24, 2008 11:31 AM by Michael Zilberstein | 0 Comments

• How to find real database creation date

  Restoring database from backup or moving it to another server resets all the creation_date fields (in sys.databases , msdb..backupset etc'). So is there any way to find out the original creation date? Looks like there is one. It is stored in the boot Read More... Posted Tuesday, March 18, 2008 9:56 AM by Michael Zilberstein | 4 Comments Filed under: Internals

• Have your database ever been backed up?

  Full backup should be taken before transaction log can be backed up for the first time. So how to check whether full backup exists for particular database? It comes out that finding an answer is not that simple. Read More... Posted Saturday, March 01, 2008 5:15 PM by Michael Zilberstein | 6 Comments Filed under: Misc, Scripts

• 1001st way to find SQL Server service start time

  Just another way to find SQL Server service start time is to look ar creation time of tempdb database. Read More... Posted Saturday, March 01, 2008 4:43 PM by Michael Zilberstein | 0 Comments Filed under: Misc