May 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
drop statement

Multi Tables – 1 Drop Statement – SQL in Sixty Seconds #134

October 16, 2020
Pinal Dave
SQL Video
SQL Delete, SQL in Sixty Seconds, SQL Scripts, SQL Server

It was taking time as well as require to write them one at a time. In today’s blog post we will see how we can drop multiple tables with a 1 drop statement. 

Read More
delete

Remove Trigger for Delete – SQL in Sixty Seconds #133

October 13, 2020
Pinal Dave
SQL Video
Output Clause, SQL Delete, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Trigger

I am involved in the Comprehensive Database Performance Health Check. Today we will discuss how we can remove triggers for the Delete statement. 

Read More
Deleted Rows

How to Capture Deleted Rows Without Trigger? – Interview Question of the Week #297

October 11, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Delete, SQL Performance, SQL Scripts, SQL Server, SQL Trigger

Question: How to Capture Deleted Rows Without Trigger?
Answer: I was recently asked by my client during the Comprehensive Database Performance Health Check.

Read More
delete statement

SQL SERVER – Delete Statement and Index Usage

September 17, 2020
Pinal Dave
SQL Performance
SQL Delete, SQL Index, SQL Scripts, SQL Server

The client wanted to know if the index help with the DELETE command as well. The answer is yes, Indexes do help with the DELETE statement.

Read More
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version