« first day (1212 days earlier)      last day (3655 days later) » 
00:00 - 19:0019:00 - 22:00

ypercube
ypercube
12:16 AM
Strange. I see only 1.
 
FreshPhilOfSO
FreshPhilOfSO
0
Q: Review queue oddness

FreshPhilOfSOThere are currently 55 questions in the close queue on DBA.se - Many are old, and it all seems a bit weird that old questions now have 4 out of 5 close votes. http://dba.stackexchange.com/review Has a user been deleted, thus causing the number of close votes to revert back to 4 from 5 for these ...

support vote-to-close
Edited the question with what I see
Something's obviously gone tits-up
 
Paul White
Paul White
1:16 AM
Looks like it. I have a notification flag that there are 64 suggested edits waiting, but zero in the queue.
 
FreshPhilOfSO
FreshPhilOfSO
1:33 AM
@PaulWhite So dba.stackexchange.com/review doesn't show anything?
It's 30 days since I changed my name. Reckon that may have buggered things? Some crappy batch job got rid of all my close votes?
 
Paul White
Paul White
@FreshPhilOfSO Exactly. Zero waiting for review, brown flag for 64 suggested edits waiting for review. Borked.
 
FreshPhilOfSO
FreshPhilOfSO
Bet it's me that's broken it then. I've edited the meta question accordingly
 
Mike Fal
Mike Fal
@FreshPhilOfSO Probably an Oracle bug, better file something on Metalink
 
FreshPhilOfSO
FreshPhilOfSO
@MikeFal More likely to be a NOLOCK problem in the SO code :P
 
FreshPhilOfSO
FreshPhilOfSO
2:05 AM
24
Q: Notify users of possible reviews on toolbar

MichaelTI am under the impression that increased participation in the review queue is, on the whole a good thing. It encourages people to feel an ownership in the community and partially responsible for the site as a whole. On Programmers.SE, I've seen what I believe to be an uptick in flagging to clos...

feature-request status-completed review top-bar usability
See the top answer there
Oh. Terrible. Will drive me mad having a number there I can do nothing about at a certain point in time. — FreshPhilOfSO 12 secs ago
"Thank you for reviewing 20 close votes today; come back in 21 hours to continue reviewing.". Nooooooooooooooooo. The counter won't disappear!
 
Simon Righarts
Simon Righarts
2:45 AM
@PaulWhite by the way, on Saturday I'm out in Miramar until 4:30ish refereeing a soccer game - did you particularly want to catch the early game or should we plan on meeting up about 7ish and grabbing some food and a beer at a bar somewhere? I think @MikeFal's plan involves renting a car and going to Martinborough at some point, so later may be better for him
 
Mike Fal
Mike Fal
@PaulWhite @SimonRigharts I'm open for whatever. Martinborough will probably wait until Sunday, so I'm open for Saturday and whatever works for people.
 
 
4 hours later…
Paul White
Paul White
7:04 AM
@SimonRigharts I was thinking evening time, yes.
 
gbn
gbn
@FreshPhilOfSO I will pitch in and administer the coup de grace
 
Paul White
Paul White
@gbn I'm confused. The number alerts have been there for a while (for 10K) but they usually reflect the number of items actually in the queue. Why the sudden disparity today?
 
gbn
gbn
@PaulWhite I dunno. I've not been following events here for a while
 
Paul White
Paul White
Any mods around?
 
 
1 hour later…
FreshPhilOfSO
FreshPhilOfSO
8:38 AM
 
 
1 hour later…
Paul White
Paul White
10:06 AM
@FreshPhilOfSO Aha! I had read that a couple of times, but it didn't sink in.
So they've replaced something useful and actionable with something that is pointless. This would be progress?
 
FreshPhilOfSO
FreshPhilOfSO
Indeed...
 
Paul White
Paul White
I really can't believe this. There usually sense behind SE changes, but this is daft.
 
FreshPhilOfSO
FreshPhilOfSO
10:51 AM
 
 
1 hour later…
Jack Douglas
Jack Douglas
12:07 PM
Tell you what, just enable the toolbar for chat.se and I'll be happy... — FreshPhilOfSO 9 hours ago
yes this ^^^^^^ !
that actually would be progress
 
JNK
JNK
12:26 PM
@PaulWhite I am now
 
Paul White
Paul White
It's ok, Phil encouraged me to read the meta post again and it finally sunk in.
I do prefer the forward kind of progress though.
 
FreshPhilOfSO
FreshPhilOfSO
12:50 PM
Quite an entertaining rant stilldrinking.org/programming-sucks
3
 
Kermit
Kermit
morons
@Kermit, if you can't solve this problem it doesn't mean that the database is wrong. it's require to store data in this way. — Dhaval Ptl 6 hours ago
 
FreshPhilOfSO
FreshPhilOfSO
1:08 PM
I can't look at the front page of DBA.se any more. There's 35 lots of NULL :/
 
Kermit
Kermit
@JNK thanks for adding constructive comments
 
Paul White
Paul White
1:25 PM
@FreshPhilOfSO Picture please! Sounds intriguing.
 
bluefeet
bluefeet
1:39 PM
morning
 
JNK
JNK
hi @bluefeet
 
Zane
Zane
1:52 PM
Yo.
 
FreshPhilOfSO
FreshPhilOfSO
Nothing for me to do!
 
Lamak
Lamak
It really is a bad system
And yesterday I think they went live with it in SO, without excluding close votes, so I saw a 1k notification for a while
 
Kermit
Kermit
2:11 PM
 
James
James
Hi Kermit
 
ypercube
ypercube
@FreshPhilOfSO I wonder how you got to have 40+ questions to close, while I got none.
 
Kermit
Kermit
@James how's london
 
Zane
Zane
Hi Dr. Nick
 
James
James
@Kermit Not too bad -- in the middle of another tube strike
 
Kermit
Kermit
2:16 PM
@Zane thank you
@James those damn tubers
 
Zane
Zane
@James Tube strike?
 
Kermit
Kermit
 
swasheck
swasheck
@James soooo ... black cab?
 
Zane
Zane
There is a great letter FDR wrote about the dangers of Unionization of Public sector workers.
 
swasheck
swasheck
 
Zane
Zane
2:25 PM
Gas build up.
 
swasheck
swasheck
like me after taco tuesday
 
Zane
Zane
Waka Waka
 
swasheck
swasheck
@Zane c'mon man. you tense about tonight? loosen up. (i think the wild have a greater tan 55% chance of winning)
dude. really???? i thought that was going to be at least about Virgin Atlantic.
 
Kermit
Kermit
@FreshPhilOfSO @JNK @JackDouglas Please remove this . NSFW
 
swasheck
swasheck
open.close. lesson learned. don't trust links from phil.
 
Kermit
Kermit
2:34 PM
@FreshPhilOfSO really not cool
 
JNK
JNK
Thanks, Phil
 
Lamak
Lamak
lol
 
FreshPhilOfSO
FreshPhilOfSO
Oops, sorry ;)
 
billinkc
billinkc
@swasheck Hehe, I'm glad I wasn't the only one thinking. What's this company that is bidding on Virgin Air...
 
swasheck
swasheck
@billinkc exactly. i was like ... this is big news!
 
billinkc
billinkc
2:36 PM
Branson must be on hard times
 
swasheck
swasheck
YYYYYYYYYEEEEEEEEEEEEAAAAAAAAAAAAAAAHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!
 
billinkc
billinkc
How dare you say YYYYEAAAAHHHH!
And now the circle is complete
 
FreshPhilOfSO
FreshPhilOfSO
(removed)
 
swasheck
swasheck
(@billinkc = David Caruso's Horatio Caine)
@billinkc whoah simba
 
bluefeet
bluefeet
@Kermit I can delete too :)
 
Kermit
Kermit
2:38 PM
@bluefeet i forgot!
 
swasheck
swasheck
@bluefeet but you're up to your armpits in SO swill
 
bluefeet
bluefeet
@swasheck eh, not so much right now. I've been distracted
 
swasheck
swasheck
@bluefeet real job getting in the way?
 
bluefeet
bluefeet
@swasheck yes and stuff outside of work
 
swasheck
swasheck
did you ever hear about what purpose that calendar served? did you ask michael, "WTF MAN????!!!????!!!!oneoneone"
 
JNK
JNK
2:39 PM
@swasheck "I'm the sure the asking price will be...<put on sunglasses>...sky high!"
 
swasheck
swasheck
@bluefeet hopefully good stuff
 
bluefeet
bluefeet
@swasheck unfortunately not. I've got to plan a trip to Dallas because my mom needs surgery - Of course, they are flying from CT to TX for the surgery.
 
swasheck
swasheck
@JNK is that a legal marijuana joke???
 
JNK
JNK
@swasheck virgin air joke
 
swasheck
swasheck
@bluefeet sorry to hear it. that really sounds like a big deal.
@JNK i know. i was just trying for the "random-theme-shift-via-stream-of-consciousness" trope that @billinkc pulled off. i clearly still have a lot to learn
 
bluefeet
bluefeet
2:43 PM
@swasheck just sucks, last year I had to fly to NYC for my dad and this year my mom.
 
swasheck
swasheck
@bluefeet right. i remember that.
 
JNK
JNK
FYI if anyone needs a comprehensive post on running totals...
2
A: How can I eliminate this costly index seek operation from my query?

Paul WhiteIn addition to the T-SQL techniques discussed in Aaron Bertrands article, "Best approaches for grouped running totals", you might want to look at a SQLCLR procedure. The main advantages are that a SQLCLR procedure requires only a single scan of the source records, and benefits from the increased...

2
 
Kermit
Kermit
@billinkc dude, that's @AaronBertrand's thing
 
billinkc
billinkc
@JNK Or just upgrade to 2012/2014 :P
 
bluefeet
bluefeet
is there a better duplicate than the one suggested here?
0
Q: Truncate Log Files in SQL 2008 R2

user3498389Here is my query in SQL 2005 that I use for truncating log files. My log file will grow to 7G and when I execute this query in a nightly job it will truncate it to 10M. How do I replicate this query in SQL 2008 R2? My current query errors with NO_LOG. Use Master BACKUP log DBNAME WITH NO_LOG ...

sql sql-server-2008
 
JNK
JNK
2:47 PM
@billinkc there's some cardinality issues in 2014
SO had to roll back to the previous engine
 
billinkc
billinkc
SO doesn't have a sufficient workload to properly determine such things
 
swasheck
swasheck
@JNK maybe. or maybe they're letting the SO community write the underlying queries!
 
JNK
JNK
Marc Gravell actually has an interesting series of posts about some of their DB design
they ended up having to denormalize tags into a delimited list on the questions table to make it faster to lookup
 
Paul White
Paul White
@billinkc Yes, the 2012 extensions are best.
 
swasheck
swasheck
@PaulWhite @JNK so ... is it a bug with the cardinality estimates in 2014 or is it unexpected behavior/performance from the new algorithm?
 
Zane
Zane
2:55 PM
@swasheck tense?
 
JNK
JNK
@swasheck I think the thing to remember with cardinality is just about any change you make to the algorithm will make some stuff worse and some stuff better
From all I have heard the 2014 algorithms make a LOT of stuff better
 
swasheck
swasheck
@Zane you mocked my joke
 
Paul White
Paul White
@swasheck It's just hard to estimate the cardinality of a windowed aggregate.
 
JNK
JNK
but SO has some special cases
 
Zane
Zane
We are doing a heritage day at work.
@swasheck Nah uh. Waka Waka is a badge of honor.
 
swasheck
swasheck
2:56 PM
@Zane takes a bow
 
Zane
Zane
Fozzy bear is a beast.
 
swasheck
swasheck
@PaulWhite i can see that
 
Paul White
Paul White
Why's everyone talking about 2014 rather than 2012? Am I missing something?
 
swasheck
swasheck
@JNK isnt that true for most changes?
 
JNK
JNK
@PaulWhite no I just mentioned the 2014 thing because Nick Craver tweeted last week about some issues they were having
 
Zane
Zane
2:57 PM
Any of you have ideas for something fun to do for a team offsite?
 
Paul White
Paul White
@JNK Is there a post about that or just a tweet?
 
JNK
JNK
@PaulWhite not sure let me check
 
swasheck
swasheck
@Zane brewery/distillery tour. paintball. (we also have a dart war place which is like paintball with nerf darts)
 
Zane
Zane
@swasheck It's today...
 
Paul White
Paul White
The 2014 cardinality estimator is more sane, and results may often be 'better' but it's just a different set of assumptions and rules. Sometimes it will be worse. Cardinality estimation is just hard.
 
JNK
JNK
2:59 PM
Well, a few queries Stack Overflow runs are thousands of times worse with 2014 cardinality, we’re back on 2012 compatibility for now
Tweeted by Nick_Craver on April 20, 2014 at 12:53 PM
 
swasheck
swasheck
@Zane so ... brewery/distillery tour
 
Paul White
Paul White
Perfect timing, thanks :)
 
swasheck
swasheck
@JNK no thought of refactoring the queries?
 
JNK
JNK
@swasheck I don't think they touch those very much unless they have to
 
Zane
Zane
Gotta love a website with that makes you click next every paragraph to increase page views.
 
Paul White
Paul White
3:00 PM
I hope that tweet was based on the results of testing, not production experiences.
 
JNK
JNK
If you have a query running millions of times a day and working until you make a change, first instinct is to roll it back
@PaulWhite yeah previous tweet was about turning the CE on
so I think he turned it on, saw the issue, then rolled back
 
Paul White
Paul White
In production?!?
Yee-ha!
 
JNK
JNK
@PaulWhite Actually not sure, I have to imagine they have a pretty thorough test environment
 
swasheck
swasheck
 
Paul White
Paul White
@JNK Let's go with that.
 
swasheck
swasheck
3:02 PM
@JNK you can logship uprev but not downrev, right?
 
JNK
JNK
@swasheck yes
Well I know you can UP
I have to assume you can't down
and we are all 2008r2 finally so I can't test for you :)
 
Paul White
Paul White
You can't apply a log backup from a later version to an earlier version.
 
swasheck
swasheck
@JNK definitely not down.
@PaulWhite i knew that downrev was right out ... but wasnt sure about applying logs from 2008r2 -> 2012
 
JNK
JNK
But I know for sure you can up, we did 2008->2008r2
 
Zane
Zane
@PaulWhite Do all things in production. Live on the edge.
 
Paul White
Paul White
3:04 PM
Certainly makes for a more exciting life, Mr Brunette.
 
swasheck
swasheck
theoretically it makes sense that it would work (like a full+tail restore), but i just didnt know if LS would be different in some mysterious way
 
Zane
Zane
Back-ups and spare parachutes are for casuals. :)
 
JNK
JNK
@swasheck one thing I did discover about this is that you can't restore the initial backup on the up version in standby
has to be in recovery
if you try to do standby it will bomb telling you a database upgrade is required
 
Paul White
Paul White
Exactly, the upgrade involves writes.
 
JNK
JNK
yep
 
swasheck
swasheck
3:06 PM
right ^^
oh crap. so the full request comes through
 
JNK
JNK
so that threw a wrench in my plan a little but we worked around it
 
swasheck
swasheck
can we logship from production to the 2012 test environment primary node and let that sync with its secondaries
hahahahaha
no
 
JNK
JNK
why would you want to do that?
 
Paul White
Paul White
This queue notification number is really irritating me.
I should have a cup of tea.
 
swasheck
swasheck
i love it when people do that.
"hey. can you log ship from a lower version to a higher version?"
"i believe so, yes."
"ok. can you set up log shipping from production sharepoint to the 2012 AG sharepoint test site?"
"funknaw"
 
JNK
JNK
3:08 PM
@PaulWhite oh PS, I thought of you yesterday
Mainly because you are from NZ
Started watching Netflix series Short Poppies
 
swasheck
swasheck
@JNK because they're lazy idiots
 
Paul White
Paul White
@JNK Ha!
 
JNK
JNK
It's pretty hilarious
 
Paul White
Paul White
@JNK I've not seen it, but I like the title and description. It doesn't seem to be available on TVNZ OnDemand right now. I'll look out for it. Sounds right up my street.
 
JNK
JNK
@PaulWhite I listened to an interview with Rhys Darby and he said you don't get Netflix instant watch there which blew my mind, but he said it was released in NZ first through some other media
 
Paul White
Paul White
3:14 PM
@JNK Yes I probably just missed it. OnDemand doesn't keep new stuff available for long, typically.
 
JNK
JNK
yeah here either
Some database-related news: apparently Oracle dropped the ball on the Oregon healthcare exchange
 
Lamak
Lamak
> Well done Madame. We need to celebrate one of these days
 
billinkc
billinkc
Yeah, NPR reported on that fiasco a number of times. Hadn't heard that they were scrapping it entirely in favor of the federal version
 
Lamak
Lamak
is it my idea or that is really condescending?
 
Paul White
Paul White
Great effort here:
5
A: Optimize where clause using dates

ypercubeIt's not so hard to do this transformation. Step by step: DATEADD(DAY , ISNULL(a.[due_days], 30) + 30 , [dbo].[CalcDate]([type], date1, date2, date3, date4, NULL) ) < GETDATE() means: [dbo].[CalcDate]([type], date1, date2, date3, date4, NULL) + (ISNULL(a.[due_days], 30)...

 
swasheck
swasheck
3:24 PM
@Lamak no. i think it was more like W's "Mission Accomplished" announcement
 
Lamak
Lamak
yeah, you may be right. Anyway, "Well done Madame" sounds so pretentious
like a reddit user comment
 
swasheck
swasheck
@Lamak hahahahahahahahaahah
 
FreshPhilOfSO
FreshPhilOfSO
@JNK their CIO presented at Oracle Open World last year, hailing it all a massive success. Kevin Closson (ex-Oracle employee, blogger, storage bloke, ported Oracle to several platforms) was bashing Oracle on Twitter about it all last night. mobile.twitter.com/kevinclosson
 
Lamak
Lamak
@FreshPhilOfSO I get this: "Forbidden (Rate Limit Exceeded)"
 
swasheck
swasheck
@FreshPhilOfSO now he works for EMC ...
 
FreshPhilOfSO
FreshPhilOfSO
3:29 PM
@Lamak twitter is broken for you. Ace
@swasheck indeed. Wrote SLOB (which is awesome)
 
swasheck
swasheck
just needs to take a gig with the NSA next and he'll be in the unholy triumvirate :)
 
Lamak
Lamak
@FreshPhilOfSO I know, just weird somehow, first time for me
 
FreshPhilOfSO
FreshPhilOfSO
Probably already had one, but can't talk about it :)
 
swasheck
swasheck
hahaha
 
Kermit
Kermit
best answer, imo
5
A: What would it take in a book to convince a rational person that it had been written by or directly inspired by a god?

Computer ScientistAbstractly you want an interaction between two parties that will show to the first one that the second one is God, i.e. an interactive proof by God for the verifier who is our rational person. Answer depends on what you mean by God (prover), what you mean by a rational person (verifier) and what...

 
Aaron Bertrand
Aaron Bertrand
3:32 PM
@bluefeet yes, this one.
 
bluefeet
bluefeet
@AaronBertrand thanks!
 
Zane
Zane
/sigh
I just posted a question on the sharepoint site.
 
swasheck
swasheck
@Zane take everything you know to be a best practice for sql server and do the opposite. there's your answer :)
 
Lamak
Lamak
there is a sharepoint SE site?
 
Paul White
Paul White
Is the SO Close Votes queue really down to 10k?
 
Zane
Zane
3:38 PM
@swasheck It's a blog formating question actually.
@PaulWhite They did a huge push and got it empty it's been climbing pretty rapidly ever since.
 
swasheck
swasheck
@Zane good luck with that
 
FreshPhilOfSO
FreshPhilOfSO
I'm glad I don't have the rep on SO to see that ;)
 
Aaron Bertrand
Aaron Bertrand
Can you guys hit sqlperformance.com and tell me the title of the second post
(is it repeatable read, or read committed?)
 
swasheck
swasheck
The Read Committed Isolation Level
 
Zane
Zane
 
Lamak
Lamak
3:44 PM
The Read Committed Isolation Level
 
Aaron Bertrand
Aaron Bertrand
Nice, thanks
 
swasheck
swasheck
 
Aaron Bertrand
Aaron Bertrand
Nice, our TTL works
 
Zane
Zane
@swasheck I see what you did there. Post a larger image than me will ya!
 
swasheck
swasheck
@Zane i wanted to include the full range of what he was requesting.
 
Zane
Zane
3:48 PM
5
Q: When is Spring in the USA?

jaydz49I am from Australia and want to visit the United States of America in the spring season. I am unsure of when the American Spring is.

usa seasonal
 
ypercube
ypercube
@FreshPhilOfSO This can be corrected
 
Zane
Zane
The answer to this question for Minnesota is never.
 
ypercube
ypercube
 
Zane
Zane
We have Winter and then in June it will become Summer in an instant.
 
swasheck
swasheck
@Zane that stinks. we have about 3.5 weeks of spring.
 
Zane
Zane
3:50 PM
@swasheck We have about 2 weeks of it but it's spread across 3 months. lol
 
swasheck
swasheck
@Zane yeah. that too, for us
 
FreshPhilOfSO
FreshPhilOfSO
Did you see this about Flight 370? Seems it has been totally ignored for a few weeks. cbsnews.com/news/…
 
Zane
Zane
We had a few days in March a few in April and we might get a full week of it in May.
 
swasheck
swasheck
@Zane march and beginning of april we strung together two good weeks
now it's snowing
and in a week or two we'll be stupid hot
@FreshPhilOfSO shootdown and coverup?
 
Zane
Zane
@FreshPhilOfSO That scanning tech is boss.
 
FreshPhilOfSO
FreshPhilOfSO
4:07 PM
It is impressive. As is the analysis
 
Lamak
Lamak
4:17 PM
@Zane I'm completely ignorant about sharepoint, but does this helps?
 
Zane
Zane
It might. I'm looking into it.
 
Lamak
Lamak
hopefully it does
 
Kermit
Kermit
worst formatted question ever
-1
Q: I keep getting help !!!Parse error: syntax error, unexpected T_STRING

john uk1enter code here enter code here` enter code here` require('connect.php); enter code here` if(@$_SESSION["username"]){ enter code here` ?> enter code here <title>forum page</title> enter code here </head> <body> enter code here <center><a href="index.php">Gaming Forum</a></...

php html css forum
 
ypercube
ypercube
@Zane Will you post that as an answer?
@Kermit php is the sole owner of my "ignored tags" region.
 
Kermit
Kermit
LOL
and it's gone
 
JNK
JNK
4:29 PM
> why the hell of downvoting it
interesting
 
Kermit
Kermit
@JNK loved that one
 
Zane
Zane
@Kermit Missed it.
 
Kermit
Kermit
@Zane you're able to see imgur right
 
Zane
Zane
Hahaha!
 
ypercube
ypercube
@Lamak: His 1st issue was why COL2 = COALESCE(MY_SPECIFIC_VALUE, COL2) would not return the rows with null in col2
 
Lamak
Lamak
4:34 PM
@ypercube apparently I'm not understanding his question
 
Zane
Zane
@Lamak that does fix my problem but I'm having trouble getting it to be default.
 
Lamak
Lamak
@Zane it does?, well, as I said, I'm completely ignorant about sharepoint
 
Zane
Zane
<---- has sharepoint problem. Posts to SharePoint site. Problem Solved by The Heap.
 
Lamak
Lamak
The Heap™ - Consultancy ©® - Problem solvers
 
ypercube
ypercube
@Lamak Our famous New Yorker author has answered, no worries.
 
Zane
Zane
4:37 PM
I love you guys.
 
swasheck
swasheck
this will turn out well
 
Lamak
Lamak
@ypercube yup, he did
 
Zane
Zane
I like all the people who are like his punishment isn't enough. What are we supposed to do? The guy's a dick last I checked that's not a crime. The NBA is doing all it can. I'm not sure what else they want them to do.
 
JNK
JNK
@Zane you can only punish people so far for their beliefs and not their actions
Obviously what he said was reprehensible but unless he is actively discriminating against people there's not a lot more they could do
 
Zane
Zane
@JNK Which he has done and been successfully sued for.
 
JNK
JNK
4:46 PM
@Zane yeah but I mean this particular incident
 
Zane
Zane
Yup yup.
 
swasheck
swasheck
@JNK which is why the financial angle of sponsorship is being pursued so far. damaging the (impeccable) image of the nba has severe financial consequences.
i just want to see oprah as an nba owner
 
JNK
JNK
"Everyone in the arena look under your seats...it's BEES!"
 
swasheck
swasheck
blocked
too lazy for phone
unexpected fallout from all of this
 
JNK
JNK
@swasheck its just the fairly well-known BEES!!!! oprah gif
 
swasheck
swasheck
4:59 PM
@JNK of which i am ignorant. time for the phone
awesome
 
James
James
5:30 PM
@swasheck Most people are walking in, or if they live farther out, taking a train to a main rail station and walking from there.
 
swasheck
swasheck
how far was it for you?
 
James
James
@swasheck About 2.5 miles for me.
I don't mind, actually I walk in or run back whenever I'm not too lazy...
 
swasheck
swasheck
nice
 
Kermit
Kermit
is there any documentation on join limit in a query?
 
swasheck
swasheck
1
A: What is the maximum number of joins allowed in SQL Server 2008?

Martin SmithThe other answers already give the direct answer to your question Limited only by available resources However even if SQL Server successfully compiles a plan for your query that doesn't mean that you should. The more joins you have the exponentially larger the space of possible query plans ...

 
Kermit
Kermit
5:38 PM
thanks, but need official documentation
as it's going in my thesis
 
swasheck
swasheck
limited by resources appears to be the direct answer
are you saying in the full SQL standard?
 
Kermit
Kermit
5:55 PM
I'm reading an article from 1998:
> For example, in our informal tests on a high-end PC with 128 MB of RAM, a five-table/ alias join yielding a one-million-row result was per- formed with Microsoft Access in less than a minute.
 
JNK
JNK
@Kermit don't make fun
my first PC was a 386 SX 16 mhz with a 40 MB hard drive and 1 MB of ram
I upgraded to 4 MB of ram so it could run Doom
which still sucked on a 386
Then I got a blazing fast 486 DX2/66 mhz with a TURBO BUTTON
 
Kermit
Kermit
@JNK my first pc was a 66 mhz with 8 mb of ram
packard bell iirc
this is pretty close
in first grade though (1994), my school lab had those mechanical keyboard IBM's with green screen monitors and dot matrix printers
now it takes me forever to install windows 8.. 3711 floppies
 
bluefeet
bluefeet
@JNK my first pc was a Tandy
 
JNK
JNK
6:20 PM
@bluefeet My cousin had a tandy with king's quest and we played it a lot
also the other quest for glories
 
swasheck
swasheck
i played baseball and football in the street a lot because we couldnt afford a computer :). i didnt have a computer to use for myself until about 7 years ago.
 
JNK
JNK
@AaronBertrand you around?
nevermind i found it
@Kermit can you imagine if you lost disk 3710?
 
ypercube
ypercube
@Kermit My first computer showed: > 761 bytes free (that is no error, it was bytes)
 
Kermit
Kermit
@JNK or if it couldn't read it
@ypercube greece was behind times
 
JNK
JNK
@Kermit That's 2 GB in metric though
 
Kermit
Kermit
6:29 PM
lol
 
ypercube
ypercube
@Kermit Nah, I'm, just way older than you.
 
Kermit
Kermit
@ypercube only 2 decades
 
ypercube
ypercube
@Kermit Right, Moore's law proved.
8MB / 1KB = 2^13
13 * 1.5 = 19.5 years
 
Zane
Zane
6:54 PM
Well thanks alot @AaronBertrand
You start complaining about twitter e-mails and now I'm getting them.
I a scale from one to ten this chick doesn't know a damn thing.
 
00:00 - 19:0019:00 - 22:00

« first day (1212 days earlier)      last day (3655 days later) »