|
|
-
|
|
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 ...
|
|
-
|
|
This is another function which has statistical background. This function will returns the continuous interpolated value at the specific offset
PERCENTILE_CONT() function will takes a parameter, which indicates the offset and it should be between 0 and...
|
|
-
|
|
Before SQL Server 2012, HashBytes function used to support following algorithms while encrypting a string.
MD2,MD4,MD5,SHA and SHA1
Now In SQL Server 2012, 2 more algorithms "SHA2_256" and "SHA2_512" has been added.
Eg:
SELECT HASHBYTES('SHA2_...
|
|
-
|
|
Following permissions has been added in SQL Server 2012
1. Alter any availability Group - Users having this permission can update any availability group.
2. Alter any server role - Users having this permission can update server roles.
3. Create availab...
|
|
-
|
|
Before SQL Server 2012, we have 8 Server Roles. There was no provision to create our own Custom Server Role. Now, in SQL Server 2012, we can create our own Custom Server Role. While creating Custom Server Role, we can configure the required Endpoints,Lo...
|
|
-
|
|
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)`....
|
|