I answered 1 for one simple reason - the test case does not have the correct answer and number one is the closest - is is going to return partially...

sa is a tabu for remote connections (password goes as open text if there is no forced network encryption). a dba has to have a good reason to make me...

yes. dynamic sql in sp works as well. wery easy to test.

primary keys on staging tables with hight data load activity and short processing wind are questionable too. clustered index takes time to build/rebuild

The most misused index is the clustered index. When creating a primary key on a table, SQL Server automatically (and erroneously) clusters it, but because no two records will contain an...