What are best practices when developing (many) stored procedures on SQL-Server Management Studio?
I have a stored procedure running in Microsoft sql server. It runs fast when there is a filter condition and runs slow when there isnt any. Why?