|
|
-
|
|
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...
|
|
-
|
|
I have never used it, but I have seen queries using the older syntax `*= and =*` in joins. This usage is no more supported in SQL Server 2012 (Denali)....
|
|
-
|
|
SQL Server 2012 (Denali) discontinued support for `COMPUTE` and `COMPUTE BY`. Any queries currently using `COMPUTE` or `COMPUTE BY` may be rewritten using the `ROLLUP` command. ...
|
|
-
|
|
RAISERROR in the format `RAISERROR integer 'string'` is discontinued in SQL Server 2012 (Denali). Recommended alternate is to rewrite the statement using the `RAISERROR(…)` syntax....
|
|
-
|
|
SQL Server 2012 (Denali) discontinued support for query hint `FASTFIRSTROW`. The recommended alternate option is `OPTION (FAST n)`....
|
|
-
|
|
SQL Server 2012 (Denali) does not support `DATABASEPROPERTY()` function any more. The recommended alternative is `DATABASEPROPERTYEX()`...
|
|
-
|
|
32-bit Address Windowing Extensions (AWE) and 32-bit Hot Add memory support are discontinued on SQL Server 2012 (Denali). Books Online suggests to upgrade to a 64 bit computer :-)...
|
|
-
|
|
SQL Server 2012 (Denali) discontinued support for SQL Mail. Database Mail feature is the suggested alternative to send emails from SQL Server. ...
|
|
-
|
|
SQL Server 2012 Denali discontinued support for the system stored procedure `sp_dboption`. `ALTER DATABASE` is the suggested alternative....
|
|
-
|
|
SQL Server 2012 Denali discontinued support for WITH APPEND clause on triggers. Suggested alternative is to recreate the whole trigger. ...
|
|