I will go with B and C. As it is joined with the primary table frequently, it should have a non-clustered index to enable faster search and as it joins to a primary key, it should generally not be null. A, D and E does not make sense to me....

In case of Unix, the interface between 2 “functions” is a text. Where as, in case of Powershell, it is objects that gets passed along. Powershell is working behind the scene to convert output objects of one type to input of object of another type where...

It seems that the stored proc resolver should be used where the processing can be done within the domain of SQL and where, SQL engine can be used efficiently. If for example, the resolver has to do complex string manipulations where CLR has advantage, w...

I suppose it is better to maintain/keep at least 1 connection open to improve performance....

This is my conceptual/theoretical understanding. I have not validated this against a real life scenario. 1. The primary server will continue to work normal as the logs are applied to Mirror asynchronously. 2. Because a witness has not been set,...

We are using sparse columns where there are many potential nulls value but, the columns are not generally used in the where clause....

First to the business, I will define what is index and how it is useful in organizing data. I will probably use the book index example. Probably give a preview to simple storage structure using B-Tree. Then, define the terms as below : 1. Inde...

Prefer to go with XQuery for any large or complicated XML processing. If the data is smaller, OPENXML can be used as it is simpler to handle for Database professionals....

I will recomend to go with Merge. I am not sure how will the first option needs to be set up when there are multiple peer to peer replications need to be set up. I suppose, very purpose of the Merge replication is to maintain updates to the same data be...

Sorry guys, I am little confused by this question so, edited my answer couple of times. But, thinking little more again – why would anyone install SQL 32 bit on 64bit Windows anyway J . Sorry, I just had to ask – hope it is not a trick question. Thank...