It also introduced new & improved tools under Master Data Services and SQL Server Data Quality Services for data integration and management that deliver consistent, credible data at the right time. Basically SQl server 2012 is released with the punch line "any data, any size, anywhere."
Always on Availability groups "Always on Availabitlity Groups" can contain multiple databases and all of them can be automatically falled as a unit. This is useful in case of large applications where there could be several databases which require distinct mirroring sessions
Column Store IndexesData is grouped and stored in a flat, compressed column index, greatly reducing I/O and memory utiization on large queries.
Linux PlatformODBC Driver is introduced for SQl Server to run on Linux platform as well.
Big Data SupportIt has introduced new storage options and tools for big data analysis
xVelocity With the in-memory technologies, the performance of data-warehouse and analytics feature may increase upto 100 times.
Query Performance The new spatial indexing feature can process many geospatial queries faster than in predecessors.
Contained DatabaseThis reduces the effort required to migrate a database to a new instances as it reduces the work involved in reproducing and validating the dependcies.
Thanks for this post....
if u know more about SQL Server 2012, pl post in detail.This is useful for 2012 user's
thanks for this post....
if u know more about SQL Server 2012, pl post in detail...
this is useful for 2012 user's