August 2007 - Posts

• SQL Server Data Types Test Tables

  These tables can be used for testing various data types of SQL Server. You can extend as needed. SET NUMERIC_ROUNDABORT OFF ; SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,QUOTED_IDENTIFIER, ANSI_NULLS ON ; GO -- Create XML Schema Read More... Posted Saturday, August 25, 2007 10:41 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Script

• Column Information View for SQL Server

  Here is a view that contains column information. This is useful if you need to create a DDL statement for a table. CREATE VIEW dbo.vColumnInfo AS SELECT tbl.name AS [Table_Name], SCHEMA_NAME(tbl.schema_id) AS [Table_Schema], CAST (ISNULL(cik.index_column_id Read More... Posted Friday, August 24, 2007 11:24 PM by Patrick Gallucci | 4 Comments Filed under: sql server 2005, SQL Script

• Released - Cumulative update package 3 for SQL Server 2005 Service Pack 2

  Here is the link. http://support.microsoft.com/default.aspx/kb/939537 Here are the fixes in this release. SQL bug number KB article number Description 50001581 938243 (http://support.microsoft.com/kb/938243/) FIX: Error message when you run a full-text Read More... Posted Wednesday, August 22, 2007 4:44 PM by Patrick Gallucci | 1 Comments Filed under: sql server 2005

• Generate BCP, Bulk Insert code with TSQL

  This script will generate tsql code to bcp and bulk load data for all tables in a given DB. SET NOCOUNT ON GO DECLARE @ path nvarchar(2000), @batchsize nvarchar(40), @format nvarchar(40), @serverinstance nvarchar(200), @security nvarchar(800) SET @ path Read More... Posted Friday, August 10, 2007 10:48 PM by Patrick Gallucci | 5 Comments Filed under: sql server 2005, SQL Script

• That about sums up my day.

  I was got to Hoboken, no path trains, so I waited for a bus. That got me to downtown, so I waited for another bus, but then the riots started, so I started walking....and walking and walking...took me 7 hours to get to our office, that on a normal day Read More... Posted Wednesday, August 08, 2007 4:09 PM by Patrick Gallucci | 1 Comments Filed under: general

• CA Erwin and Microsoft's Visual Studio Team Edition for Database Professionals

  This about sums it up! The integration of CA's ERwin® Data Modeler with Microsoft's Visual Studio Team Edition for Database Professionals brings together an industry-leading heterogeneous database design product with a focused MS SQL Server development Read More... Posted Monday, August 06, 2007 11:07 AM by Patrick Gallucci | 0 Comments Filed under: sql server 2005, Erwin

• SQL Server Function to Return DateName

  This function will return the date name for a given date time. 1: USE [DW_SharedDimensions]; 2: GO 3: IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N '[util].[uf_GetDateName]' ) AND type in (N 'FN' , N 'IF' , N 'TF' , N 'FS' , N 'FT' Read More... Posted Wednesday, August 01, 2007 9:21 AM by Patrick Gallucci | 1 Comments Filed under: sql server 2005, SQL Function