SSMS, though I often use a high-end ASCII editor because it's much faster to fire up than an IDE and feels more responsive.

Since this was an emergency, I ended up altering the SQL CLR function to remove the new parameter, and that fixed the issue.  I still don't know why SSIS was...

The package is normally run by a Powershell script and I've never used VS to edit the file.  I just used Notepad++ since the changes have been so minor.  The...

We are using local files on the server.  That's what I inherited and there has been no compelling reason to change it.

I intend to find the absolute value of all waits for the same period and see what the % of signal waits amounts to to get a better feel for...

For what it's worth, I ran across your post while looking into the same issue and almost the same hardware.

I have no performance issues, so until I can discover a...