This functions will return columns values from subsequent rows in the same result set without the use of a self-join. Example: DECLARE @Users TABLE( UserID INT IDENTITY, UserName VARCHAR(20) ) INSERT INTO @Users (Use...

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 EOMONT...

Some column name have been renamed are follows: Previous Column Name New Column Name --------------------------------------------------------------------------- physical_memory_in_bytes physical_memory_kb bpool_commi...

Some column name have been renamed are follows: Previous Column Name New Column Name --------------------------------------------------------------------------- physical_memory_in_bytes physical_memory_kb bpool_commi...

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 (...

IIF Function returns TRUE or FALSE as result based on condition. DECLARE @FirstValue int = 1 DECLARE @SecondValue int = 2 SELECT IIF ( @FirstValue > @SecondValue , 'TRUE', 'FALSE' ) AS Result Result FALSE...

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 t...

Replication new features are: ----------------------------- 1.Replication Support for AlwaysOn Availability Groups 2.Replication supports Extended Events. 3.Replication supports up to 15,000 partitions for tables and indexes....

This is one of the functions, which has some statistical background. **Distribution Value:** A distribution value indicates the possibility of occurance of that value among a group of values. For Example, when a coin is thrown, it can be head or ta...

This function provides cumulative distribution value with "Order by" and "Partition By" Group....