I love talking about performance tuning and I love teaching about performance tuning. I think this is one subject, which everyone would like to discuss about, as this subject never gets old. I stay in India so I often deliver conference sessions on this subject over here. However, if you are in the USA, this is your opportunity to join me to discuss about SQL Server Performance. I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:
SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause
Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?” Well, the answer can be quite long but I will try to answer in few words and a very simple one. If you are talking about resultset – there will be not much…
Read MoreSQL SERVER – SQL Server 2008 Service Pack 4 – Download
It has been a long time since SQL Server 2008 got Service Pack Update. Microsoft has finally released SQL Server 2008 service pack 4 and its feature pack. SQL Server 2008 SP4 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 Service Pack…
Read MoreSQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table
Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No – If you have an integer column in your table and…
Read MoreSQL SERVER – Row Offset in SQL Server For Different Version
A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on…
Read MoreSQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049
[Note from Pinal]: This is a 49th episode of Notes from the Field series. Every day I get few emails where I am asked how to tune queries so the entire server run faster. I always end up writing long answer this question. The reason is simple – query tuning…
Read MoreSQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR
I have been blogging for almost 8 years now. I believe I have seen pretty much every single kind of email and comments I can receive from users. However, there are sometimes few which just are so interesting that I feel like blogging about it. This blog post is written…
Read MoreMySQL – Scaling Existing Applications: Key Observations and Measurements
In the earlier blog post we discussed about How to Create a Distributed Relational SQL Database, today we will continue to learn about Scaling Existing Applications: Key Observations and Measurements. In the use case of an existing application that is on the verge of reaching the limits of its monolithic…
Read MoreMySQL – How to Create a Distributed Relational SQL Database
Distributed relational databases are a perfect match for Cloud computing models and distributed Cloud infrastructure. As such, they are the way forward for delivering new web scale applications. But how is the data distributed in a distributed relational database? What is the best way to distribute data for my applications?…
Read MoreSQL SERVER – How to Catch Errors While Inserting Values in Table
Question: “I often get errors when I insert values into a table, I want to gracefully catch them, how do I do that.” Answer: Very simple. Just use TRY… CATCH. Here is the simple example of TRY…CATCH I have blogged earlier when it was introduced. Here is the example, I…
Read More