I want some Moore

SQL Server 2005: An error or intended behavior with Database Compatibility?

posted @ Thursday, August 30, 2007 2:01 PM | Feedback (0)

.Net Windows Forms ListView ColumnHeader width tip. Set it to -1 or -2.

posted @ Wednesday, August 29, 2007 7:25 PM | Feedback (6)

Exchange: Accept and Cancel Meeting Request with WebDav

posted @ Wednesday, August 22, 2007 6:27 PM | Feedback (3)

Service Broker goodies: Cross Server Many to One (One to Many) scenario and How to troubleshoot it

posted @ Tuesday, August 21, 2007 3:37 PM | Feedback (0)

Tired and Strained eyes? You're looking at the wrong part of your computer monitor!

posted @ Sunday, August 19, 2007 11:20 PM | Feedback (10)

SQL Server: How to modify data in any table in a resultset made up of joins

Recently i'm seeing a lot of questions about how to modify data in the tables which are part of the multi-join select statement. And i keep wondering how can this be so hard to remember. The methodology is quite simple.

More here.

posted @ Sunday, August 19, 2007 1:26 AM | Feedback (0)

SQL Server: How to run a stored procedure at SQL Server start-up

posted @ Tuesday, August 14, 2007 4:34 PM | Feedback (4)

SQL Server 2005: TableDiff.exe GUI

posted @ Friday, August 10, 2007 11:58 AM | Feedback (34)

SQL Server 2008: Locking with MERGE statement compared to Update/Insert in SQL Server 2005

In a previous post I've shown what locks are held when doing "update if exists, insert if not" problem in 2 different ways. Of course i had to see how MERGE statement (new in SQL Server 2008) behaves in this matter.

More here.

posted @ Friday, August 03, 2007 9:30 PM | Feedback (1)

SQL Server: Automated database object recompiling after cleaning plan cache with FMTONLY

posted @ Thursday, August 02, 2007 5:21 PM | Feedback (2)