Sandip_Pani.JPG

Sandip Pani

I've around 7 years of experience as a SQL/BI developer. I worked in SQL server 2005/ 2008/ 2008R2 and SQL Server 2012. Currently Working for QSI Healthcare (NextGen). Regional mentor for SQLServerGeeks.com for Bangalore chapter. Active Member of SQLBangalore and BDotNet user groups. 
http://sqlcommitted.com http://sqlcommitted.com/feed/

There are new functions introduces with the release of MS-SQL Server 2012. To perform analytic operation in T-SQL , this time Microsoft has added couple of very handy functions.

Blog posts RSS

SQL Server – Index Hint 01 Jan 2014
SQL Server query optimizer decides which index to use, when a query is requested. SQL Server optimizer is a cost based optimizer so it picks the index which has low cost based on performance. When we design an index for a query, optimizer will utilize the defined index to generate the plan for ...

SQLCommitted 2013 in review 31 Dec 2013
SQLCommitted 2013 annual report prepared by wordpress. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 11,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 4 sold-out performances for that many ...

SQL Server – Identity Property Part – 3 06 Dec 2013
This is third part of this blog series. You can read the 2nd part here (SQL Server: Identity Property Part – 2). In this blog post we’ll learn how to retrieve last generated identity value. There are scenarios where we need to fetch the last inserted identity value, for example in a transaction we ...

SQL Server: Identity Property Part – 2 03 Dec 2013
In this blog series, I’m covering all about Identity property. This is the second part of this series. You can read the first part here (SQL Server: Identity Property Part – 1). After reading this post you will know 5 facts about Identity column. Fact 1- By default both Identity seed and increment ...

SQL Server: Identity Property Part-1 08 Aug 2013
Identity property is one of the most frequently used properties to generate auto increment value. I’ve seen sometime developer get confused with it. So this blog series will help developers to know everything about Identity property. Syntax: IDENTITY [(seed, increment)] You must specify both the ...