Thanks Phil. I went through this article before.

Few Questions:

How the incremental load works/setup if there are multiple updates on the same row in a certain period. Any performance impact?

Should...

Thanks!

Thanks Gail. I've attached the table/index/function definitions.

Many thanks Ed. Very well explained!

Thanks, Please see the actual plan attached.

Tks. I've attached the sqlplan.

Thanks, this is for developer in a dev box.

Thanks a lot!

Thanks a lot!

Great thanks!

Thanks a lot Marie. That was so informative.

How should I handle when we deploy the packages from dev to another environment. Any best practices in that area. I...

Thanks Perry! That worked.

Thanks Gail!

User get a warning/error when alter existing table with these rights.

I've attached the screenshots of the warnings.

Thanks. I would like to exclude the following:

Drop database

Alter/Drop db files (ndf/ldf)

View/edit/drop users/roles

Deny permissions on certificates/symmetric keys