June 30, 2016 at 8:31 am
BWFC, I agree with you. I'm also trying to say "London" (the entity) is not the monster it is often made out to be. Plenty of perfectly normal people live and work in London, and that is often overlooked by detractors.
Definitely, don't tell Mrs BWFC but I actually quite like the place. This certainly isn't about London or its residents. It's a gripe about central government. I'm also realising that I'm starting to sound more and more like a bar-stool expert.
What I think I find most annoying is the fact that the money that is made in London, could actually be made anywhere in the country. The manufacturing industries that drove the regional economies in the past were sited where they were for logistical reasons. They needed to be close to the resources they required. With service and financial industries that are making all the money in London all you essentially need is good comms. They could be done anywhere in the country and there's no real reason why a trader based in Manchester couldn't make as much money as one in London. I know that is a simplification but I think the point is there. With the investment the playing field could be a bit more level.
It's not just industry either. The arts in the regions get a fraction of the funding received by London. As an example, a museum close to me had it's local government funding cut. An appeal was launched to find £100k or so to keep it open for a year. However they can find £60 million for another bridge across the Thames. That got a few backs up in my neck of the woods.
As it is, we're in a vicious or virtuous, depending on your postcode, spiral. The jobs and opportunities are in London so the best and brightest go there, creating more jobs and opportunities.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
June 30, 2016 at 8:55 am
And I agree back ;-), except for this bit:
BWFC (6/30/2016)
What I think I find most annoying is the fact that the money that is made in London, could actually be made anywhere in the country. The manufacturing industries that drove the regional economies in the past were sited where they were for logistical reasons. They needed to be close to the resources they required. With service and financial industries that are making all the money in London all you essentially need is good comms. They could be done anywhere in the country and there's no real reason why a trader based in Manchester couldn't make as much money as one in London. I know that is a simplification but I think the point is there. With the investment the playing field could be a bit more level.
This is a little awkward to say (and it probably doesn't help London's case with outsiders), but a really good trader (or DBA, or accountant) knows they can call the shots with regard to where they work. They're not going to Manchester if they can live and work in London*. If certain firms moved their trading floors to Manchester, the good traders would just jump ship to the ones who have a base in London (or New York, or Singapore). Rightly or wrongly, central London is so much more desirable than Manchester or Leeds for a certain type of person. Furthermore, clients of those companies want them to be based in the Square Mile. They probably live in London (or New York, or Singapore) themselves. They want the associated prestige, just like they do with firms on Wall Street (not Jersey City). An office in Salford Quays just won't cut it.
* Yes, there are ALWAYS exceptions.
June 30, 2016 at 9:24 am
Beatrix Kiddo (6/30/2016)
And I agree back ;-), except for this bit:BWFC (6/30/2016)
What I think I find most annoying is the fact that the money that is made in London, could actually be made anywhere in the country. The manufacturing industries that drove the regional economies in the past were sited where they were for logistical reasons. They needed to be close to the resources they required. With service and financial industries that are making all the money in London all you essentially need is good comms. They could be done anywhere in the country and there's no real reason why a trader based in Manchester couldn't make as much money as one in London. I know that is a simplification but I think the point is there. With the investment the playing field could be a bit more level.
This is a little awkward to say (and it probably doesn't help London's case with outsiders), but a really good trader (or DBA, or accountant) knows they can call the shots with regard to where they work. They're not going to Manchester if they can live and work in London*. If certain firms moved their trading floors to Manchester, the good traders would just jump ship to the ones who have a base in London (or New York, or Singapore). Rightly or wrongly, central London is so much more desirable than Manchester or Leeds for a certain type of person. Furthermore, clients of those companies want them to be based in the Square Mile. They probably live in London (or New York, or Singapore) themselves. They want the associated prestige, just like they do with firms on Wall Street (not Jersey City). An office in Salford Quays just won't cut it.
* Yes, there are ALWAYS exceptions.
If London salaries were available to workers in Leeds/Manchester etc, I think there would be a significant migration out of the capital. That is just my opinion, but it is backed up by the fact that I have lived and worked in London, Leeds and Manchester and, of course, came into contact with many colleagues along the way whose opinions have informed my comment.
I realise that this starts to imply that I am not one of the 'really good' professionals, based on your comment, but I can live with that 😛
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 30, 2016 at 9:28 am
I'm sure you are very good: it's absolutely not a slight on anybody who doesn't work in London, it's just saying that very good people can vote with their feet.
That's possibly true about people migrating out of the capital if salaries were the same. I personally wouldn't, but I'm sure plenty of people would, especially people with children, or... people who like hiking. The hiking's terrible down here :-D.
June 30, 2016 at 9:53 am
Beatrix Kiddo (6/30/2016)
I'm sure you are very good: it's absolutely not a slight on anybody who doesn't work in London, it's just saying that very good people can vote with their feet.That's possibly true about people migrating out of the capital if salaries were the same. I personally wouldn't, but I'm sure plenty of people would, especially people with children, or... people who like hiking. The hiking's terrible down here :-D.
It depends on your train service! Southwest, and you'd better like hiking :-
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 30, 2016 at 9:56 am
oops...wrong post !
apologies
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 10:05 am
J Livingston SQL (6/30/2016)
oops...wrong post !apologies
You have a spare turtle?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
June 30, 2016 at 10:19 am
So when September rolls around, I'm going to a convention in Toronto, Ontario (Canada,) FanExpo. It's a Comic book / movie / anime sort of convention, and they've been announcing guests for the last couple months. The pace on the guest announcements has been picking up, with a new one today...
Mark Hamill (Luke Skywalker!)
There's also going to be other big names like:
Stan Lee
Sigourney Weaver
Christopher Lloyd
Adam West
Burt Ward
Gads I'm looking forward to this...
June 30, 2016 at 1:00 pm
jasona.work (6/30/2016)
So when September rolls around, I'm going to a convention in Toronto, Ontario (Canada,) FanExpo. It's a Comic book / movie / anime sort of convention, and they've been announcing guests for the last couple months. The pace on the guest announcements has been picking up, with a new one today...Mark Hamill (Luke Skywalker!)
There's also going to be other big names like:
Stan Lee
Sigourney Weaver
Christopher Lloyd
Adam West
Burt Ward
Gads I'm looking forward to this...
And they hope they are still alive for it! 😀
June 30, 2016 at 1:25 pm
Beatrix Kiddo (6/30/2016)
And I agree back ;-), except for this bit:BWFC (6/30/2016)
What I think I find most annoying is the fact that the money that is made in London, could actually be made anywhere in the country. The manufacturing industries that drove the regional economies in the past were sited where they were for logistical reasons. They needed to be close to the resources they required. With service and financial industries that are making all the money in London all you essentially need is good comms. They could be done anywhere in the country and there's no real reason why a trader based in Manchester couldn't make as much money as one in London. I know that is a simplification but I think the point is there. With the investment the playing field could be a bit more level.
This is a little awkward to say (and it probably doesn't help London's case with outsiders), but a really good trader (or DBA, or accountant) knows they can call the shots with regard to where they work. They're not going to Manchester if they can live and work in London*. If certain firms moved their trading floors to Manchester, the good traders would just jump ship to the ones who have a base in London (or New York, or Singapore). Rightly or wrongly, central London is so much more desirable than Manchester or Leeds for a certain type of person. Furthermore, clients of those companies want them to be based in the Square Mile. They probably live in London (or New York, or Singapore) themselves. They want the associated prestige, just like they do with firms on Wall Street (not Jersey City). An office in Salford Quays just won't cut it.
* Yes, there are ALWAYS exceptions.
I completely agree with you there Beatrix. My point was that the jobs could be done elsewhere. It's theoretically easier to move a laptop than hundreds of tonnes of coal. The laptop operator is likely to the bigger issue. As it happens I work on Salford Quays and it's frankly, shit. Although how much of that is down to our leaky draughty office I don't know.
The points about London salaries are valid but I think there's a bit of chicken and egg. London is expensive so people need to be paid more, London becomes more expensive because people are paid more.
I'll take the win on the hiking with pleasure. I can be in the Lake District, the Yorkshire Dales or the Peak District within an hour's drive. That's ignoring the hills almost literally on my doorstep 🙂
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
June 30, 2016 at 2:00 pm
As it happens I work on Salford Quays and it's frankly, shit. Although how much of that is down to our leaky draughty office I don't know.
Well I just I hope my son doesnt read this.....at the moment he is waiting to see if he will get a position ....opportunities appear to be either London or Manchester.
I have tried very hard, as a father does, to say that if its Manchester...then there are benefits (lower rent that more than offsets lower salary....better fish and chips...people talk to you, (if you can undertand them)...no tube! yadda yadda)
His response after 12mths in the city was ......"Well sod that...I wanna be where decsions are made and to be seen as a person who can make things happen...not some email in a regional office)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
June 30, 2016 at 2:17 pm
J Livingston SQL (6/30/2016)
As it happens I work on Salford Quays and it's frankly, shit. Although how much of that is down to our leaky draughty office I don't know.
Well I just I hope my son doesnt read this.....at the moment he is waiting to see if he will get a position ....opportunities appear to be either London or Manchester.
I have tried very hard, as a father does, to say that if its Manchester...then there are benefits (lower rent that more than offsets lower salary....better fish and chips...people talk to you, (if you can undertand them)...no tube! yadda yadda)
His response after 12mths in the city was ......"Well sod that...I wanna be where decsions are made and to be seen as a person who can make things happen...not some email in a regional office)
It's swings and roundabouts and different strokes for different folks. I like my job and where I live, I'm close to my family and everything's cheaper. But, I'm in the sticks and there's not the opportunities. I wouldn't swap it for the world though.
I think the biggest problems I have with Salford Quays are the state of our office and the fact that it's a pig to get to from where I am. However the pig of a commute is offset by the cheap house and scenery. Manchester itself is actually really easy, I can be in the centre in 45 minutes. It's just awkward to get out to the Quays for early o'clock.
Hopefully he'll stay up here, I may be horribly biased but it's just better 🙂
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
June 30, 2016 at 6:08 pm
Is there a limit on how deep you can nest a REPLACE?
June 30, 2016 at 6:13 pm
Lynn Pettis (6/30/2016)
Is there a limit on how deep you can nest a REPLACE?
Never mind, I think I just figured this one out as well. I think I have too many outer apply statements in my SQL. Why do these tables have to be so wide. Oh, I know, there was no real design work done between rockets and mortars going off around the developers in Iraq 10 to 12 years ago, or when ever this app was being created (can't really say designed).
June 30, 2016 at 6:54 pm
Lynn Pettis (6/30/2016)
Lynn Pettis (6/30/2016)
Is there a limit on how deep you can nest a REPLACE?Never mind, I think I just figured this one out as well. I think I have too many outer apply statements in my SQL. Why do these tables have to be so wide. Oh, I know, there was no real design work done between rockets and mortars going off around the developers in Iraq 10 to 12 years ago, or when ever this app was being created (can't really say designed).
A friggin' missing paren. I know I need to use dynamic SQL for what I am doing, but it is sure a pain in the butt!
Viewing 15 posts - 54,856 through 54,870 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply