August 2016

TSQL – Make Excel Link In Output

August 4, 2016 | 0 Comments

Here is a situation I just came across (boiled down and simplified).  An end user was having to manually find a user id, navigate to an image folder, and [...]

TSQL – Get All Queries Currently Running

August 4, 2016 | 0 Comments

This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in action ebook. The output shows the spid (process identifier), the ecid (this [...]