Oct 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
Pigeonhole

The Pigeonhole Principle: Bridging Mathematics and SQL

August 16, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog

Read More

SQL SERVER – Banker’s Rounding

August 15, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.

Read More
Pythagorean Triples

SQL SERVER – Stored Procedures to Check for Pythagorean Triples

August 3, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.

Read More
xirr

Calculating Extended Internal Rate of Return (XIRR) in SQL Server with T-SQL

July 14, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

The Extended Internal Rate of Return (XIRR) is a metric to calculate the annualized rate of return for a series of irregularly timed flows.

Read More
Quadratic Equations

Solving Quadratic Equations with T-SQL

July 13, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

I often find myself teaching mathematics to my daughter, and recently, she has been diving into the realm of Quadratic Equations.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version