| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is row by row processing ? | | 1 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| what is a cursor and what is its use? | | 1 |
| What is Covering Indexes?
Plz explain with example | | 2 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |