|
Sr. No.
|
Sql server 2008 R2
|
Sql server 2012
|
|
1
|
Exceptions handle using TRY….CATCH
|
Unique Exceptions handling with
THROW
|
|
2
|
High Availability features as Log
Shipping, Replication, Mirroring & Clustering
|
New Feature ALWAYS ON introduced
with addition of 2008 features.
|
|
3
|
Web Development and Business
Intelligence Enhanced with business intelligence features. Excel PowerPivot
by adding more drill and KPI through.
|
In Addition with SQL server 2008,
Web Development and Business Intelligence Enhanced with business intelligence
features and Excel PowerPivot by adding more drill and KPI’s.
|
|
4
|
Could not supported for Windows
Server Core Support.
|
Supported for Windows Server Core
Support
|
|
5
|
Columnstore Indexes not supported.
|
New Columnstore Indexes feature
that is completely unique to SQL Server. They are special type of read-only
index designed to be use with Data Warehouse queries. Basically, data is
grouped and stored in a flat, compressed column index, greatly reducing I/O
and memory utilization on large queries.
|
|
6
|
PowerShell Supported
|
Enhanced PowerShell Supported
|
|
7
|
Distributed replay features not
available.
|
Distributed replay allows you to
capture a workload on a production server, and replay it on another machine.
This way changes in underlying schemas, support packs, or hardware changes
can be tested under production conditions.
|
|
8
|
PowerView not available in BI
features
|
PowerView is a fairly powerful self-service BI toolkit that allows
users to create mash ups of BI reports from all over the Enterprise.
|
|
9
|
EXECUTE … with RECOMPLIE feature
|
Enhanced EXECUTE with many option
like WITH RESULT SET….
|
|
10
|
Maximum numbers of concurrent
connections to SQL Server 2008 is 32767
|
SQL server 2012 has unlimited
concurrent connections.
|
|
11
|
The SQL Server 2008 uses 27 bit
bit precision for spatial calculations.
|
The SQL Server 2012 uses 48 bit
precision for spatial calculations
|
|
12
|
TRY_CONVERT() and FORMAT()
functions are not available in SQL Server 2008
|
TRY_CONVERT() and FORMAT()
functions are newly included in SQL Server 2012
|
|
13
|
ORDER BY Clause does not have
OFFSET / FETCH options for paging
|
ORDER BY Clause have OFFSET /
FETCH options for paging
|
|
14
|
SQL Server 2008 is code named as
Katmai.
|
SQL Server 2012 is code named as
Denali
|
|
15
|
In SQL Server 2008, audit is an
Enterprise-only feature. Only available in Enterprise, Evaluation, and
Developer Edition.
|
In SQL Server 2012,support for
server auditing is expanded to include all editions of SQL Server.
|
|
16
|
Sequence is not available in SQL
Server 2008
|
Sequence is included in SQL Server
2012.Sequence is a user defined object that generates a sequence of a number
|
Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...
Great article,Thank you for sharing this awesome Post.
ReplyDeleteKeep updating....
Microsoft BI Training Online
Thank you for your valuable feedback
Delete