Browse by Tags

• Partitioning by GUID

  Recently I had to use GUID (Global Unique Identifier) as primary key in order to ensure cross-server uniqueness. In many cases surrogate key (some sort of concatenation between server id and intra-server identity) would give a better performance but in Read More... Posted Wednesday, June 11, 2008 4:40 AM by Michael Zilberstein | 8 Comments Filed under: Misc, Scripts

• 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 | 5 Comments Filed under: Misc, Scripts