SQL Server Interview Questions

These are the interview questions on SQL Server I have been asked during recent years.

1. What is the difference between Left Outer Join and Right Outer Join?


2. Table A has got 1 million records. Table B is that of same schema as that of Table A. Write a Stored Procedure to insert the records from Table A to Table B in the batches of 10000. Also, the procedure should be resumable.

3. How to get the third highest salary from Table Employee?

4. How to get data in ordered manner from SQL ? Is the data stored in ordered fashion by default?

5. What is the difference between Count(1) and Count(id) in SQL Server? Do they return the same results always?

6. What is the difference between Temporary table and Table Variable ? If I have a million rows to store to, what will be a better option ?

7. What is the difference between Global and Local Temporary Table?
















SSIS Interview Questions

1. Difference between Full Load and incremental load in SSIS?

2.





Comments

Post a Comment

Popular posts from this blog

Nested Loop Join There are basically three join mechanisms in SQL Server: i. Nested Loop Join ii. Hash Join iii. Merge Join The Nested Loop Join is chosen by the SQL Server when the tables being used are of the comparable sizes and is been the default join mechanism being used. It is non-blocking,  doesn't require equi-join, data to be sorted and doesn't use tempdb. It is mostly suited for inner joins between tables having relatively smaller inputs and having an index on the joining key. Select a.id, b.id from Table1 a inner Join Table2 b on a.id=b.id If we look at its execution plan, it will be using Nested Loop join. Also, In cases where we are having cross join between two tables mostly Nested Loop join will be used by the SQL Execution plan as it is a product join and produces N*M rows. In cases, if we add certain where clause to the Cross Join query to limit our results, Nested Loop Join might not be used. Basic Example: There is a table with fou...
Read more

Query Execution Plan - Basics

There are two types of Execution plan in SQL Server i.e. Estimated execution plan Actual execution plan Estimated execution plan is generated based on the statistics available for the SQL table columns and indexes. The estimated execution plan may differ from the actual execution plan as the latter is generated when the query is executed and depicts the execution mechanism followed by the server in order to generate the query in the best possible way (least time). Execution plan is the steps taken by the SQL server optimiser to reach the SQL query results in best possible way. We always have questions such as why our query is running slow, how we can reduce the time to execute the query. The query which is to be executed is submitted to the SQL Server, the query optimiser is responsible for parsing the query and generating the execution plan. When the query is submitted to the system, there are many underlying operation that are happening in the backend before the result is...
Read more