Whether or not you specify it explicitly, ANSI_PADDING setting is there when you create a table, and can have an impact on the performance of some queries. If you are not careful, it can even hurt performance big time!   Let’s demonstrate that with an extremely simple example.   Assume that you have this simple view with a UNION ALL ...