Rich Application Development

Rich Development Capabilities

Expectations for how applications deliver and use data are greater than ever. Meet user demands with powerful data development capabilities in Microsoft SQL Server 2008 R2, including support for more precise date and time information, unstructured files like documents and images, and comprehensive spatial support that enables developers to create compelling location-aware applications for businesses and consumers.

Key Capabilities
  • Support more types of data, such as date and time, unstructured files, and hierarchical models.
  • Store, manage, and find data more efficiently with database optimization features.
  • Empower people to make better decisions with spatial visualizations.
  • Consume and manipulate data from location-aware applications and services.

Technical Highlights

Take advantage of enhanced data type support in SQL Server 2008 R2 to manage more types of data, including precise date and time, external documents and files, and hierarchical data.

Store more precise date and time information
  • Use data types for date and time that are compatible with the ANSI SQL standard.

  • Store larger fractional seconds and year ranges.

Manage unstructured data more efficiently
  • Store unstructured data, such as documents, images, and videos, on the file system in SQL Server 2008 R2 with the new FILESTREAM data type.

  • Use Transact-SQL statements to insert, update, query, search, and back up FILESTREAM data.

  • Maintain transactional consistency between unstructured data and corresponding structured data while using rich streaming APIs and performance of the file system.

  • Move large video files and other unstructured data to low-cost commodity storage solutions.

Model hierarchical data
  • Easily implement solutions that use hierarchical data, such as manufacturing bill-of-materials systems, organizational charts, or systems that recognize levels of geographic territories.

  • Write less complex queries for hierarchical data with the HIERARCHY ID data type.

  • Reduce the amount of data physically stored on disk.

Site Map

  • Find Us
  • Facebook Twitter YouTube
  • MTNL/BSNL Toll free number: 1800 11 11 00
    Bharti Toll %free number: 1800 102 1100
    Toll number: +91 80 40103000