Reply
Member
Posts: 1
Registered: ‎02-04-2021

SP organization best practice

Looking for some guidance on best practices for organizing stored procedures. I have a stored proc that moves data from staging DB to a data warehouse and am wondering if it's best practice to put that stored proc in the staging DB or in the data warehouse DB?