|
|
-
|
|
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...
|
|
-
|
|
`LAST_VALUE()` function returns the last value among the set of ordered values according to specified ordered & partitioned criteria. One difference between first_value and last_value is, for a group of rows, `FIRST_VALUE()` will return same value, wher...
|
|
-
|
|
PERCENT_RANK() function will returns the percentage value of rank of the element among its group.
PERCENT_RANK() function value will be
1. For first element in its group, it will be 0.
2. For last element in its group, it will be 1.
3. For remaining...
|
|
-
|
|
The new pagination support allows you to write queries that can return rows from specific position of the result set. For example: the following query returns rows 20 to 30 from the result set.
SELECT
*
FROM Customers
ORDER BY CustID ...
|
|
-
|
|
In SQL Server 2012, one of the addition to OVER clause is, ROWS/RANGE Clause. In general, when we apply aggregate functions in over clause, it will apply to all rows in that group/partition. Suppose, if we wants to restrict the number of rows, it involv...
|
|
-
|
|
SQL Server 2012 Denali discontinued support for the system stored procedure `sp_dboption`. `ALTER DATABASE` is the suggested alternative....
|
|
-
|
|
Often in financial applications, its required to calculate End date of a month. SQL Server 2012 provides a function EOMONTH() to calculate end date of a month.
DECLARE @Currentdate DATETIME
SET @Currentdate = '12/12/2010'
SELECT EOMONTH (...
|
|
-
|
|
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...
|
|
-
|
|
In few scenarios, our packages might contain a lot of items, which makes very difficult to understand those. Now in Denali, you can group these items, which gives better look and feel, and a new user can simply understand, what’s happening inside the pa...
|
|
-
|
|
Until SSIS 2012, in annotations, to enter multi-line text, user has to do it in text-editors or by pressing Ctrl+Enter. Now in SSIS 2012, annotations support entering multi-line text. By just pressing enter key, we can insert text in next line.
![alt ...
|
|