SQL Random Archives - SQL Authority with Pinal Dave

SQL SERVER – Techniques for Retrieving Random Rows

August 25, 2023

This post will explore various techniques to retrieve random rows in SQL Server and analyze their performance and randomness characteristics in depth.

SQL SERVER – Selecting Random n Rows from a Table

September 24, 2018

Pinal Dave

SQL Tips and Tricks

SQL Random, SQL Scripts, SQL Server

Every day I spend a good amount of time with different customers helping them with SQL Server Performance Tuning issues. Today we will discuss the question asked by a developer at the organization where I was engaged in Comprehensive Database Performance Health Check. The developers wanted to know if there is any way he can randomly select n rows from a table.

SQL SERVER – Simple Method to Generate Fixed Digit OTP Code Using Random Function

August 22, 2018

Pinal Dave

SQL Tips and Tricks

SQL Password, SQL Random, SQL Scripts, SQL Server

One of my blog readers sent me the following mail after reading my earlier blog posts about Random Function and OTP Code. Before you read the email, you can read those blog posts here, here, and here.

SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2

August 15, 2018

Pinal Dave

SQL Tips and Tricks

, SQL Password, SQL Random, SQL Scripts, SQL Server, SQL Server Security

I have previously written about Random Password before in the blog posts here, here and here. This blog is sent by James Curran, who has created the following generate random password stored procedure keeping the base of the original solution of Tim Cartwright. Thanks to both of this individual SQL Server Expert who has helped me to come up with a more robust solution for a random password.

SQL SERVER – How to Generate Random Password? – Enhanced Version

August 2, 2018

Pinal Dave

SQL Tips and Tricks

SQL Password, SQL Random, SQL Scripts, SQL Server, SQL Stored Procedure

Earlier last month, I posted an interview question – How to Generate Random Passwords in SQL Server? – Interview Question of the Week #181. Though, my efforts were honest my answer was not complete in that blog post. Thankfully, SQL Server Expert Tim Cartwright noticed the error in the blog post and decided to send me to follow up email with the accurate script to generate a random password.