Create a new table on database A to hold database B's data: host name, OS info, etc.  For the sake of argument, let's say the new table is named "ip_details". ...

Are you licensed for all the CPUs?  At one time, the affinity mask was used to run on machine that had more processors than you were licensed for, by cancelling...

Not easily, no.  With the current query,for example, we have no way of knowing which row is the last pax.

Btw, you should truncate not round, or you will...

This is relatively straightforward (the difference between start time and end time, for selected hours only), but you'll need to post directly usable data.  That is, CREATE TABLE and INSERT...

The "standard" way to do that is to make sure the key doesn't already exist in the table to be insert to.  If you need to, delete dups from the...

The table's already clustered by [TRANSACTION_TIME].  That's fantastic, it'll make your job so much easier.  We'll just want to increase the fill factor from 90 to 99 for the historical...

Need to see the definitions of indexes too, especially for the clustered index (or pk, as that will be the clustering key unless you explicitly say it isn't).

You...

Is(are) there any index(es) at all on this table?  If not, you'll definitely want to "create a brand new table to insert into while the old table data is being...

What you've stated and shown is contradictory.  Is transaction_time a "string", as you stated, or a datetime, as your code shows?

Assuming it's a datetime, you don't really need...

Below is a re-coded version of the stored proc.  It does the UPDATE of IsUsed inline, to reduce (eliminate?) chances of two near-same-time execs of it getting the same NextID...

1) How is clustered?  By ( Col, Col1) or something else?

2) How is normally searched?  By ( Col, Col1 ) or by something else?

3)...

INSERT INTO dbo.exportLogTable
SELECT
  ...list_of_all_columns_in_table...
FROM (
  SELECT *, ROW_NUMBER() OVER(PARTITION BY tableID ORDER BY tableID) AS row_num
  FROM dbo.exportLogTable2
) AS elt2

Not a good idea.  A direct SELECT ... INTO new_table can cause system table locking and can cause concurrence issues.  You should...