March 6, 2014 at 6:40 am
MysteryJimbo (3/6/2014)
Ed Wagner (3/6/2014)If you've ever driven in the Great Smokey Mountains or especially the Rocky Mountains, it is absolutely beautiful, but it is anything but straight and the Rockies includes some serious elevation changes. The automatic works against you and you cannot use cruise. They even have signs saying to downshift instead of wearing out your brakes. Granted, most of the roads here are pretty straight and it can get boring when you're going on long trips, but there's also such a diversity of climates. For example, a client in Texas was saying it was pretty cold at 60 F last week while we in Michigan were hoping to get up to 0 F. Minnesota is a whole other story of cold.
I didn't mean to imply all the roads were straight. Just a large majority. 🙂
On those particular drives I had a good mix of climates going through the French or Austrian Alps (Innsbruck being pretty famous for skiing) and Italian country side. Malta was something different altogether with its humid Mediterranean island climate with a touch of African thrown in for good measure.
Yes, there are many straight roads here that are well beyond boring, in fact bordering on mind-numbing. If you've ever driven across Montana, you know what I mean.
Now Malta would be a place that I'd love to visit one day - such a great history. The only other place I'd rather go is Italy and eat my way around the country. 😀
March 6, 2014 at 6:44 am
ChrisM@Work (3/6/2014)
rodjkidd (3/6/2014)
ChrisM@Work (3/6/2014)
Are you working in Maidenhead, Rod?Chris,
Work in Bracknell, stay near Bray in Maidenhead at the moment.
Rodders...
Not much of a hike then. Bray, home of the Fat Duck. I didn't know Bray was so close to Maidenhead until one lunchtime coming out of the little Sainsbury's opposite the station, I almost walked into HB. Snail porridge, anyone?
I found out by accident as well. Was staying near the Rivera restaurant and discovered the cut through Bray. Someone had to point out the door to the Fat Duck to me though. More interested in visiting the Michel Roux jr one though. I've walked through Bray a couple of times since, nice. Apparently some of the Fat Duck apprentices stay at the B&B I'm at. Not sure of the landlady gets discounts - must ask. Can't say I've seen any of the owners yet, or Rolf who lives there as well.
Rodders...
March 6, 2014 at 6:55 am
Ed Wagner (3/6/2014)
MysteryJimbo (3/6/2014)
Ed Wagner (3/6/2014)If you've ever driven in the Great Smokey Mountains or especially the Rocky Mountains, it is absolutely beautiful, but it is anything but straight and the Rockies includes some serious elevation changes. The automatic works against you and you cannot use cruise. They even have signs saying to downshift instead of wearing out your brakes. Granted, most of the roads here are pretty straight and it can get boring when you're going on long trips, but there's also such a diversity of climates. For example, a client in Texas was saying it was pretty cold at 60 F last week while we in Michigan were hoping to get up to 0 F. Minnesota is a whole other story of cold.
I didn't mean to imply all the roads were straight. Just a large majority. 🙂
On those particular drives I had a good mix of climates going through the French or Austrian Alps (Innsbruck being pretty famous for skiing) and Italian country side. Malta was something different altogether with its humid Mediterranean island climate with a touch of African thrown in for good measure.
Yes, there are many straight roads here that are well beyond boring, in fact bordering on mind-numbing. If you've ever driven across Montana, you know what I mean.
Now Malta would be a place that I'd love to visit one day - such a great history. The only other place I'd rather go is Italy and eat my way around the country. 😀
There are many places I'd like to visit, especially with the time to explore and learn about the history.
Although traffic can be a headache at times, many times I've been able to find side roads and see some things I would have missed on the main road.
Met someone from Finland last week, and he shared some interesting stories of his bicycle camping trips.
Sometimes it can be very good to get 'lost'. You may have some great memories from events you never could have planned for.
March 6, 2014 at 6:55 am
Ed Wagner (3/6/2014)
MysteryJimbo (3/6/2014)
Ed Wagner (3/6/2014)If you've ever driven in the Great Smokey Mountains or especially the Rocky Mountains, it is absolutely beautiful, but it is anything but straight and the Rockies includes some serious elevation changes. The automatic works against you and you cannot use cruise. They even have signs saying to downshift instead of wearing out your brakes. Granted, most of the roads here are pretty straight and it can get boring when you're going on long trips, but there's also such a diversity of climates. For example, a client in Texas was saying it was pretty cold at 60 F last week while we in Michigan were hoping to get up to 0 F. Minnesota is a whole other story of cold.
I didn't mean to imply all the roads were straight. Just a large majority. 🙂
On those particular drives I had a good mix of climates going through the French or Austrian Alps (Innsbruck being pretty famous for skiing) and Italian country side. Malta was something different altogether with its humid Mediterranean island climate with a touch of African thrown in for good measure.
Yes, there are many straight roads here that are well beyond boring, in fact bordering on mind-numbing. If you've ever driven across Montana, you know what I mean.
Now Malta would be a place that I'd love to visit one day - such a great history. The only other place I'd rather go is Italy and eat my way around the country. 😀
Montana, Ohio, Nebraska, Kansas, Texas, eastern Colorado, western Oklahoma, oh yeah, there is lots of boring driving in the US.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 6, 2014 at 7:41 am
The Dixie Flatline (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
A LOT
What happened to your website?
I was trying to get a script from there a week or so ago and it was no longer available.
Sorry, Jason. Sadly it's been down for years (ever since I was sick). Almost of of my scripts should be on SqlServerCentral somewhere though (the good ones anyway). If you still want it let me know which one and I'll see if I can locate it.
Here is the thread with the broken link.
http://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspx
I am interested in your SB demo.
(Near hysterical laughter.)
I just looked at that thread and was shocked that my name appeared in it as if I had compiled copious expertise in Service Broker. :w00t: Then I remembered that Barry was giving me an identity crisis those many years ago. :hehe:
Yeah I had to double take on that thread and then remembered that stretch. Fun times:-D.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 6, 2014 at 10:23 am
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
A LOT
What happened to your website?
I was trying to get a script from there a week or so ago and it was no longer available.
Sorry, Jason. Sadly it's been down for years (ever since I was sick). Almost of of my scripts should be on SqlServerCentral somewhere though (the good ones anyway). If you still want it let me know which one and I'll see if I can locate it.
Here is the thread with the broken link.
http://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspx
I am interested in your SB demo.
Ah yes. That's my Service Broker stuff, which I should have turned into an article here, but I never did. I cannot be sure exactly which one that was, but I think that it's from my "Dude, Where's My Error" presentation, which I will attempt to attach here...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 6, 2014 at 10:31 am
RBarryYoung (3/6/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
A LOT
What happened to your website?
I was trying to get a script from there a week or so ago and it was no longer available.
Sorry, Jason. Sadly it's been down for years (ever since I was sick). Almost of of my scripts should be on SqlServerCentral somewhere though (the good ones anyway). If you still want it let me know which one and I'll see if I can locate it.
Here is the thread with the broken link.
http://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspx
I am interested in your SB demo.
Ah yes. That's my Service Broker stuff, which I should have turned into an article here, but I never did. I cannot be sure exactly which one that was, but I think that it's from my "Dude, Where's My Error" presentation, which I will attempt to attach here...
Thanks much!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 6, 2014 at 10:39 am
Jason: Let me know if you have any question about the presentation.
One thing I'll answer now: "IDKYMSDWTD" stands for "I Don't Know Why Microsoft Did What They Did".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 6, 2014 at 10:41 am
Evil Kraig F (3/5/2014)
Hey Barry, welcome back.In general, not much... Other than I apparently created a 3! point question for the QotD... 😎
(I didn't think it was THAT difficult...)
Oooh! Now I want to try it. Got a link?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 6, 2014 at 10:44 am
The Dixie Flatline (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
SQLRNNR (3/5/2014)
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
A LOT
What happened to your website?
I was trying to get a script from there a week or so ago and it was no longer available.
Sorry, Jason. Sadly it's been down for years (ever since I was sick). Almost of of my scripts should be on SqlServerCentral somewhere though (the good ones anyway). If you still want it let me know which one and I'll see if I can locate it.
Here is the thread with the broken link.
http://www.sqlservercentral.com/Forums/Topic862366-1281-1.aspx
I am interested in your SB demo.
(Near hysterical laughter.)
I just looked at that thread and was shocked that my name appeared in it as if I had compiled copious expertise in Service Broker. :w00t: Then I remembered that Barry was giving me an identity crisis those many years ago. :hehe:
Hah. Thats right, I had forgotten about that. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 6, 2014 at 11:35 am
RBarryYoung (3/6/2014)
Jason: Let me know if you have any question about the presentation.One thing I'll answer now: "IDKYMSDWTD" stands for "I Don't Know Why Microsoft Did What They Did".
Sometimes even they don't know why. 😀
March 6, 2014 at 1:21 pm
MysteryJimbo (3/6/2014)
Jack Corbett (3/5/2014)
Isn't everything close in the UK? 😀
Depends on your definition of close and the road network. Roads in the UK are far from straight and as they tend to follow the lay of the land and in places go around pre-existing property. The general UK opinion I would say anything over 90 minutes is a decent drive and the journey wouldn't be made on without some planning around time.
Your "It depends" is something I agree with, but I disagree with the rest. It doesn't match my experience, not at all.
In my experience people drive 4 hour journeys now and again, and sometimes 8 hours or more. I drive from Congleton to Edinburgh quite often, which in normal traffic takes about four hours. When I was young (teenager) I drove from Harlow (just outside London) to Glasgow (actually two of us split the driving - this was before there was much in the way of motorway in Britain, so that was quite a long journey ) and the next day to Staffin (using car ferry from Kyle to Kyleakin), and a couple of years later from Bristol to GlenBrittle (using the same ferry) but at that time I didn't do much driving at all because I didn't possess a car. When I got round to having a car, I drove regulary from Stafford to Cambridge - before there were any motorways that contributed anything much to that journey that used to yake a lot more than 90 minute. Later on, on my wedding day, after the reception I drove from Fleet to Gretna (having driven 50 miles to get to Fleet for teh ceremony), then the next day from Gretna to Uig (car ferry from Glenelg to Kylerhea - no Skye Bridge in those days), and later on (after moving to England) family holidays generally involved quite a bit of driving - from Congleton to BaileChaolais, or to Carn Dearg/Gairloch, or to Lochinver, or to Brora, or to Edinbane, and once from Congleton to Annecy (using car ferry from Dover to Calais) which was the only drive I ever bothered to plan (3 days driving, so needed to plan accomodation and meals). In my work I used to drive quite often from Congleton to Stirling, and Congleton to St Andrews, and so did several of my colleagues because we had good relations with research staff at the Universities there; Congleton to Bracknell and Congleton to London pretty often too and less often from from Congleton to Dalkeith or Glasgow or Edinburgh. I'm not unusual - most people I knew when I was working full time travelled quite a lot, and used a car when that was the most convenient or most useful way to do it.
Great Britain (UK minus Northern Ireland) itself is about 8 hours east to west and about 16 hours north to south depending on your location and traffic.
It's rather smaller than that, if you have a half-way decent car - ie not something that can only reach 65 mph on a steep downhill slope with a strong following wind. 😀
There are very few places where the mainland is 8 hours east to west. This is illustrated by Cullercoats on the east coast to Allonby on the west coast, which I've driven in comfortably less than 2 hours (it's about 90 miles, mostly on fairly good roads, but if you get behind something slow you may have trouble getting a chance to overtake it, so time depends heavily on traffic). Cullercoats to Stranraer is maybe a more typical east-west journey, the best route is about about 170 miles long and takes about 3½ hours, and the scenic route (which people who want to see the scenery do sometimes take) can be anywhere from 230 to 270 miles and takes between 5½ and 6½ hours. The longest (distance) east-west routes are things like Felixstowe to St Davids, (360 miles, 6 hours) , Great Yarmouth to Aberdaron (320 miles, 6½ to 7 hours), and Dover to Sennen (360 miles, 6 to 7 hours). I firmly believe that any East to West trip which takes as long as 8 hours either is using a very slow vehicle or has destination a long way north or south of start point, or maybe is deliberately choosing a longer or slower than necessary route - perhaps to look at the scenery.
I think 12 hours north to south would be a better bet than 16 hours; or at a push, 14 hours - the longest road journey you can make on the British mainland (without deliberately going the long way round) is Penzance to Durness, which is about 810 miles and should take 14 hours or a bit less, taking that long only because it starts at Penzance and the roads in Cornwall are awful; Sennen is about as bad as Penzance; the roads near Durness are pretty bad too). Bournmouth to Thurso, probably the "typical" N to S journey, is about 720 miles, most of it motorway or top quality trunk road, and should take 12 hours or less. Even the long SW-NE diagonal (Penzance to John o'Groats, 825 miles) will take between 13½ and 14 hours, and the shorter SE to NW diagonal (Dover to Durness, 730 miles, or to Kinlochbervie, 720 miles) takes only 12 to 12½ hours.
Telford being fairly central is advantageous.
Fairly central? :w00t:: In Britain excluding Northern Ireland? That's hopelessly inaccurate :exclamation: In fact it's crazy. :crazy: Even if you mean the British mainland, thus excluding the Orkneys and the Shetlands as well as Northern Ireland, the latitude of Telford is further from the midline between the nothernmost and southernmost latitudes of the mainland than is the latitude of Glasgow, which itself is of course nowhere near central - the central latitude is a shade north of Kendal, and that's far too big an error in an an island as small as mainland Britain to allow Telford to be classed as "fairly central". Of course if you meant "fairly central in mainland UK excluding Scotland" then that's a fairly accurate description of where Telford is - the lattitude halfway between the extreme south and the extreme north of England passes only about 17 miles south of Telford. Is calling Telford "fairly central" perhaps a product of the common SE English view that hardly any of the British mainland is north of Watford Gap? :rolleyes:
Tom
March 6, 2014 at 1:58 pm
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the world, you could drive through the whole country in a couple of hours.
You can drive through the whole country in a couple of hours. I've done it (by avoiding cities). Germany to France.
I meant from west to east. You'd have to pass either Antwerp or Brussels. Either way, you're screwed 🙂
And you can go from Germany to France without passing Belgium as well 🙂
Brussels must have changed a lot since I was last there - the traffic wasn't to bad then, compared to other cities I knew, but that was about 15 or maybe 16 years ago. Antwerp I drove through the outskirts of on my way from France to the Netherlands and again on my way back in (I think) 2005 - it wasn't a problem at all then, nothing like the mess around Utrecht - but even that is long enough ago for there to be plenty of change since.
Tom
March 6, 2014 at 5:41 pm
TomThomson (3/6/2014)
Koen Verbeeck (3/6/2014)
MysteryJimbo (3/6/2014)
Koen Verbeeck (3/5/2014)
Pfff, than you have never been in Belgium before 😀
If we wouldn't be having the most traffic jam congested cities in the world, you could drive through the whole country in a couple of hours.
You can drive through the whole country in a couple of hours. I've done it (by avoiding cities). Germany to France.
I meant from west to east. You'd have to pass either Antwerp or Brussels. Either way, you're screwed 🙂
And you can go from Germany to France without passing Belgium as well 🙂
Brussels must have changed a lot since I was last there - the traffic wasn't to bad then, compared to other cities I knew, but that was about 15 or maybe 16 years ago. Antwerp I drove through the outskirts of on my way from France to the Netherlands and again on my way back in (I think) 2005 - it wasn't a problem at all then, nothing like the mess around Utrecht - but even that is long enough ago for there to be plenty of change since.
Traffic? Puh-lease! Try driving in Bangkok on Friday at 6PM.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St
March 6, 2014 at 8:15 pm
Semicolons.
Can't live with 'em....
... pass me the peanuts.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
Viewing 15 posts - 43,186 through 43,200 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply