Who would have thought…
Linchi Shea reports that running stored procedures on SQL server without the Owner qualifier - as in dbo.xxx for example - can impact the performance of that server and database in drastic ways. Depending on which version of SQL Server you are running just adding an owner qualifier can get you anywhere from 5% to 30% better performance.
I know many developers (myself included) who like to remove the owner qualifier just for reasons of readability. Well… no more! From now on it stays.
Write a comment