Note: To learn more about Performance tuning as a DBA skill, please read this article:Why SQL Performance Tuning is the Most Important Database Management Skill to Have Q1: As a SQL Server database administrator, what is the main tool that you can use to perform the SQL Server...
5. What is index in SQL? (90 % asked in every Interview Questions For SQL) Answer: “Index is optional structure associated with the table which may or may not improve the performance of Query” Indexes in SQL “In simple words suppose we want to search the topic in to book we go to...
11. We have a query which is running fine in development but facing performance issues at production. You got the execution plan from production DBA. Now you need to compare with the development execution plan. What is your approach? 12. How to manually allocate memory to SSRS service? 13....
In this article, we will discuss a number of questions that you may be asked when applying to a junior SQL Server database administrator (DBA) position. Note: To learn more about Performance tuning as a DBA skill, please read this article:Why SQL Performance Tuning is the Most Importan...
25 QuestionsSQL Performance Tuning Interview Practice with the Tricky SQL Queries Get an SQL compiler handy to start practicing with the below tricky queries. 1. Retrieve all employees and their departments, including those without a department. ...
Tracing the code is a crucial technique to measure its performance during the runtime. The different methods of tracing the code include: DBMS_APPLICATION_INFO DBMS_TRACE DBMS_SESSION and DBMS_MONITOR trcsess and tkprof utilities Watch this video about PL/SQL Interview Questions on YouTube: ...
Download the white paper on performance tuning SQL Server from Microsoft web site. Don't forget to check out sql-server-performance.com 5. What are the steps you will take, if you are tasked with securing an SQL Server? Again this is another open ended question. Here are some things you...
However, it’s imperative that you read all these SQL interview questions and answers. But you have to be equally strong in all areas of SQL such as PL/SQL, Normalization, Triggers, and database tuning. Hence, we suggest reading the below posts to complete the circle of your SQL intervie...
SQL Server Agent Interview Questions SQL Server DBA Performance Tuning Interview Questions SQL Server Replication Interview Questions More DBA Interview Questions SQL Server Developer Interview Questions Junior SQL Server Developer Interview Questions
SQL Server Performance Tuning Question 1- Name as many native SQL Server performance monitoring and tuning tools that you know of and their associated value. System objects - System objects such as sp_who2, sp_lock, fn_get_sql, etc. provide a simple means to capture basic metrics related ...