Welcome to

SqlServer-QA.net

Sign in | Join | Help

Browse by Tags

All Tags » data capture   (RSS)
Thursday, March 20, 2008 1:32 AM

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

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
Posted by SQL Master | 3 Comments
Monday, December 03, 2007 6:54 AM

SQL Server 2008 Data Compression, what it is - how does it work?

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005
Posted by SQL Master | 4 Comments
Wednesday, October 03, 2007 7:42 AM

New feature in SQL Server 2008 - compression how it works?

Since the release of SQL Server 2008 (last 2 CTPs) users are anxiously awaiting for data compression feature, so how it is handled in this version and what it does, is it a good thing? Data compression enables you to store your data more effectively and
Posted by SQL Master | 2 Comments
Tuesday, July 10, 2007 1:02 AM

SQL Server 2008 'Katmai' to feature Spatial Support

Cross-post from VirtualEarth live spaces that has featured handling Virtual Earth data with upcoming SQL Server 2008.
Posted by SQL Master | 1 Comments
Monday, July 09, 2007 7:08 AM

New and old blend of data-types in SQL Server 2008

By now you might have seen on blogs and documentation that there are new datatypes introduced in SQL Server 2008, they are: DATE - ANSI-compliant date data type TIME - ANSI-compliant time data type with variable precision DATETIMEOFFSET - timezone aware/preserved
Posted by SQL Master | 2 Comments
Wednesday, June 20, 2007 2:34 PM

SQL Server 2008 - Change Data Capture: new feature

Let us talk briefly about the new feature that is introduced within SQL Server 2008 aka Katmai. Change Data Capture (CDC) is (similar to triggers: INSERTED & DELETED tables) the 'new boy in SQL Server town' that records the DML activities applied
Posted by SQL Master | 2 Comments