SQL Top Archives - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

SQL SERVER – Techniques for Retrieving Random Rows

August 25, 2023

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Random, SQL Top

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

SQL SERVER – Top 1 and Index Scan

April 1, 2021

Pinal Dave

SQL Performance

Execution Plan, SQL Index, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Top

Scans are not always bad they are there because they are needed. Let us see a very simple demonstration about Top 1 and Index Scan.