You can use dynamic SQL inside the stored procedure.

Staging tables can be heap apart from tables storing configuration data which is very less in size.

Learned something new 🙂

Very Nice question. Thanks

Simple one 🙂

Option 4 failed as there is no column orderstatus in table MySales:alien:

Refreshed replication knowledge

Nice question:-)

Easy one:-)

Simple One 🙂

Yes, I also thought same

Very Easy 🙂

Easy one:-)

Very easy

Here are some basic guidelines

1)Use clustered indexes on high-usage tables.

2)Avoid high row count SQL statements that can cause a table lock. For example, instead of inserting all rows from one...