Sunday, March 9, 2014

Cumulative update package 11 for SQL Server 2008 R2 Service Pack 2

›
Cumulative update #11 is available for SQL Server 2008 R2 SP2. Refer the following link for downloading it and understanding the fixes done....
Thursday, February 27, 2014

SQL Server: Calculating running totals using T-SQL

›
This is not a new topic. If you search, you will surely find many posts on this, mostly with traditional techniques but not using newest cap...
5 comments:
Wednesday, February 26, 2014

Analysis Services (SSAS): Calculating running totals for a given period using MDX

›
Calculating running totals against a numeric is not an easy task with both relational databases using T-SQL and multidimensional databases u...
6 comments:
Sunday, February 23, 2014

SQL Server Management Studio: Exploring General Options for T-SQL – Part I

›
SQL Server Management Studio is an integrated management, development and querying application that we use for working with SQL Server insta...
Friday, February 21, 2014

SQL Server 2012: Getting Previous and Next values using Offset functions

›
How can we access other rows in a set while accessing one particular row? In other words, can we access values in other rows other than curr...
Monday, February 17, 2014

UNION ALL is possible. How about INTERSECT ALL and EXCEPT ALL?

›
Not expecting duplicates but a significant improvement in performance, we tend to use UNION ALL when no duplicates are guaranteed in combini...
Sunday, February 16, 2014

Best way to find records exist in one set that do not appear in other set: NOT IN | LEFT OUTER | EXCEPT

›
Finding records exist only in one set that do not exist in another is a common requirement in database developments. Finding customers who h...
Saturday, February 15, 2014

What is the difference between CROSS APPLY and OUTER APPLY?

›
Processing rows in one set using another set is a common coding pattern used mostly with combining or comparing rows from sets. SQL Server o...
Friday, February 14, 2014

Types of SQL Server Sub Queries: Self-Contained, Correlated, Scalar, Multi-Valued, Table-Valued

›
A Sub query is a SELECT statement that is embedded to another query. Or in other words, a SELECT statement that is nested to another SELECT....
2 comments: