Tag: Processing

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

Posted onLeave a comment

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)

Posted onLeave a comment

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 …