Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««4,3184,3194,3204,3214,322»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Thursday, March 6, 2014 10:23 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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...


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."


  Post Attachments 
ServiceBrokerPresentation.zip (3 views, 851.73 KB)
Post #1548382
Posted Thursday, March 6, 2014 10:31 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 21,631, Visits: 15,290
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1548389
Posted Thursday, March 6, 2014 10:39 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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".


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1548394
Posted Thursday, March 6, 2014 10:41 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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?


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1548396
Posted Thursday, March 6, 2014 10:44 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, June 5, 2014 10:54 AM
Points: 9,902, Visits: 9,480
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. Then I remembered that Barry was giving me an identity crisis those many years ago.

Hah. Thats right, I had forgotten about that.


-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #1548398
Posted Thursday, March 6, 2014 11:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:10 PM
Points: 1,231, Visits: 6,621
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.
Post #1548414
Posted Thursday, March 6, 2014 1:21 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 8,689, Visits: 9,223
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? : In Britain excluding Northern Ireland? That's hopelessly inaccurate In fact it's 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?



Tom
Post #1548459
Posted Thursday, March 6, 2014 1:58 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 4:54 PM
Points: 8,689, Visits: 9,223
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
Post #1548479
Posted Thursday, March 6, 2014 5:41 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 4:14 AM
Points: 3,618, Visits: 5,254
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 mantra: No loops! No CURSORs! No RBAR! Hoo-uh!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1548545
Posted Thursday, March 6, 2014 8:15 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, August 17, 2014 3:10 PM
Points: 4,013, Visits: 6,098
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? -- Stephen Stills
Post #1548561
« Prev Topic | Next Topic »

Add to briefcase «««4,3184,3194,3204,3214,322»»»

Permissions Expand / Collapse