|
|
-
|
|
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...
|
|
-
|
|
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 (...
|
|
-
|
|
When SQL Server chooses seek over scan while retrieving record details, it will compare key value with search input, based on comparison result, Query engine will move to appropriate page. Suppose, index has multiple columns, if we don't want all key co...
|
|
-
|
|
Before SQL Server 2012, We can't use "Order By" clause, while we are using aggregate functions in OVER clause. Suppose, to calculate company-wise cumulative revenues per year, we can't take the advantage of aggregate operators with OVER clause.
Below ...
|
|
-
|
|
Until SQL Server 2012, LOG() function used to support only Natural Log. From SQL Server 2012 onwards, LOG() function used to accept logarithmic value of any base. Now LOG() function will accepts base value as second parameter.
SELECT LOG(10) as R...
|
|
-
|
|
Often while tuning stored procedures, we will see tables have the "seek" operator. Few times one of reason for slow performance is wrong estimates on number of rows. Because of that, there are more chances that query optimizer choose "SEEK" over "SCAN"....
|
|
-
|
|
In SSIS Denali 2012, toolbox has been enhanced to provide better experience to users. 2 New categories been added to both control flow toolbox and dataflow toolbox and items has been categorized according to their use.
1. Favorites
2. Common
Show the ...
|
|
-
|
|
Catalog DB is the new feature in SSIS 2012, which is point of administration and deployment for project, packages, environments and parameters etc. After the project is created, when it is deployed, it will be deployed to Catalog DB along with all packa...
|
|
-
|
|
Before SQL Server 2012, to pass parameters to packages, configurations have been used. You can create Configurations with key/value pairs and you can pass those as parameters to packages.
In SQL server 2012, code named “Denali” SSIS, a new feature “Pa...
|
|
-
|
|
This is very big change in SSIS Denali. Now SSIS Denali has a new deployment model, “Project Deployment Model” along with traditional “Legacy Deployment Model”. All the new projects in SSIS Denali in default will use this new “Project Deployment Model”....
|
|