Sunday, March 30, 2014

Magic Quadrant for Business Intelligence and Analytics Platforms – 2014 February

›
Gartner has published its Magic Quadrant for Business Intelligence and Analytics platforms covering 17 capabilities grouping them into 3 ca...
Thursday, March 20, 2014

Door-Quiz – SQL Server Sri Lanka User Group Meet-up

›
We had another Door-Quiz at SS SLUG yesterday and as usual, the question asked was tricky. However, many had circled the correct answer and ...
Thursday, March 13, 2014

Who invented dimensional modeling?

›
Who introduced or invented Dimensional Modeling? Was it invented by Ralph Kimball ? Since he completely aligns with Dimensional Modeling in ...

Why SQL Server does not drop the procedure and recreate the object when the code is written properly?

›
This is bit funny, it took few minutes to figure out the reason for getting “ There is already an object named '' in the database. ”...
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...