Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Sep3

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
36 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Preparing XML in Memory If you want to take XML data and create…
Read More
Sep2

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
67 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Shredding XML Our introduction to XML in the last 3 days of…
Read More
Sep2

SQLAuthority News – Programming & Development For Microsoft SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Joes 2 Pros, SQLAuthority Book Review
4 Comments
I just can not resist sharing this video which my wife took while I was reading the book I co-authored. After long debate with my wife I have decided to put this video on youtube for public viewing. I initially thought, it is good to just have this in personal…
Read More
Sep1

SQLAuthority News – SQL Wait Stats Joes 2 Pros Book Released Today – 30 Million Views Completed

Pinal Dave
SQLAuthority News
SQL Wait Stats, SQLAuthority Book Review
48 Comments

Happy Ganesh Chaturthi to all the friends of SQLAuthority.com. On today’s auspicious day I have three news to share – 1) Shaivi’s 2nd Birthday 2) New Book Released 3) 30 Millions Views.

Read More
Sep1

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
53 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. XML Path Mode The XML Raw and Auto modes are great for displaying…
Read More
Aug31

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 31 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
64 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Using Root With Auto XML Mode Now let’s add a root…
Read More
Aug30

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – What is XML? – Day 30 of 35

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQL Scripts
86 Comments
Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Let’s look at another example from the Employee table.  If you…
Read More
Previous 1 … 562 563 564 565 566 567 568 … 829 Next
SQL SERVER - sp_readrequest - Long Running Process log

SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library

SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100’ from Assembly

SQL SERVER - sp_readrequest - Long Running Process changetohttps

WordPress – How to Move from HTTP to HTTPS – The Simple Complete Tutorial

SQL SERVER - sp_readrequest - Long Running Process missing

SQL SERVER – Availability Group Missing or Deleted Automatically?

SQL SERVER - sp_readrequest - Long Running Process reg-remote-02-800x344

SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request

SQL SERVER - sp_readrequest - Long Running Process rowcountwithexecution_2-800x255

How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #115

SQL SERVER - sp_readrequest - Long Running Process DatabaseMailExeMinimumLifeTime-800x348

SQL SERVER – sp_readrequest – Long Running Process

Previous 1 … 562 563 564 565 566 567 568 … 829 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.


Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com