MSSQL – Runaway Job, Missing Max Run Time for SQL Job (Tame Them…)

Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …

SQL: Joins and Where clause, a mix to be aware (Logical Query Processing Phases)

Hi, Recently I got engaged in a discussion, Which I feel the ones that really was an eye opener for me and some thing i thought trivial played an important role in my day today work. The conversation went as What is the effect of WHERE¬†clause in a (INNER/LEFT/RIGHT) join, if moved to ON clause Read More …