Log in | Register

Sandip Pani, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Sandip Pani, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education



About Sandip Pani

Sandip Pani is a Database/BI developer and speaker and is located in Bangalore, India. He has been working with SQL Server over 10 years. He is MCITP for SQL Server 2008 and specializes in SQL Server for application developers and performance and query tuning. His specialization is into Query Tuning and performance troubleshooting. He is working as Senior Technical Specilist for NextGen Healthcare. He is active in SQL community world. He share and enhance his knowledge of SQL Server by spending time at newsgroups and forums, reading and writing blogs, and attending and speaking at conferences.

Identity Property Part – 2

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 (Part – 1).

After reading this post you will know 5 facts about Identity column.

Fact 1– By default both Identity seed and increment value will set to 1.

Run the above script  and […]

Identity Property Part-1

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 seed and increment or neither. By default the value of seed […]

SQL Server Index Hint

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 requested […]

Want to be a SQL Pro? Learn from the best & get career advice too

The elites and successful from every industry have few things in common. They understand that the surest way to achieve success is to model someone who is already successful. If you don’t have good models, find someone who is the best in your chosen field and emulate them. I understood this through years of my […]

SQL Server Day 26 Oct 2013 – Bangalore witnesses yet another fine SQL show

Unbelievable, SQLServerGeeks team made it, Yes SQL Server Day event in 3 cities (Bangalore, Gurgaon and Hyderabad) on same day (date: 26 Oct 2013). This is first in its type where any SQL community organized events on the same day in multiple cities in India.

I’m fortunate to be part of   SQL SERVER DAY event […]

By |January 15th, 2014|Categories: SQL Server|Tags: |0 Comments