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...
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...