In short, the filter placement could change the query results if the query uses an outer join. Left (right) outer joins add back non-matching rows from the left (right) table after the ON filter. A row might match the ON…
SQL Server
A collection of 4 posts
Use Temp Tables in SSIS
I used to loathe building data sources with temp tables. That is until I learned how to 'trick' SSIS with a simple work around. Here is our data flow. Here is the source query. The use of a temp table…
Auditing Failed Logins
SQL server will by default write failed login attempts to the database error log. It's not only important to review failed login attempts for security reasons but also they are sometimes a symptom of another problem. One of the problems…
Troubleshooting Client Connection Issues
During new system installs I'll sometimes run into database client connection issues. Nine times out of ten the issue boils down to configuration at one of these points: * Firewall * Protocol Settings * SQL Browser Service The following client error messages all…