Timeline for Updating a local table with a per-row count(*) which is an aggregate of inner joins on remote server
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 29, 2022 at 8:02 | history | edited | Glorfindel | CC BY-SA 4.0 |
broken link fixed, cf. https://meta.stackoverflow.com/a/406565/4751173
|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Sep 20, 2013 at 3:15 | comment | added | beeks | @Billinkc, thanks. After not being able to access a global temp table from a linked server, I went rogue and created one on ServerB to be quickly snapped up and dropped. The DBA's would be pissed, but it was worth it to see disk reads spike over 1gigabyte/sec ;) | |
| Sep 20, 2013 at 3:14 | vote | accept | beeks | ||
| Sep 20, 2013 at 2:25 | comment | added | beeks | Just kidding on the token ring ;) Just 1gig Ethernet. | |
| Sep 20, 2013 at 2:23 | comment | added | Hannah Vernon♦ | "Token Ring" - jeebus it's been a long time since I've seen that tech! | |
| Sep 20, 2013 at 2:17 | comment | added | beeks | Billinkc, thank you for your very helpful comment. I have to do some reading on OPENQUERY() as that's new to me. The file structure on ServerB is frustratingly complex (36 mounted volumes peppered inside 8 logical drives) but I think we recently allocated a terabyte to tempdb on its own volume. Space is much more limited on ServerA though. Perhaps if I order both the global temp table and the destination table on Package_UUID ascending, I could do a merge update? Another topic to read up on. Servers are connected via token ring. I mean, both servers are in the same datacenter.:) | |
| Sep 20, 2013 at 1:43 | history | edited | billinkc | CC BY-SA 3.0 |
Thought there was a good dba question on the subject but can't find it. CSS will just have to do ;)
|
| Sep 20, 2013 at 1:35 | history | answered | billinkc | CC BY-SA 3.0 |