I want some Moore

SQL Server: Best way to Update row if exists, Insert if not

This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard the term yet) is locking.

More here.

posted @ Monday, July 30, 2007 8:17 PM | Feedback (18)

SQL Server 2005: How to successfully shoot yourself in the foot with Service Broker

posted @ Wednesday, July 25, 2007 8:46 PM | Feedback (1)

A few maximum limitations for SQL Server 2005

Every now and then i see a question pop up that asks what is the max this or that in sql server?

More here.

posted @ Tuesday, July 24, 2007 5:13 PM | Feedback (2)

Become a Better Developer in 6 months. How?

posted @ Wednesday, July 18, 2007 5:51 PM | Feedback (5)

Centralized Asynchronous Auditing with Service Broker

posted @ Monday, July 16, 2007 5:36 PM | Feedback (1)

SQL Server 2005: Hypothetical index - a what?!?!

posted @ Monday, July 16, 2007 1:46 PM | Feedback (0)

Behaviour and Breaking changes from SQL Server 2000 to 2005

posted @ Tuesday, July 10, 2007 7:21 PM | Feedback (0)

Ways to revert a database to pre-Test state after Unit testing

Tests are a pretty much a must in today's world of programming. There's even a whole Test Driven Development methodology that deals with this.

There comes a time when we have to test how our app interacts with the database.

More here

posted @ Friday, July 06, 2007 7:00 PM | Feedback (11)

Enabling Database Mail on SQL Server Express

posted @ Sunday, July 01, 2007 9:47 PM | Feedback (3)