Skip to main content
1 vote

Replace primary key with unique constraint and other clustered index to improve query performance without doubling table size

As mentioned in the comments by LoztInSpace, your primary key doesn't need to also be the clustered index. That is just the default (since most times it makes sense). But in a data warehouse ...
J.D.'s user avatar
  • 38.3k
1 vote

Database in recovery mode

I would start with: Restore database <db_name> with recovery If that is not working look at the "Current" "SQL Server Logs" and check for errors.
user63637's user avatar
1 vote
Accepted

sp_rename column and CDC

Is there a better way to solve this problem? No, at least not a simpler way, this is how CDC was implemented by design as discussed in What is change data capture (CDC)? - Handling changes to source ...
J.D.'s user avatar
  • 38.3k

Only top scored, non community-wiki answers of a minimum length are eligible