March 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
Volume Mount Point

How to Get Volume Mount Point for SQL Server Files? – Interview Question of the Week #295

September 27, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Scripts, SQL Server

Question: How to Get Volume Mount Point for SQL Server Files? 

Answer: I was asked this question by my client during the recent Health Check.

Read More
FORCE-DEFAULT

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

September 21, 2020
Pinal Dave
SQL Interview Questions and Answers
c, Cardinality, Query Hint, SQL Scripts, SQL Server

One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works

Read More
Temp stored procedures

What is Temp Stored Procedures? – Interview Question of the Week #294

September 20, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure, SQL TempDB, Temp Table

Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.

Read More
Jobs Stored

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

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

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
Last Compiled

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
Index is Disabled

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
Insert Multiple

How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290

August 23, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Scripts, SQL Server

Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? One of the most popular questions, I often receive from my client.

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

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

Go to mobile version