|
|
-
|
|
The SQL Server columnstore index feature, code-named **Apollo**, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query processing in SQL Server 2012 in many cases by a factor o...
|
|
-
|
|
Yet another Dynamic Management Function (DMF) introduced by SQL Server 2012 is `sys.dm_exec_describe_first_result_set_for_object`. The functionality is the same as [`sys.dm_exec_describe_first_result_set`][1], except that this function takes an `Object ...
|
|
-
|
|
SQL Server 2012 introduces a new Dynamic Management Function (DMF) which allows us to examine the metadata of the result set of a query, stored procedure etc.
This is very handy to examine the number of columns, column names, data types etc which is ot...
|
|
-
|
|
One of the breaking changes added in SQL Server 2012 is related to the creation of `#TEMP` tables. SQL Server 2012 assigns a negative value as the `OBJECT ID` of the `#TEMP` tables.
Your code may or may not break depending upon the method you use to c...
|
|
-
|
|
If you are installing SQL Server 2012 on Windows 7 or on Windows Server 2008 R2, you will need Service Pack 1 (SP1) before you can proceed with the installation.
In addition, .NET 3.5 SP1 is required if you wish to install Database Engine, Reporting Se...
|
|
-
|
|
SQL Server 2008 R2 introduced **SQL Server 2008 R2 Datacenter Edition** which is no more available with SQL Server 2012. Instead a new edition is added: **SQL Server 2012 Business Intelligence Edition**.
The key features of the Business Intelligence E...
|
|
-
|
|
One of the challenges involved in moving/copying databases to a new location (prior to SQL Server 2012) was copying the dependencies along with the database. External dependencies such as login names, linked servers etc are not automatically copied to t...
|
|
-
|
|
CONCAT function can be used to concatenate two or more strings. This function is available before in other databases like Oracle,MySQL etc. This feature will offer below advantages over standard concatenation operator(+)
- If any of the string is nul...
|
|
-
|
|
The new SEQUENCE type in SQL Server 2012 will allows you to create sequential numbers. In general identity columns can be used to uniquely identify records in a table. But if we wants to maintain identity columns across multiple tables, or if we need th...
|
|
-
|
|
SQL Server 2012 enhanced the `EXECUTE` statement with an additional clause `WITH RESULT SETS` which allows you to convert/alter the columns and data types of the results produced by the `EXECUTE` statement.
Assume that your stored procedure returns an ...
|
|