This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A fitted guide locates one vessel while the surrounding tray remains preserved.

SQL SERVER – Delete Statement and Index Usage

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

An index can help a DELETE statement locate rows to remove. A customer asked whether indexes benefit modifications alongside SELECT queries.

Read More
An open wooden cabinet holds organized rolls of material with one vermilion roll

Where are SQL Jobs Stored? – Interview Question of the Week #293

September 13, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Server Agent

Question: Where is SQL Jobs Stored?

Answer: In MSDB Database in dbo.sysjobs table. Let us learn about it in today’s blog post.

Read More
nonclustered primary

Nonclustered Primary Key – SQL in Sixty Seconds #119

September 7, 2020
Pinal Dave
SQL Video
Primary Key, SQL Constraint and Keys, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server

I will describe in detail a bit later on during this blog post. Today we are going to learn that it is possible to have a nonclustered primary key. 

Read More
Ash and a remaining ember indicate a recent fire without revealing its complete history

When was Stored Procedure Last Compiled? – Interview Question of the Week #292

September 6, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Cache, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: When was Stored Procedure Last Compiled?

Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.

Read More
Gouache painting of a telescope on a harbor wall watching one vermilion sailboat move among anchored boats

Watch a Running Query: Live Plan From Activity Monitor

September 2, 2020
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Activity Monitor, SQL DMV, SQL Scripts

To watch a running query, open Activity Monitor in SSMS 22, find the query in Active Expensive Queries, and open its live execution plan. It also shows the settings that older versions need and a T-SQL query that reads the same facts.

Read More
Stock remains visible inside a small shop whose glass door is closed

What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291

August 30, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Error Messages, SQL Index, SQL Scripts, SQL Server

Question: What Happens If the Clustered Index is Disabled?

Answer: If you disable the clustered index, you can’t retrieve data from the table.

Read More
Who Dropped

Who Dropped Your Table? – SQL in Sixty Seconds #112

August 28, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Reports, SQL Scripts, SQL Server, SQL Server Security

Who Dropped My Table? – I was recently asked this question in Comprehensive Database Performance Health Check. Let us learn about it today.

Read More
Previous 1 … 31 32 33 34 35 36 37 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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