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
Sep29

SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries

Pinal Dave
SQL Puzzle
SQL Index, SQL View
5 Comments

Reader Bob explains why aggregate concatenation results depend on expression location, using an ANSI point of view, and shares a similar example to run.

Continue Reading
Sep28

Giving Web Developers Safe Database Access

Pinal Dave
SQL Tips and Tricks
Developer, SQL Login, SQL Server, SQL Server Security, SQL View
1 Comment

Give web developers safe database access with narrow roles and views, a reporting replica where useful, and audit that identifies real changes.

Continue Reading
Sep27

Storing Files in the Database or on Disk

Pinal Dave
SQL Tips and Tricks
Filestream, SQL Data Storage, SQL Datatype, SQL Server
No Comments

Storing files in the database requires tradeoffs in transactions, backup size, and access; compare varbinary, FILESTREAM, FileTable, and paths.

Continue Reading
Sep26

Finding the Real Error Behind an SSMS Dialog

Pinal Dave
SQL Tips and Tricks
DBA, SQL Error Messages, SQL Server, SQL Server Management Studio
1 Comment

Finding the real error behind an SSMS dialog starts with technical details, inner exceptions, and a safe query-window reproduction.

Continue Reading
Sep25

SQL SERVER – Outer Join in Indexed View – Question to Readers

Pinal Dave
SQL Performance
SQL Index, SQL Joins, SQL View, SQL White Papers
4 Comments

Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?

Continue Reading
Sep24

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

Pinal Dave
SQL Puzzle
SQL Index, SQL Scripts, SQL White Papers
27 Comments

A query on the base table used an index it did not own. It was the index on index view of the same table, an interesting observation from an optimization project.

Continue Reading
Sep23

SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Table Operation
46 Comments

How do you insert values of stored procedure output into a table? The traditional temp table way, and an alternate method with a Table Valued Function.

Continue Reading
Previous 1 … 686 687 688 689 690 691 692 … 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