This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
TechNet
  • Products
    Products
    • Windows
    • Windows Server
    • System Center
    • Microsoft Edge
     
    • Office
    • Office 365
    • Exchange Server
     
    • SQL Server
    • SharePoint Products
    • Skype for Business
    • See all products »
  • IT Resources
    Resources
    • Channel 9 Video
    • Evaluation Center
    • Learning Resources
    • Microsoft Tech Companion App
    • Microsoft Technical Communities
    • Microsoft Virtual Academy
    • Script Center
    • Server and Tools Blogs
    • TechNet Blogs
     
    • TechNet Flash Newsletter
    • TechNet Gallery
    • TechNet Library
    • TechNet Magazine
    • TechNet Wiki
    • Windows Sysinternals
    • Virtual Labs
    Solutions
    • Networking
    • Cloud and Datacenter
    • Security
    • Virtualization
  • Downloads
    Updates
    • Service Packs
    • Security Bulletins
    • Windows Update
    Trials
    • Windows Server 2016
    • System Center 2016
    • Windows 10 Enterprise
    • SQL Server 2016
    • See all trials »
    Related Sites
    • Microsoft Download Center
    • Microsoft Evaluation Center
    • Drivers
    • Windows Sysinternals
    • TechNet Gallery
  • Training
    Training
    • Expert-led, virtual classes
    • Training Catalog
    • Class Locator
    • Microsoft Virtual Academy
    • Free Windows Server 2012 courses
    • Free Windows 8 courses
    • SQL Server training
    • Microsoft Official Courses On-Demand
    Certifications
    • Certification overview
    • Special offers
    • MCSE Cloud Platform and Infrastructure
    • MCSE: Mobility
    • MCSE: Data Management and Analytics
    • MCSE Productivity
    Other resources
    • Microsoft Events
    • Exam Replay
    • Born To Learn blog
    • Find technical communities in your area
    • Azure training
    • Official Practice Tests
  • Support
    Support options
    • For business
    • For developers
    • For IT professionals
    • For technical support
    • Support offerings
    More support
    • Microsoft Premier Online
    • TechNet Forums
    • MSDN Forums
    • Security Bulletins & Advisories
    Not an IT pro?
    • Microsoft Customer Support
    • Microsoft Community Forums
United States (English)
Sign in
Microsoft TechNet
Home Library Wiki Learn Gallery Downloads Support Forums Blogs
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Books Online for SQL Server 2014 Database Engine Database Engine Features and Tasks
Database Engine Features and Tasks Database Features
Database Features
Database Features
Database Engine Instances (SQL Server)
Database Features
Databases (Database Engine)
Tables
In-Memory OLTP (In-Memory Optimization)
Indexes (Database Engine)
Partitioned Tables and Indexes
Views
Stored Procedures
Search
User-Defined Functions
Statistics
Plan Guides
Cursors
Sequence Numbers
DDL Triggers
DML Triggers
Synonyms (Database Engine)
XML Data
Spatial Data
Binary Large Object (Blob) Data
Hierarchical Data
Data-tier Applications
The Transaction Log (SQL Server)
Database Checkpoints
Back Up and Restore of SQL Server Databases
Bulk Import and Export of Data
Data Compression
OLE Automation Objects in Transact-SQL
Event Notifications
Monitor and Tune for Performance
Database Engine Cross-Instance Features
High Availability Solutions
Security Center for SQL Server Database Engine and Azure SQL Database
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.
This documentation is archived and is not being maintained.

Database Features

SQL Server 2014
Other Versions
  • SQL Server 2016 and later
  • SQL Server 2012
 

This section contains the features and tasks associated with databases, database objects, data types, and the mechanisms used to work with or manage data.

In This Section

DatabasesCursorsBack Up and Restore of SQL Server Databases
TablesSequence NumbersBulk Import and Export of Data (SQL Server)
In-Memory OLTP (In-Memory Optimization)DDL TriggersData Compression
IndexesDML TriggersOLE Automation Objects in Transact-SQL
Partitioned Tables and IndexesSynonyms (Database Engine)Event Notifications
ViewsXML Data (SQL Server)Monitor and Tune for Performance
Stored Procedures (Database Engine)Spatial Data (SQL Server)
Search (SQL Server)Binary Large Object (Blob) Data (SQL Server)
User-Defined FunctionsData-tier Applications
StatisticsThe Transaction Log (SQL Server)
Plan GuidesDatabase Checkpoints (SQL Server)
Show:
Print Export (0)
Print Share
IN THIS ARTICLE
    Is this page helpful?
    Additional feedback?
    1500 characters remaining
    Thank you! We appreciate your feedback.
    Manage Your Profile
    |
    Site Feedback Site Feedback
    Site Feedback
    x
    Tell us about your experience...
    Did the page load quickly?
    Yes No
    Do you like the page design?
    Yes No
    Tell us more
    • Flash Newsletter
    • |
    • Contact Us
    • |
    • Privacy Statement
    • |
    • Terms of Use
    • |
    • Trademarks
    • |
    © 2018 Microsoft
    © 2018 Microsoft