May 2007 - Posts

• Sorting and case sensitive collations

  This is an addition to my book, on page 255, to the end of the section on collation (before the statement that I won't delve any deeper into collations, of course :)), I want to add the following bit of information about collations and how they affect Read More... Posted Sunday, May 20, 2007 6:16 PM by drsql | 3 Comments

• Using application locks to implement a critical section in T-SQL code

  This is being added to the addendum (located here) for my "Pro SQL Server 2005 Database Design and Optimization" book and would have appeared in the pessimistic locking section on page 478 in Chapter 9: Coding for Integrity and Concurrency; Pessimistic Read More... Posted Monday, May 07, 2007 11:43 PM by drsql | 2 Comments