Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Oct12

SQL SERVER – SQL Server 2008 Service Pack 4 – Download

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
No Comments
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 More
Oct11

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Identity, SQL Scripts
14 Comments
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 More
Oct10

SQL SERVER – Row Offset in SQL Server For Different Version

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
1 Comment
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 More
Oct9

SQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Notes from the Field, SQL Server Security
1 Comment
[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 More
Oct8

SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Identity
No Comments
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 More
Oct7

MySQL – Scaling Existing Applications: Key Observations and Measurements

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL, ScaleBase
1 Comment
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 More
Oct6

MySQL – How to Create a Distributed Relational SQL Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL, ScaleBase
4 Comments
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 More
Previous 1 … 394 395 396 397 398 399 400 … 831 Next

SQL SERVER – SQL Server 2008 Service Pack 4 – Download

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

SQL SERVER – Row Offset in SQL Server For Different Version

SQL SERVER – ​Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

SQL SERVER – Reset the Identity SEED After ROLLBACK or ERROR

MySQL – Scaling Existing Applications: Key Observations and Measurements

MySQL – How to Create a Distributed Relational SQL Database

Previous 1 … 394 395 396 397 398 399 400 … 831 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com