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
swap columns

Swap Columns – SQL in Sixty Seconds #199

August 2, 2022
Pinal Dave
SQL Video
SQL Column, SQL in Sixty Seconds

Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.

Read More

Find Database File Latency – SQL in Sixty Seconds #198

June 15, 2022
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL IO, SQL Performance, SQL Server Files

Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.

Read More
Indexing for Delete

Indexing for Delete – SQL in Sixty Seconds #197

May 13, 2022
Pinal Dave
SQL Video
SQL Index, SQL Performance, SQL Server

Today, we will see another interesting topic where the index affects the delete statement. Let us start watching the video Indexing for Delete. 

Read More

Compressed Backup and Performance – SQL in Sixty Seconds #196

April 12, 2022
Pinal Dave
SQL Video
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server

I was recently asked if I have a handy script that can help us take compressed backup and uncompressed backup. Backup and Performance

Read More

Monitoring Your Database Servers: 3 Features You Should Know About

March 16, 2022
Pinal Dave
SQL Video
Redgate

What are the key things you should look at on your servers to ensure? 3 important features for Monitoring Your Database Servers.

Read More

Find Missing Identity – SQL in Sixty Seconds #195

March 3, 2022
Pinal Dave
SQL Video
SQL Identity, SQL in Sixty Seconds, SQL Server

Today, we will discuss a very interesting topic about how to find missing identities from our database table. I have previously blogged.

Read More

Remove Key Lookup – SQL in Sixty Seconds #194

February 21, 2022
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Performance, SSMS

Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.

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

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

Go to mobile version