Answer Posted / vimal
dbcc traceon 302
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What are the difference between clustered and a non-clustered index?
Explain the various types of concurrency problem?
How would you use user_constraints table in DB?
How optimize sql query with multiple joins in sql server?
Explain error handling in ssis?
How to download and install sql server 2005 books online?
What is the difference between dropping a database and taking a database offline?
What is the function of inner join?
What is difference between count (*) and count 1?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are the different types of columns types constraints in the sql server?
How to create user defined functions with parameters?
Determine how to use the inserted and deleted pseudo tables?
What is entity data services?
What is meant by Active-Passive and Active-Active clustering setup?
