The most recent content from our members.
I would like to be able to return more than 2 fields from a custom stored procedure. There are situations where information being returned, can be very helpful in issue resolution. One example that may already be out there and solved, but for the sake of the discussion is blocked processes / dead locks. I can write a…
Hi folks, I would like to look up a stored procedure in the DPA repository to see if it exists and if so, look at the analysis done by DPA. How do I find a stored procedure name in the repository to see if it's been captured by DPA and if so, what the hash value is so I can plug it into the DPA activity URL? Thanks,…
Hi folks, I recently stumbled upon a query whilst analyzing our database. I ended up making some tweaks to the underlining index taking it from 2000+ reads to 8 reads, speeding up the query significantly (it's a high execution stored procedure). Now when I look at the historical trend chart for this stored procedure it's…
It looks like you're new here. Sign in or register to get started.