|
|
-
|
|
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...
|
|
-
|
|
`sp_describe_undeclared_parameters` is a new system stored procedure added in SQL Server 2012 (Denali). It returns a result set that contains metadata about undeclared parameters in a Transact-SQL batch.
*The following excerpt is taken from MSDN docume...
|
|
-
|
|
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...
|
|
-
|
|
SQL Server 2012 added a new UI dialog that allows to add/edit/manage the start up parameters. This has become much easier than the previous versions.
![SQL Server 2012 - Service Property Page - Startup Parameters][1]
[1]: http://img1.beyondrelatio...
|
|