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
Recompile Stored

How to Recompile Stored Procedure? – Interview Question of the Week #260

January 19, 2020
Pinal Dave
SQL Interview Questions and Answers
Parameter Sniffing, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:

EXEC sp_recompile ‘NameofSP’

Let us read more about it.

Read More

What is TempDB Spill in SQL Server? – Interview Question of the Week #259

January 12, 2020
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Memory, SQL Scripts, SQL Server, SQL TempDB

When SQL Server uses TempDB when any query does not have enough memory to do its operation, it is called TempDB Spill. Let’s learn today.

Read More
Network Drive

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

January 5, 2020
Pinal Dave
SQL Interview Questions and Answers
Computer Network, SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve. 

Read More
copy files

How to Copy Files in SQL Server? – Interview Question of the Week #257

December 29, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Copy Files in SQL Server?

Answer: SQL Server 2019 has very interesting features that can make a life of DBA’s and Developers very easy.

Read More
admin rename

Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256

December 22, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: Can Admin Rename SA Account in SQL Server?

Answer: Yes, of course. The syntax for to rename SA account is very simple:

Read More
Execution Plan Operator

Why Execution Plan Operator Read More Rows Than Available? – Interview Question of the Week #255

December 15, 2019
Pinal Dave
SQL Interview Questions and Answers
Execution Plan, SQL Performance, SQL Scripts, SQL Server

Question: Why Execution Plan Operator Read More Rows Than Available?

Answer: Statistics.

Now let us learn detailed answer in this blog post.

Read More
Scoped Configurations

What is the Priority of Database Scoped Configurations? – Interview Question of the Week #254

December 8, 2019
Pinal Dave
SQL Interview Questions and Answers
Database Scoped Configurations, SQL CPU, SQL Performance, SQL Server, SQL Server Configuration

Question: What is the Priority of Database Scoped Configurations over Global Configuration at Server Level?

Answer: This is a follow-up question.

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

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

Go to mobile version