July 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
STRING-AGG-Function

SQL SERVER – STRING_AGG Function to Concatenate Strings

July 21, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String

We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.

Read More
generate series

SQL SERVER 2022 – GENERATE_SERIES Function

July 20, 2023
Pinal Dave
SQL Tips and Tricks
GENERATE_SERIES, SQL Function, SQL Server 2022

Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.

Read More

SQL SERVER – Monitoring Database Autogrowth Settings

July 19, 2023
Pinal Dave
SQL Performance
autogrowth, SQL Server Configuration

Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;

Read More
complex password

SQL SERVER – Generating Complex Passwords with T-SQL

July 18, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Password

The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.

Read More
password policy

SQL SERVER – Setting up a Robust Password Policy

July 17, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Configuration, SQL Server Security

Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.

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
Previous 1 … 17 18 19 20 21 22 23 … 828 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version