This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Apr3

SQLAuthority News – Launch of Gandhinagar SQL Server User Group

Pinal Dave
SQLAuthority News
Database, DigiCorp, MVP, SQL User Group, SQLAuthority Author Visit
6 Comments

The launch of Gandhinagar SQL Server User Group on March 27, 2009 drew over 50 database enthusiasts, and we even ran out of chairs. Register at the portal.

Continue Reading
Apr2

What Is a Database Backup? Full, Differential, Log

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server
40 Comments

A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.

Continue Reading
Apr1

FIFO Inventory Costing in T-SQL: Matching Sales to Purchase Lots

Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Joins, SQL Scripts, Temp Table
No Comments

Which purchase lot paid for which sale? Two running totals and one join answer it, with no cursor and no loop.

Continue Reading
Mar31

SQL SERVER – IntelliSense Does Not Work – Enable IntelliSense

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server Management Studio, SQL Utility
165 Comments

IntelliSense in SQL Server 2008 not showing suggestions? Four ways to Enable IntelliSense, starting with connecting to a 2008 instance and checking Tools, Options.

Continue Reading
Mar30

Planning for Data Growth

Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Backup and Restore, SQL Data Storage
1 Comment

Planning for data growth uses backup and file trends, workload events, storage lead times, and a dated request for more capacity.

Continue Reading
Mar29

SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL TempDB
38 Comments

Msg 2714 says there is already an object named #temp in the database, even after an IF EXISTS check and DROP. A reader asked why, and here is the answer.

Continue Reading
Mar28

How Many CPUs SQL Server Really Uses

Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL DMV, SQL Server, Virtualization
No Comments

CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.

Continue Reading
Previous 1 … 713 714 715 716 717 718 719 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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 19 books and 125 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 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.

  • Books
  • Testimonials
  • Privacy Policy

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