Script SQL Server 2005 and 2008 Diagrams

by Al Beecy March 10, 2009
A script that will script SQL Server 2005 and 2008 diagrams so that you can copy them to a new DB. [More]

Tags: ,

SQL Server | Tools | Downloads

Find and List Duplicate Rows and Values in SQL Server

by Al Beecy March 10, 2009
Two examples. The first shows how to find duplicate values. The second shows how to list all rows containing duplicate values. [More]

Tags: , , ,

SQL Server | SQL Server

NTEXT vs NVARCHAR(MAX) in SQL 2005 and 2008

by Al Beecy February 17, 2009
Use NVARCHAR(MAX) instead of NTEXT. [More]

Tags: ,

SQL Server

Grouping SQL Server Data by Time with a Temp Table

by Al Beecy January 22, 2009
How to group SQL Server data by date/time using a temporary table. [More]

Tags: ,

SQL Server

Grouping SQL Server Data by Time with DATEDIFF and DATEADD

by Al Beecy January 22, 2009
How to group SQL Server data by date/time using the DATEDIFF and/or DATEADD functions. [More]

Tags: ,

SQL Server

Powered by BlogEngine.NET1.5.0.7 | Theme by Mads Kristensen