Blog Home Page - Page 17 of 828 - SQL Authority with Pinal Dave

Oct 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Aug25

SQL SERVER – Techniques for Retrieving Random Rows

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.

Aug24

SQL SERVER – Checking If a Column Exists in a Table

SQL Tips and Tricks

Information Schema, SQL Column, SQL Table Operation, System Object

Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects

Aug23

Navigating SQL Server CPU and Memory Usage Woes

SQL Tips and Tricks

Idera, SQL CPU, SQL Memory

SQL Server is a powerful database management system, it can encounter performance issues related to CPU and memory usage.

Aug22

SQL SERVER – Scripts to Retrieve Column Names

SQL Tips and Tricks

Computed Column, SQL Column, SQL DMV

Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.

Aug21

SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly

SQL Tips and Tricks

SQL Log, Transaction Log

Providing a comprehensive understanding of their role and potential issues. Let us learn about Transaction Logs: The Good, The Bad, and The Ugly.

Aug18

Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis

SQLAuthority News

Idera, SQL Index, Webinar

The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.

Aug17

SQL SERVER – Unique Indexes on Nullable Columns

SQL Tips and Tricks

SQL Index, SQL NULL

As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.