September 2006 - Posts

• The prime number challenge – great waste of time!

  No sane person would even consider using SQL Server to construct a list of prime numbers. So just to prove that I’m not sane (as if there could be any doubt!), this post will be about finding prime numbers. First a bit of history. Ward Pond wrote about Read More... Posted Saturday, September 23, 2006 10:54 PM by Hugo Kornelis | 9 Comments Filed under: T-SQL, Tricks, Prime number challenge, Performance

• Snapshot isolation: A threat for integrity? (Part 4)

  In the previous parts of this series, I have shown how SQL Server prevents violations of foreign key constraints by silently disabling snapshot isolation . I have also demonstrated how you can use the same technique inside your trigger code , to keep Read More... Posted Friday, September 15, 2006 8:58 PM by Hugo Kornelis | 5 Comments Filed under: Isolation, SQL Server 2005

• Fun with ambiguous table names

  Earlier today, I realised that Microsoft has forgotten to include some keywords in the list of reserved keywords. Now, a wise developer will still take care to omit those names when naming tables – but a bored developer can have loads of fun exploring Read More... Posted Saturday, September 02, 2006 9:24 PM by Hugo Kornelis | 1 Comments Filed under: T-SQL, Surprise