what protocol both networks use? : Sql server database administration

1021

List out the differences between the clustered index and non-clustered index in sql server?

1057

What is it unwise to create wide clustered index keys?

1051

What is the difference between delete and truncate statements?

1132

What is a subquery in a select query statement in ms sql server?

1193

How does Report Builder support Analysis Services cubes?

158

What do you understand by a view? What does the with check option clause for a view do?

1068

Explain transaction server consistency?

1020

What is triggers and stored procedures?

995

What are the two modes of authentication in sql server?

1139

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

1030

Explain different types of Normalization.

1909

What is explicit cursors?

1134

Using the customer, and order table in northwind database, please write a query to produce xml?

1119

What is a trace frag?

1138