| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| When do you use SQL Profiler? | | 2 |
| How do you fine the performance tunning? | Accenture | 2 |
| What is the difference between DTS and SSIS? | Allianz | 1 |
| How do you know which index a table is using? | | 4 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 6 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| what is web server?
| Satyam | 3 |
| syntax for deleting the database in T SQL | | 3 |
| What is the difference between login and a user? | TCS | 5 |
| What is Deadlock? | Satyam | 2 |
| is there more the two primary key in a single table? | Systematix | 19 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 4 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| select empid empname from employee
What is the result for the about query? | | 3 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 6 |
| Difference between Function and Procedure-in general? | | 2 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
