I was told to query against views in our ERP system because this would prevent any locks put on the actual tables thus blocking actual work being done. After learning a bit more about SQL Server, I'm not sure this is accurate but wanted to get clarification.
Knowing that a view is just a “saved query”, it appears I'm querying the base table via the view so it would seem this wouldn't accomplish anything as far as preventing blocking.
In other words if I do the following and leave these open, am I understanding that either one would block sales table writes?
begin trans select * from dbo.view_sales
begin trans select * from dbo.sales