Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 SSRS: 1. How to render a report to a user email? 2. How to join two dat...
A: Based on the available SQL Server statistics and the workload performed on the SQL Server, the SQL Server Query Optimizer will provide us with a suggested index, that may improve the performance of the submitted query in a calculated percentage. So, it will display that index as a recomm...
Using the NOLOCK query optimiser hint is generally considered good practice in order to improve concurrency on a busy system. When the NOLOCK hint is included in a SELECT statement, no locks are taken when data is read. The result is a Dirty Read, which means that another process could be...
A stored procedure is a named group of SQL statements that have been previously created and stored in the server database. Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data. And when the procedure is ...
14. How can you improve the performance of a slow query? Answer: To improve query performance: Use indexeson frequently queried columns. Optimize joins: Avoid unnecessary joins and subqueries. Rewrite subqueriesas joins where possible. Limit data: Only select the necessary columns, not SELECT *....
Q8: You are working as a database administrator in an international company. You are trying to enhance the performance of the application that is connecting to the SQL Server instance by controlling the parallelism behavior of the queries. This can be achieved by tuning the Max Degree of Parall...
Top 30 SQL Server Interview Questions (2024) This comprehensive guide provides a curated list of SQL Server interview questions and answers, covering topics from basic concepts to advanced techniques, to help you prepare for your next data-related interview. Kevin Babitz 14 min blog Data Science ...
Indexes are database objects that help improve the performance of theSQL SELECTquery on a table. Typically, an index contains keys built from one or more columns in the table or view. These built keys are stored in a structure (B-tree) in the database server’s physical memory. It enabl...
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 could talk about: Preferring NT authentication, using server, database and ...
Performance object: SQL Server:Memory Manager Counter: Total Server Memory (KB) Q. What is theoption”Lock Pages in Memory”? Ans: Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. By ...