| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is physical sort data and logical sort data in index? | | 2 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| What is Trigger? | Misys | 2 |
| What is a view? is View updatable? | IBM | 11 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| How will u get 5 years back record? | | 4 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 9 |
| What is a Stored Procedure? | | 7 |
| i need some interview questions on sql server developer plz
any onee send some links. | | 1 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| What is the difference between having and where clause? | | 4 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
