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 objects. These objects can be point locations...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
03-20-2008
Filed under: sql server, indexes, 2008, labs, data capture, spatial, data type, links, new features, geometry, geography
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 version which is usage of VARDECIMAL with having...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on
12-03-2007
Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression
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 reduce the storage requirements for your data....
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 datetime DATETIME2 - like DATETIME, but...
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 to the database objects with an easy relational...
Cross-post from VirtualEarth live spaces that has featured handling Virtual Earth data with upcoming SQL Server 2008....( read more )