|
|
OriginalGriff wrote: on Prime, delivered tomorrow - that's $36.95 including all taxes.
Ok, I believe we have a business venture.
Go ahead and order 10 copies of those and send them to me here in US.
I'll put them up on Amazon as new and we'll make a few $$ per.
|
|
|
|
|
Buy it for Kindle. Way cheaper
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Yeah I went to B&N the other day and found Practical PAcket Analysis[^] and it was $49.99 in store, I got it used on Amazon for $16 and change.
Everyone has a photographic memory; some just don't have film. Steven Wright
|
|
|
|
|
I often wonder how the bricks & mortar shops can sustain themselves under these conditions.
I hope they do though and I try to spend money at the local B&N to keep them going.
They do get good business for coffee, etc. and they are a great place to meet a relax a while with a beverage.
|
|
|
|
|
Over the years I've spent a lot of money at B&N because I can go in and physically scan the book and see if it's something I want and in that respect it's great. But the sharp increase in prices has made it financially difficult for me to pay those prices.
I too hope they continue to keep there doors open but I'm afraid they are going to fall by the wayside in favor of online book sales.
Everyone has a photographic memory; some just don't have film. Steven Wright
|
|
|
|
|
raddevus wrote: I often visit the local Barnes & Noble
Who are they? I remember hearing that name at some point, I thought they'd gone out of business. Weren't they something called a "bookstore" that I vaguely remember my father taking me to when I was a kid? Maybe that was something called a "library." And they have technical books? Wow! Are they written on stone tablets?
|
|
|
|
|
Yeah, it really makes you wonder how much longer the old bricks and mortar stores will last.
I hope a long time. Maybe all retail will go online at some point.
Everything delivered by drones.
|
|
|
|
|
|
pffft, you call that a sand castle? this is a sand castle
They buy shoes, then they wear them! They make them sound old! Dairy! Dairy!
modified 20-Oct-19 21:02pm.
|
|
|
|
|
Stable Genius wrote: this is a sand castle But can you live in any of those?
Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.
|
|
|
|
|
I was doing a query on a table with 8.8 million records, joining to a table with 2.7 million records, and then joining to a table with less than 1000 records, I got an OutOfMemory exception.
In the grand scheme of things, this ain't a huge dataset. It's nice to know that SQL Server is such a delicate house of cards...
".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
|
|
|
|
|
Told you all, PostgreSQL is much better
|
|
|
|
|
Well, that depends. A JOIN would combine all records of each set in all permutations. It would probably crash anywhere. Even during the calculations phase, it may be holding a shyteload of data. Profiler, anyone?
Yet, I know you know better than that. If my fearless leader were handy (An amazing DBA), he'd know how to make things right.
My first guess would be do it in two steps. First the 1K with one of the tables into a temp table and then the other table with the temp table.
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 |
|
|
|
|
|
SSMS, or SQL Server?
SQL Server is fairly robust. SSMS is the delicate house of cards.
If I had to guess, I'd say that SQL Server ran your query, and returned a huge number of rows. SSMS tried to display all the rows in the default grid view, and fell over.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote:
If I had to guess, I'd say that SQL Server ran your query, and returned a huge number of rows. SSMS tried to display all the rows in the default grid view, and fell over.
I bet this is what happened. And if so, that query may be returning way more data that Mister Mustang expected.
|
|
|
|
|
If it were all done with simple joins, it would be in the neighborhood of four quadrillion records (give or take).
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 JOINs have crashed or brought to a crawl many a database server in the history of programming.
|
|
|
|
|
JOIN is a anti-pattern. Never JOIN!!
This is marked as Joke, ok?
|
|
|
|
|
NoSQL for the win?
|
|
|
|
|
Considering the number of times I've initiated or modified designs in order to make an object graph play nicely with a relational persistence mechanism...
It's a worthwhile question.
"Never attribute to malice that which can be explained by stupidity."
- Hanlon's Razor
|
|
|
|
|
I stand alone
I never JOIN
Free
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
In the bad guys voice from the Matrix (Agent Smith)...
As you can see, we've had our eye on you for some time now, Mr. Mustang. It seems that you've been living two lives. In one life, you're Mr. Mustang, software engineer for a respectable software company. You have a Social Security number, you pay your taxes, and... you help your landlady carry out the garbage. The other life is lived in computers, where you go by the hacker alias Outlaw Programmer, and are guilty of virtually every computer crime we have a law for. One of these lives has a future, and one of them does not. I'm going to be as forthcoming as I can be, Mr. Mustang. You're here because we need your help with a very large query. We know that you've been contacted by a certain individual: A man who calls himself SSMS. Now, whatever you think you know about this man is irrelevant. He is considered by many authorities to be the most dangerous man alive. My colleagues believe that I'm wasting my time with you, but I believe you wish to do the right thing. We're willing to wipe the slate clean. Give you a fresh start. And all that we're asking in return is your cooperation in bringing a known large data query issue to justice.
|
|
|
|
|
Took the afternoon off to get a head start on the weekend alcoholism?
|
|
|
|
|
I would like to say yes, but I don't drink anymore. No Nish, I am just insane.
|
|
|
|