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
Dec28

SQL SERVER – Plan Cache and Data Cache in Memory

Pinal Dave
SQL Performance
SQL Memory, SQL Scripts
5 Comments

Two scripts I share with clients all the time: they show the plan cache and data cache in memory, with cached plans by size and cached pages by table.

Continue Reading
Dec27

SQL SERVER – ORDER BY ColumnName vs ORDER BY ColumnNumber

Pinal Dave
SQL Tips and Tricks
SQL Scripts
23 Comments

I strongly favor ORDER BY ColumnName over ORDER BY ColumnNumber. The performance is the same, but here is why column numbers are risky in real code.

Continue Reading
Dec26

SQL SERVER – Server Side Paging in SQL Server Denali – Part2

Pinal Dave
SQL Performance
SQL Paging, SQL Scripts
2 Comments

Part 2 of server side paging in SQL Server Denali: a reader keeps rows per page and page number in a table, and OFFSET and FETCH can read them from there.

Continue Reading
Dec25

SQLAuthority News – 18 Seconds of Fame – My PASS Experience

Pinal Dave
SQL Performance
SQLAuthority Author Visit
1 Comment

At SQLPASS someone asked me for 15 seconds on camera and I forgot all about it. Today I found out about that clip: my 18 seconds of fame from PASS.

Continue Reading
Dec24

Restoring to a Newer SQL Server Is a One-Way Trip

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

Plan a restore to newer SQL Server with the version boundary in mind, preserve the original backup, and understand options for moving data back.

Continue Reading
Dec23

SQL SERVER – Index Created on View not Used Often – Observation of the View – Part 2

Pinal Dave
SQL Performance
SQL Scripts, SQL View
3 Comments

A reader asked what happens when we create an index on the base table as well as on the view. Part 2 of my observation of the view looks at both cases.

Continue Reading
Dec22

geometry Collections: Read Members With STGeometryN

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

geometry Collections hold member shapes that STGeometryN can return individually. I extract a point and a line from one fixed collection. A third request deliberately exceeds its member count.

Continue Reading
Previous 1 … 619 620 621 622 623 624 625 … 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