|
I restarted simSSMSs and it performed the query without a problem - but it did take 35 minutes.
I took steps ( reduced the big table to 6.5 million rows and created a view that does the first join) and I got it down to 13 minutes.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
modified 21-Jul-18 7:56am.
|
|
|
|
|
I was going to point that out as well. Ultimately, SSMS is just a fancy front-end; the query itself is run elsewhere.
|
|
|
|
|
It was SSMS.
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
https://support.microsoft.com/en-us/help/2874903
sqlcmd Utility | Microsoft Docs[^]
You are using the wrong tool. Use this instead to execute your query. This is a known issue with SSMS.
Output your results to a text file, etc. if you want to work with the data outside the console.
|
|
|
|
|
Maybe you doing an "out join" or "full join"? It's a full 3-d matrix in this case ...
It is not needed in most cases since the data in jointing tables are most likely to be correlated (via foreign keys) so that an (inner, left, right) join is most like what one needed. In this case, the db-engine or midwares only have records of order ~few 10 million to deal with, instead of order 10^7 x 3*10^6 x 10^3 records, which is huge ...
|
|
|
|
|
Worst date ever?
A man's solution on how to handle having two dates with two women on the same night ended up with him getting a ticket to jail.
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
I would venture to guess that the "dates" he's really interested in will be in the jail, too. Later on he can make arrangements with the prison dating service. It's called "Drop the Soap"
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Yeah rape is hilarious. Let's laugh about rape.
|
|
|
|
|
If that's what floats your boat.
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
This one Could have gone better[^] as well.
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OT - What the *bleep* is a "godsister"?
|
|
|
|
|
A daughter of your Godmother or Godfather.
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I'm nearly 55 years old and I'd never heard the term until today.
|
|
|
|
|
Don't worry - it seems these days anyone can make that sort of sh*t up at any time.
|
|
|
|
|
dandy72 wrote: it seems these days anyone can make that sort of sh*t up at any time.
The correct term for that, as of NOW, is "worderize it"
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Now that's a winner.
Is that like how you can verb any noun?
|
|
|
|
|
There's an actual name for the complimentary process: gerund[^]
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Hah! I'm 60 next February, so you can't use the age excuse on me!
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
A Griffin, what else do you expect
|
|
|
|
|
I will endeavour not to take that personally ...
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
RickZeeland wrote: A Griffin, what else do you expect
Maybe I would've expected that sort of story from Quagmire. But not Peter.
|
|
|
|
|
Is an antidepressant a medicated insect?
Sent from my Amstrad PC 1640
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Is a feline pharmacist a caterpillar?
Sadly, although the content of the original post bugs you.
Asn't an antidepressant something used to squash (or sadden?) the sibling of one of one's parents?
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Considering the response you've gotten for today's presentation, perhaps you need some help[^].
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Hopefully, otherwise they get sad and commit insecticide?
|
|
|
|