Sessions, Temporary Objects, and the Afterlife

Global temp objects drop automatically when Sessions end, right? But when do they end? Think you know? Are you sure?

Line-Continuation in T-SQL

Some (or maybe most?) languages and operating system command shells allow for breaking up long lines into multiple lines (i.e. lines separated by hitting Enter / Return). This is accomplished by ending a line with a particular character that indicates that the line is not ending. For operating system shells this means that the command… Continue reading Line-Continuation in T-SQL