Jan 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
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
Has DB Access

SQL SERVER – List Databases Where User Has DB Access

November 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

This is a very interesting function and it helps us to list databases where User Has DB Access. Well, it is pretty straightforward to know with the help of function HAS_DBACCES.

Read More

Get Current Time Zone – SQL in Sixty Seconds #187

November 23, 2021
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Scripts, SQL Server

Lots of people often ask me how to get the current time zone in SQL Server when I am working on Comprehensive Database Performance Health Check.

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

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

Go to mobile version