June 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

Using Stored Procedure in SELECT – SQL in Sixty Seconds #193

February 15, 2022
Pinal Dave
SQL Video
Ad Hoc Query, SQL in Sixty Seconds, SQL Server, SQL Stored Procedure

Today we are going to learn about how Using Stored Procedure in SELECT. However, the easiest method to run the stored procedure.

Read More
Date Variable

Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192

January 18, 2022
Pinal Dave
SQL Video
SQL DateTime, SQL Function, SQL in Sixty Seconds, SQL Performance

However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.

Read More
database file

Most Used Database Files – SQL in Sixty Seconds #190

January 6, 2022
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL IO, SQL Server Files

If the client has multiple databases, this script helps to find out which database files is the most used. Let us learn today.

Read More
Optimize DATE

Optimize DATE in WHERE Clause – SQL in Sixty Seconds #189

December 29, 2021
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Performance

During Comprehensive Database Performance Health Check, I often get questions about how to Optimize DATE in the WHERE Clause.

Read More
Compression for Performance

Data Compression for Performance – SQL in Sixty Seconds #188

December 16, 2021
Pinal Dave
SQL Video
Compression, SQL in Sixty Seconds, SQL Performance, SQL Server

Earlier I wrote a blog post about how Data Compression for Performance can help improve the efficiency of SQL Server.

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
memory pressure

Detecting Memory Pressure – SQL in Sixty Seconds #186

November 17, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Memory, SQL Scripts, SQL Server

Lots of people who watched the video also asked me to build a similar video. Let us see today a video where I explain how to detect memory pressure. 

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

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

Go to mobile version