May 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
  • Hire Me
  • Health Check
Oct19

SQLAuthority News – Storing Data and Files in Cloud – Dropbox – Personal Technology Tip

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Personal Technology
6 Comments
I thought long and hard about doing a Personal Technology Tips series for this blog.  I have so many tips I’d like to share.  I am on my computer almost all day, every day, so I have a treasure trove of interesting tidbits I like to share if given the…
Read More
Oct18

SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL System Table
8 Comments
I have mentioned earlier on this blog that I love social media – Facebook and Twitter. I receive so many interesting questions that sometimes I wonder how come I never faced them in my real life scenario. Well, let us see one of the similar situation. Here is one of…
Read More
Oct17

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 2 of 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices
1 Comment
This is the second part of the two part series of Practices for Software Startup Pluralsight Course. Please read the first part of this series over here. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik. Personal…
Read More
Oct16

SQLAuthority News – Pluralsight Course Review – Practices for Software Startups – Part 1 of 2

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices
3 Comments
This is first part of the two part series of Practices for Software Startup Pluralsight Course. The course is written by Stephen Forte (Blog | Twitter). Stephen Forte is the Chief Strategy Officer of the venture backed company, Telerik, a leading vendor of developer and team productivity tools. Stephen is also…
Read More
Oct15

SQL SERVER – Free Print Book on SQL Server Joes 2 Pros Kit

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Joes 2 Pros, SQLAuthority Book Review
23 Comments
Rick Morelan and I were discussing earlier this month that what we can give back to the community. We believe our books are very much successful and very well received by the community. The five books are a journey from novice to expert. The books have changed many lives and…
Read More
Oct14

SQL SERVER – Find First Non-Numeric Character from String

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String
11 Comments
It is fun when you have to deal with simple problems and there are no out of the box solution. I am sure there are many cases when we needed the first non-numeric character from the string but there is no function available to identify that right away. Here is…
Read More
Oct13

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DMV, SQL System Table
19 Comments
5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have…
Read More
Previous 1 … 501 502 503 504 505 506 507 … 830 Next

SQL SERVER 2016 – InMemory OLTP support for Foreign Key

Hyper V: Error and Fix – Fix – Boot failure. Reboot and Select proper Boot device

SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? stopaterror

SQL SERVER – FIX: Msg 4335, Level 16, State 1 – The specified STOPAT time is too early

SQL SERVER – 2016 – Creating Additional Indexes with Clustered ColumnStore Indexes

SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? wmi-01-800x210

SQL SERVER – Script: Change Service Account Using WMI / SMO

Interview Question of the Week #055 – How to Convert ASCII to DECIMAL or DECIMAL to ASCII?

SQL SERVER - Why is My Query Switching to Row Processing and Not Doing Batch Processing? cloumnstore_abort-row-01-800x558

SQL SERVER – Why is My Query Switching to Row Processing and Not Doing Batch Processing?

Previous 1 … 501 502 503 504 505 506 507 … 830 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 104 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