Chad Callihan compares local versus global temp tables:
Have you ever noticed a temp table with not one but two pound signs in front? Let’s take a look at the differences between ##Temp and #Temp.
Global temp tables have some interesting properties to them, especially when they’re combined with linked servers. “Interesting” here probably means “evil” but sometimes, we are the baddies.