April 29, 2014 at 8:23 am
TomThomson (4/28/2014)
GilaMonster (4/28/2014)
For the UK residents, what are my travel options for Birmingham -> Swansea?Not yet certain if that's where I'll go, but may well be a place to start.
Birmingham to swansea is about 10 minutes less than 3 hours by rail, with a change of trains 915 mins breaj) at Bristol - best bet is to look at http://www.nationalrail.co.uk/ to see about trains. But if you are starting from Telford, going via Birmingham is going to take about 10 minutes longer than going via Shrewsbury - but Bham has the advantage that you have a greater choice of trains.
There are buses/coaches too, but I haven't a clue about them - I never use them, because trains used to be much more comfortable back in the days when I formed my travelling habits.
Tom to be fair I have no airport experience pre 9/11 so I can't really say what is better or worse. Birmingham did go OTT a year later due to an idiot in a 4x4 and the drop off space in front of the departure entrance!
Luton, as a basic rule of thumb I avoid it, too many stories from other people.
When I was in West Midlands a few years ago, the trains were ok. Not the best at time keeping, but comfortable, and it's a main hub. Some odd journeys due to via locations, and no fast / semi fat options - I had to go to Worcester for training and to go by train would take twice as long as to drive 1 hour 20 versus 40 minutes in the car!
Coaches haven't used them since I got a car so 20 years ago 🙂
But I know someone who swears the couch is faster from Heathrow to central Birmingham than the train!
Rodders...
April 29, 2014 at 8:31 am
TomThomson (4/25/2014)
I avoid Heathrow whenever possible - it's a pretty unpleasant airport.
I'm usually in and out quickly that I don't mind it much.
May 1, 2014 at 7:38 am
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).
Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
- 😀
May 1, 2014 at 7:55 am
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
I'll absolutely be there, although I'm feeling decidedly under the weather at the moment. Make sure you corner me and say hello. Things get crazy at these events.
"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
May 1, 2014 at 8:20 am
Oh, definitely! I'd be honored to speak with you :-). Atlanta's awfully busy itself, but it's kinda close to where I grew up, so it's great to have an event like this close to home.
- 😀
May 1, 2014 at 10:30 am
Can someone do me a favor and try to edit a few of their own posts?
got a report of a bug here: http://www.sqlservercentral.com/Forums/Topic1566649-433-1.aspx?Update=1
May 1, 2014 at 10:36 am
Steve Jones - SSC Editor (5/1/2014)
Can someone do me a favor and try to edit a few of their own posts?got a report of a bug here: http://www.sqlservercentral.com/Forums/Topic1566649-433-1.aspx?Update=1
See my reply in the bug thread.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 1, 2014 at 10:37 am
The bug report is correct (and it's not saying that you can't edit your own post). It's saying unexpected things happen when you click the Edit on someone else's post
I see every single post having an edit button, including your Steve. If I click the edit button on your post, it takes me to the top of the page your post is on. If I add a post to the bug thread and then again click the edit button on your thread, it takes me to the bug thread.
It's been like that forever.
Editing my own posts is fine
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
May 1, 2014 at 10:44 am
Thanks, Gail and Sean. I was moving too fast and didn't realize the OP was editing another post.
May 1, 2014 at 11:03 am
hisakimatama (5/1/2014)
Oh, definitely! I'd be honored to speak with you :-). Atlanta's awfully busy itself, but it's kinda close to where I grew up, so it's great to have an event like this close to home.
You might change you mind after you have heard Grant sing 😉
But good thing is he's not that scary in person, well most of the time.
Grant, great catching up last week at Chicago, hope you are feeling better come Atlanta. I've decided to stay in Chicago and be a tourist as I did think 'hey Atlanta isn't that far...' But common sense kicked in. 🙂
Rodders...
May 1, 2014 at 11:36 am
Steve Jones - SSC Editor (5/1/2014)
Can someone do me a favor and try to edit a few of their own posts?got a report of a bug here: http://www.sqlservercentral.com/Forums/Topic1566649-433-1.aspx?Update=1
It's a bit confusing that hitting edit on someone elses post takes you back to ypur last post. That probably whould be fixed sometime. But I suspect that hardly anyone ever encounters it - Id never seen it before I tried it today to see if it really happened - because people generally only edit their own posts (and as far as I can see there's no problem at all with that).
Tom
May 1, 2014 at 1:31 pm
TomThomson (5/1/2014)
Steve Jones - SSC Editor (5/1/2014)
Can someone do me a favor and try to edit a few of their own posts?got a report of a bug here: http://www.sqlservercentral.com/Forums/Topic1566649-433-1.aspx?Update=1
It's a bit confusing that hitting edit on someone elses post takes you back to ypur last post. That probably whould be fixed sometime. But I suspect that hardly anyone ever encounters it - Id never seen it before I tried it today to see if it really happened - because people generally only edit their own posts (and as far as I can see there's no problem at all with that).
I've always seen the Edit button on all posts. I just tried to edit a few posts by other people and the page just reloaded without going anywhere, so it seems to work fine. Editing my own posts multiple times also works fine.
I did just find an interesting one while testing just now. I clicked Quote in this thread to type this post. In another browser tab, I clicked Edit to edit my own post and went no further. I came back to this browser tab and clicked Post Quoted Reply and got an error. I clicked the browser's back button and the displayed thread was the one I was editing in the other browser tab. I don't generally have multiple SSC tabs I'm editing and posting simultaneously, but stumbled across it while testing the edit button.
The error is:
Sorry the application encountered an unexpected error. Information about this error has been logged. If you continue to receive this message please contact the board administrator.
May 6, 2014 at 6:42 am
I thought I remembered a discussion here months ago about NOLOCK possibly returning bad data even when there's no changed to the table being queried, but now I can't find it. Am I misremembering?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 6, 2014 at 6:56 am
hisakimatama (5/1/2014)
Whew, busy times at work lately. I've been out of The Thread for a good bit :-).Anyone else from The Thread planning to attend this week's SQL Saturday in Atlanta? I noticed that Grant and Jason are both presenting a session there; I'll definitely be attending both! It's the first time I'll be at a programming-based activity, so I'm giddy about loading up with plenty of knowledge 😀
Better late than never - but hope you enjoyed the event.
Hope you enjoyed my session as well. Not sure if we had a chance to meet. Plenty of people stopping me.
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
May 6, 2014 at 7:45 am
Stefan Krzywicki (5/6/2014)
I thought I remembered a discussion here months ago about NOLOCK possibly returning bad data even when there's no changed to the table being queried, but now I can't find it. Am I misremembering?
NOLOCK can cause bad data (duplicate and/or missing) even with no changes being made to the table. It is unlikely, but possible. The reasoning mentioned was that SQL can decide to move a page in the middle of your read for Storage Optimization reasons and you would miss that page in the read. Or that you would read the page twice. I don't have the reference, unfortunately, but I think it was Ms. Shaw that pointed that out. I believe that Mr. Moden and maybe Hugo were also in on that discussion.
Viewing 15 posts - 43,831 through 43,845 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply