| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| How can your resolve deadlocks? | IBM | 3 |
| What are primary keys and foreign keys? | | 3 |
| What is Deadlock? | Satyam | 3 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What is de-normalization and when do you do it? | | 3 |
| How to count the number of duplicate items in a table? | | 1 |
| Explain Trigger with an example?
| | 1 |
| where do you use Isolations?give me some exmpale? | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| What is normalization? | | 6 |
| What is the difference between the following two sql
statements
select count(*) from <tablename>
select count(col_name) from <tablename> | 247Customer | 2 |
| Difference between server.transfer and server.execute method? | | 1 |
| What are the different types of replication? How are they used? | | 3 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| Can you tell me the difference between DELETE & TRUNCATE
commands? | | 11 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |