August 2022 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
Sum vs SubTotal

Excel – Sum vs SubTotal – SQL in Sixty Seconds #167

May 21, 2021
Pinal Dave
SQL Video
Excel, SQL in Sixty Seconds, SQL Server

Just like SQL Server, I work with MySQL, PostgreSQL, MariaDB, MongoDB, and Excel. Today we are going to see in excel which is about Sum vs SubTotal.

Read More
Configure MAXDOP

3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166

May 20, 2021
Pinal Dave
SQL Video
MAXDOP, SQL CPU, SQL in Sixty Seconds

We will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP. 

Read More
memory details

Get Memory Details – SQL in Sixty Seconds #165

May 19, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Memory

My blog post SQL SERVER – 3 Queries to Detect Memory Issues. Lots of people wanted me to create a video on this topic – get memory details.

Read More
Linux and Shutdown

CPU, Linux and Shutdown – 3 SQL in Sixty Seconds Video

May 17, 2021
Pinal Dave
SQL Video
Linux, SQL CPU, SQL Scripts, SQL Server

Last week, I had published 3 videos on CPU, Linux, and Shutdown. I received lots of good feedback on each of them and also got lots of questions.

Read More
Get CPU Details

Get CPU Details – SQL in Sixty Seconds #164

May 14, 2021
Pinal Dave
SQL Video
CPU Scheduler, CPU Threads, SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.

Read More
shutdown

Shutdown SQL Server Via T-SQL – SQL in Sixty Seconds #163

May 13, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server

I often see the command SHUTDOWN underutilized when it is about turning SQL Server services gracefully. Let us learn about it today.

Read More
SQL SERVER on Linux

SQL Server on Linux – SQL in Sixty Seconds #162

May 12, 2021
Pinal Dave
SQL Video
Linux, SQL in Sixty Seconds, SQL Server

I wrote a blog post SQL SERVER on Linux – Commands, lots of people asked me that I should create a video about it as not everyone has Linux.

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

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

Go to mobile version