Thanks all.

GSquared, that's perfect. It is a field in a table storing XML, not a single XML doc that I'm working with. That probably would have been my next question,...

Well that certainly works, if I remove the record from T2 I get all records from T1, and if I put it back in I only get the one record...

What im trying to say is....

When T2 has no records, bring back all records from T1, else if T2 does have a records - only bring back records from T1...

Ok great. Thanks for the quick reply.

Cheers

Nick

Thanks.

So essentially what this means is that (if my understanding is correct) by not provisioning a certificate and just setting FORCE ENCRYPTION ON - that we're using a self...

John Mitchell-245523 (12/16/2011)

---

Beware - this will bite you if any row you are updating (call it table1) has more than one match in the table you are updating from (table2)....

UPDATE A

SET foreginer='yes'

FROM table1 A

INNER JOIN table2 B

ON A.PersdonalID = B.PersonalID

WHERE B.Nationality!='American'

Great article, thanks for the link 😀

I regularly look at our index usage stats (we rarely restart our production server) and on occasion identify what would appear to be an unneeded (either never used or maintenance...

I did see that post, but the msg we're getting out the application is:

System.InvalidOperationException:

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may...

Hi, no the server stayed up (and is still up) and is responding fine. We've not applied any updates.

You could try using one of the many "udf_Split" type functions that are freely available on the net, prob on here, and then once the string is split into rows...

Does the "nolock" table hint you're using in the select statement negate the isolation level in this case?

Is the update on table 2 part of a transaction that also looks at table1?

If you want to see whats running now, just run [sp_who2 'Active'] and look at the STATUS and CPU etc. To see whats been taking a while to run previously,...