Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server 2008 (SSQA.net)

Trusted, Productive and Intelligent enterprise data platform.

Browse by Tags

All Tags » sql server » data capture   (RSS)
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 Read More...
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 Read More...
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 Read More...
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. Read More...
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 Read More...
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 Read More...