Please will you post the actual execution plan (.sqlplan file) for your query when you run it against the full data set?

John

What is the exact name of the performance counter they're reporting on?

61 out of 64GB seems rather high - you need to leave some for the operating system,...

Please also post DDL for any indexes and constraints that you have on the tables.

John

So you want to exclude both rows?  Please add Thom's rows and mine (below) to your sample data and show us what would be your expected results.

INSERT...

Looks like a job for the LAG or LEAD function, partitioned by ContSeqNo.  Please post your table DDL in the form of a CREATE TABLE statement, your sample data in...

Search this site for a splitter function to split the string into individual elements.  Then convert each element to an integer - here's a page with a few...

Steve

You're probably going to have to reverse engineer it from the catalog views.  sys partitions is a good place to start.  You might even find someone who's done...

You haven't built your string properly, and like Sue said, you're not even executing it.  I don't know much about VB, so this is almost pseudo-code, but try this:

That isn't even going to compile, since you haven't declared @FirstName and @LastName.  Also, please post the definition of stored_procedure_to_be_exec_first_time_only.

Do you only want stored_procedure_to_be_exec_first_time_only to be executed once - ever? ...

Which stored procedure do you want to restrict to a single execution - the calling one, or the called one?  And what do you mean by "first Time", given that...