| Other SQL Server Interview Questions |
|| Asked @
|Can store procedure call by user define function in SQL
|I have Two table First have UserName and second is address,
in address table more than value relegated to UserName
table, i want to fetch 2nd address if exist other wise 1st
|Accidentally i deleted my table. How can i get that table?
|What is sorting and what is the difference between sorting
and clustered indexes?
|What is transaction ? Give me one example.
|What are the four main query statements?
|WHAT IS DIFFRENCE BETWEEN TRUNCATE AND DELETE STATEMENT
|how to improve the speed of SQL database server and how to
avoid dead lock?
|A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query?
|What about UPDATESTATISTICS ?
|wht is normalization?can u explain me in detail?
|What is a Trace frag?Where can we use this?
|For more SQL Server Interview Questions Click Here |