Variables, Literals, Procs and Stats

This post by US PFE Susan Van Eyck goes through considerations when developing stored procedures using local variables and literals, and their effect on the query plan / performance.   I ran across a very interesting blog post by Kendra Little this week about the perils of troubleshooting – or developing – stored procedure using…

0

Previewing file content

Windows Explorer is a common tool for anyone working in the Windows environment and sometimes being able to quickly view the content of a part of a file is all that is needed so enabling Windows Explorer Preview Pane can be quite useful. We can see below, the contents of the csv file selected on…