OK, to more clearly show what I'm seeing I wrote the following code.  I just find it odd that in the first example you can see that the table already...

Actually, I don't need the global temp tables because I want them to be specific to a connection/session.  I just found it odd that there was no error thrown when...

Great. Thanks.

thanks, I understand that. I'm asking if server 1 can contain 2 separate certificates. The original one for server 1 as well as the server 2 certificate. ...

Interesting read. I may be experiencing heavy blocking and misspoke by saying deadlock. Basically I have a fairly high transaction system where I'm also running a heavy reporting...

I'll look into those other options. I'm trying to avoid some deadlock errors in a heavy-reporting process.

Thanks, as always, for the help

ST

I was surprised at the difference with only one entry but it was significant enough to investigate. The procedure/query will always use between 1 and 200 values so we've...

Please try the following. I haven't tried it but I've used a similar approach in other queries.

Select Items, Qty From Table1

Where

QTY >

-- This can be simplified...

Thanks for the responses. I always appreciate the expertise.

ST

Yes, the index supports the query. Unfortunately the example is too far in the weeds to send an execution plan. It's just a curiosity.

On a related note, what...

Thank you!

ST

Thanks for the responses.

In our organization we are required to change passwords every N days. I'm not finding clear guidance on this. Should I generate a new certificate...

Thanks, Gail. Final question. There are plans for both servers to use TDE. Once this is done, I'll need to restore a backup from server A to...

Thanks

Can you suggest a different view? I'm monitoring the activity on the server to see how many connections there are and the state. I'm tracking down a connection...