|
|
-
|
|
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...
|
|
-
|
|
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...
|
|
-
|
|
SQL Server 2012 (Denali) introduced a number of new performance counters and removed a few that were available with the previous versions of SQL Server.
Several `AWE` related counters (such as *AWE lookup maps/sec*, *AWE unmap pages/sec* etc) were re...
|
|
-
|
|
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...
|
|