Sunday, November 29, 2015

Big Data Analytics - Learn it easily and quickly

›
Big Data Analytics is proving to be the biggest game-changing opportunity for organizations across the globe. With the availability of la...
Friday, October 16, 2015

Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server

›
In my last article “Converting Comma Separated Value to Rows and Vice Versa in SQL Server” , I talked about how you can convert comma sep...

Converting Comma Separated Value to Rows and Vice Versa in SQL Server

›
Often while reporting you will encounter a situation where you will have comma separated (or separated with some other character) values i...

CONCAT and STUFF Functions in SQL Server 2012

›
We often need to combine two or more string values to use this combined string value in reporting. Although there was a way to do that in ...

Getting Starting with Database Engine Tuning Advisor in SQL Server

›
There are different techniques to optimize the performance of SQL Server queries, like keeping required and updated statistics, creating r...
Wednesday, October 14, 2015

Importance of Statistics and How It Works in SQL Server

›
Statistics refers to the statistical information about the distribution of values in one or more columns of a table or an index. The SQL S...

Lead and Lag functions in SQL Server 2012

›
Have you ever been in a situation where you needed to write a query that needed to do comparisons or access data from the subsequent rows ...