| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Difference between sql server 2000 and sql server 2005?
| Satyam | 4 |
| What is database normalization? | Digicel | 5 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| What is the use of DBCC commands? | | 1 |
| What is the purpose of using COLLATE in a query? | | 1 |
| 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 the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| How to tune a stored procedure? | | 5 |
| Which virtual table does a trigger use? | TCS | 6 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| internal language used in sql server 2000? | | 1 |
| can primery key be a non clustered index? | | 8 |
| What are functions | | 3 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| What does the INSTEAD OF trigger do? | | 3 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE? | Yardi-Software | 4 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| How the data stores in a page? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
