Blog Home Page - Page 366 of 831 - SQL Authority with Pinal Dave

Apr30

[Note from Pinal]: This is a 78th episode of Notes from the Fields series. What do you do when data is deleted accidentally or you are facing disaster? Well, there are plenty of the things, you can do, but when in panic quite often people make mistakes which just intensify the disaster. Database snapshot…

Apr29

SQL SERVER – Finding Tables with Primary or Foreign Keys

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

If you want to know if a table has a primary key or foreign key, you can find out this in many ways. Let us create these tables CREATE TABLE product_master ( prod_id INT PRIMARY KEY, prod_name VARCHAR(100), price DECIMAL(12,2) ) GO CREATE TABLE product_details ( prod_id INT, sales_date DATETIME,…

Apr29

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

Pinal Dave

SQL Tips and Tricks

GIDS, SQL Log, SQL Scripts, SQL Server

Last week it was wonderful to spend time at the GIDS conference to meet all the enthusiastic developers. Had fun preparing for the session and the number of people who walked to me and say they read this blog makes me really humble and motivated to write more. I love attending and presenting at these conferences because I get an opportunity to meet people and at many times able to answer real world problems. Let’s learn Script: Knowing Data and Log Files Are On the Same Drive.

Apr28

SQL SERVER – Collect and Analyze SQL Server Data Efficiently

Pinal Dave

SQL

Devart

dbForge Event Profiler is one of the most useful SQL Server “build-in” tools. The Profiler records data associated with various SQL Server events for further analysis. This data is stored in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose SQL Server relates problems. The tool allows you to view communications between a client and SQL Server, and gives you an insight into its internal performance. To take full advantage of its potential, download dbForge Event Profiler for SQL Server for free now. Let us learn about Analyze SQL Server Data Efficiently.

Apr27

SQL SERVER – Using “High Performance” Power Plan for SQL Server

Pinal Dave

SQL Performance

SQL CPU, SQL Server

A lot of times, I have seen DBA’s and administrators have their own startup tasks that they perform when rebuilding or bringing a new server online. Some of these practices are powerful and are mean to enhance performance of the box that you have bought. Recently, I was at a customer location looking at what a typical Admin was doing and this step of his caught my attention. I couldn’t stop myself from blogging this because it was a simple, powerful and yet less appreciated setting available on the Server. Let us learn Power Plan for SQL Server.

Apr26

Interview Question of the Week #017 – Performance Comparison of Union vs Union All

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Union clause, Union

Here is what I just learned from email. One of the very prestigious organization asks one of their candidate following questions – Question: If you have options to use Union or Union All – which one of the option will use keeping performance as a top most requirement for the query. Answer: Though…

Apr25

SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Random

You know that RAND() function in SQL Server generates a random float value 0 through 1 (excluding 0 and 1). Let us create the following dataset CREATE TABLE #random(no INT) INSERT INTO #random(no) SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 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 109 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.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

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.

Jun 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

SQL SERVER – Finding Tables with Primary or Foreign Keys

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

SQL SERVER – Collect and Analyze SQL Server Data Efficiently

SQL SERVER – Using “High Performance” Power Plan for SQL Server

Interview Question of the Week #017 – Performance Comparison of Union vs Union All

SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function

SQL SERVER – Recovering from Snapshots – Notes from the Field #078

SQL SERVER – Finding Tables with Primary or Foreign Keys

SQL SERVER – Script: Knowing Data and Log Files Are On the Same Drive

SQL SERVER – Collect and Analyze SQL Server Data Efficiently

SQL SERVER – Using “High Performance” Power Plan for SQL Server

Interview Question of the Week #017 – Performance Comparison of Union vs Union All

SQL SERVER – Generate Different Random Number for Each Group Using RAND() Function