Pinal Dave - SQL Server Performance Tuning Expert

What’s fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane.

SQL SERVER – How to Convert Month Number to Month Name

November 23, 2023

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function

Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.

SQL SERVER – Escape Single Quotes

November 22, 2023

Pinal Dave

SQL Tips and Tricks

Quotes

In this post, I’ll cover a few methods you can use to escape single quotes properly in SQL Server. The most popular is double single quotes.

SQL Puzzle – Retrieve the Unique Evens Under 10

November 21, 2023

Pinal Dave

SQL Puzzle

SQL Distinct

In that spirit, let me walk through a bite-sized SQL puzzle that helps reinforce some key concepts. Let us see Retrieve the Unique Evens Under 10 puzzle.