|
|
-
|
|
Some column name have been renamed are follows:
Previous Column Name New Column Name
---------------------------------------------------------------------------
physical_memory_in_bytes physical_memory_kb
bpool_commit_t...
|
|
-
|
|
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"....
|
|
-
|
|
`Sys.dm_os_workers` DMV is used to get all the workers in the system. From this DMV, "locale" column has been removed in SQL Server 2012. This column will represent the Locale identifier, which can be used to determine to format the numbers,currencies i...
|
|
-
|
|
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...
|
|