May 2025 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
Fibonacci Series

SQL SERVER – Fibonacci Series with T-SQL

November 24, 2023
Pinal Dave
SQL Tips and Tricks
CTE, Mathematical Function, SQL Function

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.

Read More
The Flight Connection Puzzle

SQL SERVER – The Flight Connection Puzzle

July 31, 2023
Pinal Dave
SQL Puzzle
CTE, SQL Server

Today we are going to see another such puzzle – The Flight Connection Puzzle. This blog post is going to be really fun blog post.

Read More
topearner1

Finding Top Earners: A T-SQL Challenge in SQL Server

July 4, 2023
Pinal Dave
SQL Tips and Tricks
CTE, SQL Sub Query

The goal is to find the top three highest-paid (top earners) employees in each department and their corresponding department details.

Read More

SQL SERVER – Replacing a Cursor with a Common Table Expression

July 3, 2023
Pinal Dave
SQL Performance
CTE, SQL Cursor, SQL String

Let us learn today – How I was able to improve the query performance by replacing the cursor with a common table expression (CTE).

Read More
CumulativeTotalCalculation

SQL SERVER Challenge – Cumulative Total Calculation

June 16, 2023
Pinal Dave
SQL Interview Questions and Answers
Challenge, CTE, Ranking Functions, SQL Scripts, SQL Sub Query

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.

Read More
list all dates

SQL SERVER – List All Dates Between Start and End Date

January 13, 2021
Pinal Dave
SQL Tips and Tricks
CTE, SQL DateTime, SQL Scripts, SQL Server

We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).

Read More

SQL SERVER – CTE can be Updated

May 19, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CTE, SQL Scripts, SQL View
Today I have received a fantastic email from Matthew Spieth. SQL Server expert from Ohio. He recently had a great conversation with his colleagues in the office and wanted to make sure that everybody who reads this blog knows about this little feature which is commonly confused. Here is his…
Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version