May 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
The Two Doors, Two Guards Puzzle

SQL SERVER – The Two Doors, Two Guards Puzzle

July 28, 2023
Pinal Dave
SQL Puzzle
SQL Scripts

I came across a puzzle about “The Two Doors, Two Guards,” popularly known as the “Two Doors Riddle” or the “Heaven and Hell Riddle”.

Read More
CumulativeTotalCalculation

SQL SERVER Challenge – Cumulative Total Calculation

June 16, 2023
Pinal Dave
SQL Interview Questions and Answers
Challenge, CTE, Ranking Functions, SQL Scripts, SQL Sub Query

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.

Read More
File Latency

SQL SERVER – Script to List Database File Latency

June 7, 2022
Pinal Dave
SQL Performance
Disk, SQL DMV, SQL IO, SQL Scripts, SQL Server

Today, we will see a very interesting script to list database file latency. I use this script quite often in my Performance Health Check.

Read More
Find Owner

SQL SERVER – Find Owner of Database – Change Owner of Database

May 3, 2022
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

As there was no owner, it was not possible to open that database in the SSMS. We had to find Owner of the Database and change it later on. 

Read More

SQL SERVER – Sample Script for Compressed and Uncompressed Backup

March 21, 2022
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Scripts, SQL Server

I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Well, of course.

Read More

SQL SERVER – Script to Estimate Compression

December 15, 2021
Pinal Dave
SQL Tips and Tricks
Compression, SQL Scripts, SQL Server, SQL Stored Procedure

I had implemented Data Compression at my client Performance Health Check. Let us discuss how we can estimate compression.

Read More

SQL SERVER – Is Query from Cache? Execution Plan Property

December 2, 2021
Pinal Dave
SQL Server
Execution Plan, SQL Cache, SQL Memory, SQL Scripts, SQL Server

Well, of course, there is an easy way to know this and that is Execution plan property. Is there any way to know if the executed query is from cache or not?

Read More
1 2 3 4 … 318 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version