Blog Home Page - Page 352 of 829 - SQL Authority with Pinal Dave

Jul27

I have written tons of blogs in the past around using sparse columns. The best part and lesser known part of sparse columns is that we can write to the column sets directly too. In this blog let me take a tour of how this can be achieved. When sparse…

Jul26

Interview Question of the Week #029 – Difference Between CHARINDEX vs PATINDEX

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

No Comments

Question: What is the difference between CHARINDEX vs PATINDEX? Answer: We can use either CHARINDEX or PATINDEX to search in a TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and…

Jul25

SQL SERVER – How to Find If Queries are Running in Parallel?

Pinal Dave

SQL Performance

Parallel, SQL CPU, SQL Scripts, SQL Server

Let us learn today how to find if queries are running in Parallel? If a query runs in parallel it is a query that SQL Server thinks is expensive.

Jul24

SQL SERVER – FIX – Property IsLocked is Not Available for Login

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Lock, SQL Scripts

I play and experiment with SQL Server to the max. Sometimes I am not sure what I did and I land into something undesired. Then the reason to troubleshoot starts and I get to learn something new. Sometimes these learnings are based on error messages that you folks send me.…

Jul23

SQL SERVER – What are T-SQL Median? – Notes from the Field #090

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Function

[Note from Pinal]: In this episode of the Notes from the Field series database expert Kathi Kellenberger explains about T-SQL Median. Kathi is an amazing instructor, she was the SQL author I have read in my early career. The reason, I love SQL Server because her writing has instigated love for this technology…

Jul22

SQL SERVER – Generating Meaningful Test Data with dbForge Data Generator for SQL Server

Pinal Dave

SQL

Devart, SQL Server, SQL Server Management Studio

Recently I faced with necessity of generating meaningful SQL data for testing purposes. During my search for a proper application for the task, I found out that Devart, a recognized developer of database solutions, released dbForge Data Generator for SQL Server, a GUI tool for fast generation of meaningful SQL data for development and testing purposes.

Jul21

SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server Security

There are parts of SQL Server where I always like to take expert advice. Sometimes a quick call to a friend can save you tons of time. When I see topics around AlwaysOn, though I know what the basic steps are to building and working with AlwaysOn, the hardcore troubleshooting…

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.

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.

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.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Inserting into Sparse Column Sets and Errors Associated With It

Interview Question of the Week #029 – Difference Between CHARINDEX vs PATINDEX

SQL SERVER – How to Find If Queries are Running in Parallel?

SQL SERVER – FIX – Property IsLocked is Not Available for Login

SQL SERVER – What are T-SQL Median? – Notes from the Field #090

SQL SERVER – Generating Meaningful Test Data with dbForge Data Generator for SQL Server

SQL SERVER – FIX – Server principal ‘Login Name’ has granted one or more permission(s). Revoke the permission(s) before dropping the server principal

SQL SERVER – Weekly Series – Memory Lane – #023

SQL SERVER – Pass One Stored Procedure’s Result as Another Stored Procedure’s Parameter

SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed.

SQL SERVER – Enable SQLCMD Mode in SSMS – SQL in Sixty Seconds #048

SQLAuthority News – World’s Largest IT Training Center

SQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB