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
Dec15

SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth

Pinal Dave
SQL Performance
SQL Scripts
68 Comments

Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.

Continue Reading
Dec14

SQLAuthority News – An Year of Personal Events – A Life Outside SQL

Pinal Dave
SQLAuthority News
15 Comments

Do I have a life outside SQL? Yes, and it is beautiful. Three photographs from my year of personal events, told with very few words.

Continue Reading
Dec13

DATEADD Fractional Numbers: Truncate Before Addition

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts
No Comments

DATEADD fractional numbers are truncated, not rounded. Compare positive and negative day additions while preserving an explicitly typed date input.

Continue Reading
Dec12

SQLAuthority News – Featured on Channel 9

Pinal Dave
SQLAuthority News
Database, SQL String
17 Comments

This blog was featured on Channel 9 in This Week on Channel 9, where Scott Hanselman and Jon Galloway talked about my CSV from table column post.

Continue Reading
Dec11

SQL SERVER – ERROR: FIX: Cannot drop server because it is used as a Distributor in replication

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Replication, SQL Scripts
61 Comments

Removing replication fails with Cannot drop server because it is used as a Distributor in replication? Two quick commands with sp_dropdistributor fix it.

Continue Reading
Dec10

geometry STTouches: A Shared Boundary Is Not Interior Overlap

Pinal Dave
SQL Tips and Tricks
Spatial Database, SQL Function, SQL Scripts, SQL Server
No Comments

geometry STTouches tests whether shapes meet without their interiors intersecting. I keep that predicate separate from a general intersection check. Sharing an edge and sharing an area are different spatial relationships.

Continue Reading
Dec9

Business Metrics Alignment: Business Intelligence Across Departments

Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Visualization, Data Warehousing
6 Comments

Managers want timely, visual and personal information for faster decisions. Business metrics alignment is where Business Intelligence helps most, because every department’s metrics support the corporate objective.

Continue Reading
Previous 1 … 675 676 677 678 679 680 681 … 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