|
|
-
|
|
Some column name have been renamed are follows:
Previous Column Name New Column Name
---------------------------------------------------------------------------
physical_memory_in_bytes physical_memory_kb
bpool_commit_t...
|
|
-
|
|
`Sys.dm_os_workers` DMV is used to get all the workers in the system. From this DMV, "locale" column has been removed in SQL Server 2012. This column will represent the Locale identifier, which can be used to determine to format the numbers,currencies i...
|
|
-
|
|
I have never attempted more than a dozen partitions on any of the databases I have worked. However, it is interesting to know that SQL Server 2012 (Denali) has increased the partition limit to 15,000.
Books Online says:
>>Microsoft SQL Server 2012 Rele...
|
|
-
|
|
The previous versions of SQL Server never allowed index operations (CREATE, DROP, REBUILD) on ONLINE mode, if the index includes a Large Value Type column (VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) etc).
Try running the following code in SQL Server ...
|
|
-
|
|
The NEAR operator in the CONTAINS predicate is improved in SQL Server 2012 (Denali) to allow users to specify distance between two terms.
This allows a user to run queries such as:
SELECT candidate_name
FROM Candidates
WHERE CONTAINS(
...
|
|
-
|
|
The following excerpt is taken from the FTS team blog which explains new Full Text Search enhancements added to SQL Server 2012 - Denali.
> Besides performance and scale improvement, we also added support for property scoped searches over documents wi...
|
|
-
|
|
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...
|
|