June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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
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…
Read More

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.

Read More

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…
Read More