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
Dec20

SQLAuthority News – Presented on Database Worst Practices at SQLPASS 2014 in Seattle – November 5, 2014

Pinal Dave
SQLAuthority News
SQL PASS, SQLAuthority Author Visit
No Comments

I presented Database Worst Practices at SQLPASS 2014 in Seattle on November 5. Here is the title and abstract of the session in case you missed it.

Continue Reading
Dec19

SQL SERVER – Reverse String Word By Word Part 4

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String
No Comments

In Reverse String Word By Word Part 4, Paul G slices the string by a delimiter and rebuilds it in reverse order. Here is his full script.

Continue Reading
Dec18

SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, SSIS
4 Comments

SQL Server 2012 added the SSIS Catalog to store, run and log packages in one place. In Notes from the Field #058, Tim Mitchell shows how to set it up.

Continue Reading
Dec17

SQL SERVER – Reverse String Word By Word Part 3

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String
No Comments

Reverse String Word By Word Part 3 shows Yuri Petrov’s way to reverse words in a sentence, using an auxiliary numbers table in two parts.

Continue Reading
Dec16

Is It the Database? Reading ASYNC_NETWORK_IO

Pinal Dave
SQL Performance
Computer Network, SQL DMV, SQL Server, SQL Wait Stats
No Comments

Investigate ASYNC_NETWORK_IO with request and task evidence, check client consumption, and separate large outputs from network faults.

Continue Reading
Dec15

SQL SERVER – Reverse String Word By Word Part 2

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
2 Comments

In Reverse String Word By Word Part 2, Sanjay Monpara and Yuri Petrov improve my script. The new, more robust version uses a Split function.

Continue Reading
Dec14

Primary Data File Extensions: Does the .mdf Name Matter?

Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Scripts, SQL Server Architecture
7 Comments

Can a primary data file end in something other than .mdf? I built a demo database with odd names, checked each file, then detached and attached it.

Continue Reading
Previous 1 … 399 400 401 402 403 404 405 … 847 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