I'm trying to understand relative sizing for design conversation purposes. For example, in this context, would it be reasonable to state that?:

* Selecting 1 row from 1 table with...

Any downside to using the following query to get elapsed time of the last sproc exec,

where object_id represents the object_id of the sproc under test?:

select last_elapsed_time, *

from sys.dm_exec_procedure_stats

where...

Thanks SSC. I tried using SET STATISTICS TIME ON per your recommendation. The particular sproc I'm trying to measure returns 11 result sets so SSMS is returning stats for...

too much overhead I was wondering if there was a simple way

The Dixie Flatline (8/21/2016)

---

If your application can handle getting two result sets, I'd go that way.

You do have a column that can associate the perms with their...

If you're coming from C#, Java, Javascript then the underscores would look hokey and less readable....

yeah I was introduced to the NounVerb way of doing things about 10 years ago. These names were generated automatically by a tool. That particular naming convention really...

why hand-code that which can be automated?

There are tools which automate the generation of sprocs for a given database. At least 1 of these tools generate sprocs using the naming convention I mentioned.

Can you describe any specific scenarios where not having the "go" keyword will cause the SSMS batch to fail?

oh right. thanks for refreshing my memory on that. it's been a while.

I posted a separate thread and table variables don't provide additional debugging capabilities using the SSMS debugger unfortunately.

What are the main benefits of using table variables over temp tables? ...

it's a one-off report with 2 levels of nested foreach logic

ok I'll include an id in the result set and go through the while loop using select max(id).

My question is more specific: For a given result set in a temp table, will "select top 1" and "delete top 1" operate on the same row in a...