T-SQL Pivot

To a large extent business users want to visualize data in a tabular format as shown below. This is a good presentation however, it takes 3 rows just to present data for CustomerID 11000 and 31406 rows to present data for all the CustomerIDs. What if your requirement is to represent each year as an individual... Continue Reading →

50 Frequently Asked SQL Server Interview Questions – Part I

How will you to performance tuning ? https://www.youtube.com/watch?v=P97_oFfD218 What will you look for in an execution plan ? http://www.mssqltips.com/sqlservertutorial/285/query-execution-plans/ What is bookmark look-up related to execution plan http://www.qdpma.com/CBO/s2kCBO_2a.html Table variables vs temp tables http://engineering.picscout.com/2012/04/ sql-temporary-tables-vs-table-variables_17.html How do you pass output parameter in a stored procedure... If you specify the OUTPUT keyword for a parameter in... Continue Reading →

Create a website or blog at WordPress.com

Up ↑