September 15, 2017 at 10:33 pm
TomThomson - Friday, September 15, 2017 6:18 PMJeff Moden - Thursday, September 14, 2017 7:37 PMSteve Jones - SSC Editor - Thursday, September 14, 2017 7:06 PMJeff Moden - Thursday, September 14, 2017 5:36 PM
Will both of you be there for that one?
Gaahhh... crud... never mind. The hotel prices are nuts that year.Crazy? There are rooms near $100 in the Springs.
The lowest price I saw for that Friday and Saturday was $719.
Ye Gods!!! That's even worse than the UK. I can cope with UK prices (about £90 per night for a double room and breakfast for two people in a 4 star hotel, but could be 30% lower or 40% higher depending on location) but that's already crazy in comparison with Spanish or French or German or Belgian prices (I have no difficulty finding 4 star accomodation and breakfast for two people at 60 Euros, and can usually find someting under 50 Euros). I used to visit Menlo Park and Seattle very often way back when (1999 - a previous century) and the good hotel prices then were not much different from good hotels in Edinburgh or Cambridge (UK not MA) or London (and were a lot cheaper than good hotels in Oxford). So the price you found , Jeff, looks just plain insane to me. Of course all countries have some insane price hotels (Lanesborugh and Dorchester in London, and the Taj in Mumbai, for example) but for that to be the cheapest is amazing.
Nope. It was my mistake. I was trying to see what booking a "package" would cost and it said "First, select your hotel" and it presented them with prices next to them. I didn't realize that the seemingly insane prices where what the package cost would be if you selected that hotel. That little tidbit was buried in some fine print. So that price included the flight, 2 nights at the hotel, and a two day noon to noon car rental. That's not so bad.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 16, 2017 at 3:24 am
Jeff Moden - Friday, September 15, 2017 6:06 PMpaul s-306273 - Friday, September 15, 2017 4:21 AM' I'm batting the right half of 1000 today.'What on earth does that mean?
Batting "1000" (is short for 1.000 or 100%) means hitting everything pitched at you. Unfortunately, I've not been doing that today. I've messed up so many times today that " I'm batting the right half of 1000 today." If you look at the left side of the literal "1000", you get a "10". Guess what you end up with on the right side of "1000"... double goose-eggs. :sick: I've been missing first blush thoughts all day and have had to go back and check each time or be corrected by someone else. Tough day.
Heh! Thanks for the explanation. I was thinking in terms of a numbers line, and placing the "right half of 1000" somewhere in the 501-1000 range - which made no sense within the context.
September 18, 2017 at 7:12 am
I realise that I've not posted the table definitions, but if anyone can give any insight here I'd really appreciate it: https://www.sqlservercentral.com/Forums/1897549/Execution-time-Improvement-Knowing-the-problem-but-not-the-solution
I'm pretty confident the problem is in the WHERE clause (Underlined at the bottom) but, in all honesty, not sure how to keep the functionality with a different syntax; or I could just be being "thick" and suffering from Monday Blues. 😛
Cheers. 🙂
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 18, 2017 at 7:40 am
Thom A - Monday, September 18, 2017 7:12 AMI realise that I've not posted the table definitions, but if anyone can give any insight here I'd really appreciate it: https://www.sqlservercentral.com/Forums/1897549/Execution-time-Improvement-Knowing-the-problem-but-not-the-solutionI'm pretty confident the problem is in the WHERE clause (Underlined at the bottom) but, in all honesty, not sure how to keep the functionality with a different syntax; or I could just be being "thick" and suffering from Monday Blues. 😛
Cheers. 🙂
Textbook catch-all query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2017 at 9:55 am
My Google-Fu is failing me. Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons? Looking for performance information while working on some SQL tuning.
September 19, 2017 at 11:44 am
Lynn Pettis - Tuesday, September 19, 2017 9:55 AMMy Google-Fu is failing me. Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons? Looking for performance information while working on some SQL tuning.
My blog ("are int joins faster than string joins". was, I think, the title)
At least, I did a comparison between joining on int columns and joining on varchar.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2017 at 11:48 am
Finally getting some time to breath a bit.
Checked my work phone before I left this morning, one of my production SQL was non-responsive. E-mailed one of the guys who helps out with the servers to please take a peek and I'd dig in when I got in. He rebooted the server (he's an OS admin, not SQL, but hey, SQL wasn't responding) I get in, SQL services are all stopped.
Get them going, grab the logs and start digging, server lost it's drives (it's a VM) yesterday *just* before I headed home for the day.
All this while we're still dealing with communication issues between workstations to servers and servers to servers. Which, of course, those responsible for the network are saying "it's not a networking issue. Really. Truly. We think."
Always fun when something like this happens.
Would've worked on the problem from home if I'd seen the e-mail sooner, but I tend to ignore the work phone until just before I leave.
September 19, 2017 at 1:11 pm
GilaMonster - Tuesday, September 19, 2017 11:44 AMLynn Pettis - Tuesday, September 19, 2017 9:55 AMMy Google-Fu is failing me. Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons? Looking for performance information while working on some SQL tuning.My blog ("are int joins faster than string joins". was, I think, the title)
At least, I did a comparison between joining on int columns and joining on varchar.
Thanks Gail. Just quick question, do you think this would apply to comparing hash values (like MD5) instead of variable length strings? I will try to set up some testing but it may have to be after the fact which may not be as helpful.
September 19, 2017 at 1:42 pm
Lynn Pettis - Tuesday, September 19, 2017 1:11 PMGilaMonster - Tuesday, September 19, 2017 11:44 AMLynn Pettis - Tuesday, September 19, 2017 9:55 AMMy Google-Fu is failing me. Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons? Looking for performance information while working on some SQL tuning.My blog ("are int joins faster than string joins". was, I think, the title)
At least, I did a comparison between joining on int columns and joining on varchar.Thanks Gail. Just quick question, do you think this would apply to comparing hash values (like MD5) instead of variable length strings? I will try to set up some testing but it may have to be after the fact which may not be as helpful.
No idea. Keep in mind I was doing unfiltered joins of millions of rows, so may not reflect real world usage.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 19, 2017 at 2:34 pm
GilaMonster - Tuesday, September 19, 2017 1:42 PMLynn Pettis - Tuesday, September 19, 2017 1:11 PMGilaMonster - Tuesday, September 19, 2017 11:44 AMLynn Pettis - Tuesday, September 19, 2017 9:55 AMMy Google-Fu is failing me. Does anyone know where I may find information comparing text comparisons vs numeric/binary comparisons? Looking for performance information while working on some SQL tuning.My blog ("are int joins faster than string joins". was, I think, the title)
At least, I did a comparison between joining on int columns and joining on varchar.Thanks Gail. Just quick question, do you think this would apply to comparing hash values (like MD5) instead of variable length strings? I will try to set up some testing but it may have to be after the fact which may not be as helpful.
No idea. Keep in mind I was doing unfiltered joins of millions of rows, so may not reflect real world usage.
Understood, just that you might have a swag. The blog was a good read, thanks again.
September 19, 2017 at 2:39 pm
OMG! People are getting so literal! "I am not using a system table." Hey! It was an example! Get a clue!
September 19, 2017 at 2:54 pm
If anyone has any info on this, please let me know.
https://www.sqlservercentral.com/Forums/1897898/Filtered-Index-on-a-Temp-Table-in-a-Stored-Proc-can-result-in-a-Error-602
Also, today is the 32nd anniversary of the most devastating earthquake that Mexico has faced, and there was a new one that collapsed several buildings. Please, keep the victims in your prayers.
September 19, 2017 at 4:44 pm
SQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
-- Itzik Ben-Gan 2001
September 19, 2017 at 5:09 pm
Alan.B - Tuesday, September 19, 2017 4:44 PMSQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
So what else is new?
September 19, 2017 at 6:56 pm
Alan.B - Tuesday, September 19, 2017 4:44 PMSQL Server is so weird sometimes.
select 'a'+++++++++++++++++++++++'b'++++++++++++++++++++++++'c'
returns abc.
Heh... yep... fun stuff.
SELECT '1,,,,,,'+$0, ',,,,,,1'+$0, '1,,,,,,1'+$0, '1,,,1,,,1'+$0;
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 59,941 through 59,955 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply