Browse by Tags

SQL Server 2005 - How to compare content of tables without using third party tools?

Published 4 July 8 3:36 AM | SSQA.net

You may be aware about using Third party tools to compare the data between 2 tables. Using SQL Server 2005 you need not entirely dependant on such requirement, TABLEDIFF utility is the new addition to the SQL Server. This utility enables you to compare...

Filed under: sql server, data, data type, tablediff, utility

FIX: Error message when you use the BULK INSERT statement to import data of the timestamp data type in SQL Server 2005: "An invalid datetime value was encountered"

Published 7 May 8 3:28 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you use the BULK...

Filed under: sql server, error, kba, bulk insert, data type, timestamp

SQL Server 2008 Spatial data - geography & geometry, all in one

Published 20 March 8 3:32 AM | SSQA.net

Geography & Geometry has much significance in day to day life, within that as a data now you can manage within your Database using SQL Server 2008 new data type - spatial, this represents information about the physical location and shape of geometric...

Filed under: sql server, indexes, 2008, labs, data capture, spatial, data type, links, new features, geometry, geography

FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged"

Published 5 October 7 7:32 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, xml, collation, column, data type, damaged

Filestream datatype - what it is?

Published 1 October 7 3:31 AM | SSQA.net

My question is have you looked into the CTP4 Books online for SQL 2008? This is new to SQL Server arena, the FileStream data type which allows large binary data to be stored in the file system and yet remain an integral part of the database with transactional...

Filed under: sql server, performance, microsoft, 2008, ctp, new, data type, filestream

Failed to claim unused space with SP_SPACEUSED?

Published 31 August 7 4:9 AM | SSQA.net

Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name...

Filed under: sql server, database, dbcc, dba, space, table, transact sql, data type, delete