THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Scripts » Misc   (RSS)
Sorry, but there are no more tags available to filter with.
  • 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 my case due to application requirements surrogate key wasn't an option. Next step is ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on June 10, 2008
  • Have your database ever been backed up?

    Recently I've been asked by one of my clients to write a simple script that would find out whether particular database had ever been backed up (full backup). The reason for a requirement was semi-automatic application which would enable end users to manage backup activity including manually backup transaction log - not via Management Studio but ...
    Posted to Michael Zilberstein (Weblog) by mz1313 on March 1, 2008
Privacy Statement