SQL 2008 T-SQL

Partitioning in SQL Server 2008

This article discusses about 'Partitioning'. In this detailed article, a particular emphasis is placed on the implementation of Partitioning in SQL Server.

Dynamic SQL Merge

This article by new author Glen Schwickerath uses dynamic SQL and SQL Server 2008's MERGE statement to create a useful stored procedure tool for synchronizing tables.

SQL 2008 MERGE using Dynamic SQL over a Linked Server

Stored Procedure to build a MERGE statement in SQL 2008 using dynamic SQL.

Understanding the MERGE DML Statement in SQL Server 2008

This article about MERGE DML Statement in SQL SERVER 2008 and how to implements it and several examples

RE: Wine Database

Getting drunk impresses the ladies ?!?! Certainly never seen that pick-up line before - a guy falling senseless at my feet...ahh - maybe that's what it is - you don't see that he's drunk - only knocked out by your beauty...<:-)

RE: DTS error handling when server down

I have lots of dts packages like this, I use an 'Execute SQL Task' to do a select on the source table (using a single key) and only execute the truncate if it is successful.If you want to fully protect against any data loss (ie lost connection during data transformation) then Jonathan's solution of using […]

RE: trigger on view

Using a stored procedure doesn't stop people from having access to the table as well though. Although, in SQL2005 you can tell the stored procedure to execute to impersonate an appropriately privileged user, so that you can stop people from accessing the table without going through the stored proc. But I would actually use a […]

RE: Database Diagram window opens empty

check for rows in dtproperties table select * from dtproperties if there are no rows in dtproperties table, then you cannot open the diagram

RE: Question of the Day for 07 Sep 2004

The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column will be filled with 'N' automatically as such.Regards