Browse by Tags

• Scripts

• Name resolution in SQL Server

  This post is inspired by recent post by Mladen Prajdić. Mladen had found out (as many did before him - hanging around in blogs and communities, I see questions about this issue from time to time) that name resolution works for temporary tables differs Read More... Posted Thursday, August 28, 2008 2:57 PM by Michael Zilberstein | 0 Comments Filed under: Misc

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

• Scalability features I would like to have in SQL Server

  1. Active-Active cluster. Like RAC in Oracle. Maximum that commodity server can provide by now is 4 quad-core CPU machine. If application requires more, we can split the database (which is not always possible; and even when it is - such a solution often Read More... Posted Wednesday, April 23, 2008 8:03 PM by Michael Zilberstein | 6 Comments Filed under: Misc

• 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