| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain some DBCC commands? | | 3 |
| What value could be assigned to Varchar Type? | | 2 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 16 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| What is a trigger? | | 3 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 2 |
| What is the system function to get the current user's user
id? | TCS | 2 |
| What about UPDATESTATISTICS ? | Intelligroup | 1 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| Explain fundamentals of Data ware housing & OLAP? | | 1 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| Which is best Subquery (or) joins in sql server? explain why | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| Explain sp_configure commands, set commands? | | 1 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| wht's the differece between sqlserver05 and sqlserver2000 | | 3 |
| |
| For more SQL Server Interview Questions Click Here |