May 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
Max Column

MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182

August 17, 2021
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL Server

Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.

Read More
query cost

Tuning Query Cost 100% – SQL in Sixty Seconds #181

July 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server

After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.

Read More
Specific Index

Queries Using Specific Index – SQL in Sixty Seconds #180

July 20, 2021
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL Index, SQL Server

The challenge I face is that often DBAs ask me to prove that indexes are really not used by queries. Let us learn about Queries Using Specific Index.

Read More
Read Only Tables

Read Only Tables – Is it Possible? – SQL in Sixty Seconds #179

July 9, 2021
Pinal Dave
SQL Video
SQL FileGroup, SQL in Sixty Seconds, SQL Scripts, SQL Server

After reading it, lots of people asked me if I can make a video on this topic. Of course, here we go, Read Only Tables – Is it Possible?

Read More
June 2021 Summary

June 2021 Summary for SQL in Sixty Seconds

July 1, 2021
Pinal Dave
SQL Video
SQL Performance

It seems that YouTube is now gaining more traction than text-based blogs. Let us see June 2021 Summary for SQL in Sixty Seconds.

Read More
sum

SUM(1) vs COUNT(1) Performance Battle – SQL in Sixty Seconds #177

June 29, 2021
Pinal Dave
SQL Video
Execution Plan, SQL Function, SQL in Sixty Seconds, SQL Scripts, SQL Server

Based on my recent two videos, I got lots of questions about SUM(1) vs COUNT(1) Performance Battle. Let us see that in today’s video.

Read More
Battle

COUNT(*) and COUNT(1): Performance Battle – SQL in Sixty Seconds #176

June 23, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server

COUNT(*) and COUNT(1): Performance Battle – which one is better for performance? I got this question after watching my previous video.

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

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

Go to mobile version