Any view in sql server filtered by date is very slow
In management studio 2008 R2 on Windows XP suddenly every view that I create and filter by Date is running very slow. For example on table of 10 rows, I filter by date and it takes 20 seconds to get the result. When I run the query on sqlquery window it is running fast. Same database on other computer working fast. Is it a problem with OS ? I reinstalled the sql server - no help. The query stuck during parsing stage - for example when I write >1/1/2017 on filter column of the view and it takes 30 seconds until I see result in sql pane.
At last I found a problem and the solution: Short date format in regional options in computer was set to format: dd/MM/yy. When I changed to dd/MM/yyyy - Date filtering started working fast. I guess, I changed it previously without seeing the impact.