| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is advantages in sql 2005 over sql 2000? | | 1 |
| difference between sql server2000 and sql server2005
| | 1 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| What is bit datatype and what's the information that can be
stored inside a bit column? | | 1 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| About Indexed Views? with example?
plz reply... | | 1 |
| how to rest identity columns in sql server | Matrix | 2 |
| how to generate XML out of QUERY? | McAfee | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 1 |
| How will u get 5 years back record? | | 3 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| How can your resolve deadlocks? | IBM | 3 |
| Wht is SQL Injection Attack ? | | 1 |
| Define candidate key, alternate key, composite key. | | 5 |
| I have a huge amount of data which is displayed in a
report. The data is viewed every day. Every day the data is
displayed in 30 secs but suddenly today it is giving an
timeout message today. Data has not been changed. The
situation is same as yesterday. What might be the reason???
Please Answer. | Satyam | 3 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| what is the cursor life span? | Evalueserve | 5 |
| |
| For more SQL Server Interview Questions Click Here |