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
May4

Diagnosing a Frozen Server With the Dedicated Admin Connection

Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL Server Configuration, sqlcmd
No Comments

The dedicated admin connection provides a narrow emergency path to a stalled SQL Server; prepare remote access and keep diagnostics light.

Continue Reading
May3

XML sql:column: Compare XML With a Relational Value

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

XML sql:column passes a typed relational value into XQuery. Keep node existence separate from a missing document and a scalar Boolean.

Continue Reading
May2

SQL SERVER – Performance Improvement with of Executing Stored Procedure with Result Sets in SQL Server 2012

Pinal Dave
SQL Tips and Tricks
SQL Scripts
4 Comments

How fast are result sets in SQL Server 2012 compared with a temp table? I ran both methods and compared their execution plans to answer a reader.

Continue Reading
May1

Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences

Pinal Dave
SQL Tips and Tricks
MySQL, SQL Identity, SQL Migration, SQL Server
No Comments

Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.

Continue Reading
Apr30

SQL SERVER – CTAS – Create Table As SELECT – What is CTAS?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Table Operation
41 Comments

CTAS stands for Create Table As Select. In SQL Server you do it with SELECT INTO, which creates the new table and fills it with data in one step.

Continue Reading
Apr29

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets – New

Pinal Dave
SQL Tips and Tricks

Executing stored procedure with result sets works for multiple resultsets too. WITH RESULT SETS handles them easily, while the old temp table method cannot.

Continue Reading
Apr28

SQL SERVER – 2012 – Executing Stored Procedure with Result Sets

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure
15 Comments

Denali lets you execute a stored procedure with result sets and rename its columns at run time, with no temp table needed. Here is a quick script.

Continue Reading
Previous 1 … 600 601 602 603 604 605 606 … 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