March 3, 2014 at 12:52 pm
Gazareth (3/3/2014)
Lichfield & its cathedral are about 30 minutes eastwards.
However it might be better to go westwards: Shrewsbury is much closer than Lichfield, it has Shrewsbury Castle and the Abbey Church (two examples of medieval architecture) and also Shrewsbury Cathedral (built in the 1850s), plus a whole pile of historic buildings including some fairly early ones, and it's the right direction for Wales as well. Heading North from Shrewsbury it is not far to Chirk, with another interesting castle. NE Wales has several castles, but they are all total ruins so not very interesting from an architecture viewpoint (Wales probably has more medieval castles than any other chunk of land the same size anywhere in the world; unfortunately most are ruins), but heading NW from Chirk it's not too far to Conwy, in North Wales, where the medieval town wall is still fairly complete and the castle, although somewhat dilapidated, is in far better condition that anything in NE Wales. Going west along the north coast of Wales you would find Beaumaris, with a 14th century Church and another somewhat dilapidated medieval castle (said to have been the strongest medieval castle in Britain) , and the next interesting point is Caernarfon where the medieval castle is very well preserved - well enough to be used for the investiture of both Princes of Wales in the 20th century (Edward in 1911, Charles in 1969). There's plenty more to see in Wales, of course. St David's is worth a visit, as is Pembroke, and many other places.
Tom
March 4, 2014 at 3:24 am
Tom,
Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.
Deciding whether to wait for the discount codes on the three hotels - all of which seem rather expensive at normal rates or hunt around for a nice cosy B&B.
Rodders...
March 4, 2014 at 3:33 am
rodjkidd (3/4/2014)
Tom,Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.
Deciding whether to wait for the discount codes on the three hotels - all of which seem rather expensive at normal rates or hunt around for a nice cosy B&B.
Rodders...
Shrewsbury (not Shrowsbury as the BBC insist on calling it) has many gorgeous timber-frame buildings and one or two very special churches for the stained glass admirer. Now it has a Loch Fyne restaurant, it's worth an overnight stay too.
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
March 4, 2014 at 3:48 am
ChrisM@Work (3/4/2014)
rodjkidd (3/4/2014)
Tom,Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.
Deciding whether to wait for the discount codes on the three hotels - all of which seem rather expensive at normal rates or hunt around for a nice cosy B&B.
Rodders...
Shrewsbury (not Shrowsbury as the BBC insist on calling it) has many gorgeous timber-frame buildings and one or two very special churches for the stained glass admirer. Now it has a Loch Fyne restaurant, it's worth an overnight stay too.
I come from the West Midlands and I've been to Shrewsbury loads of times as I have/had several relatives who lived there and nearby. A little further west is Welshpool and Powis Castle to take in a little more old architecture.
March 4, 2014 at 4:59 am
MysteryJimbo (3/4/2014)
ChrisM@Work (3/4/2014)
rodjkidd (3/4/2014)
Tom,Shrewsbury - somewhere else that's on my "yet to visit" list. I'm getting almost as much out of this discussion as Gail is.
Deciding whether to wait for the discount codes on the three hotels - all of which seem rather expensive at normal rates or hunt around for a nice cosy B&B.
Rodders...
Shrewsbury (not Shrowsbury as the BBC insist on calling it) has many gorgeous timber-frame buildings and one or two very special churches for the stained glass admirer. Now it has a Loch Fyne restaurant, it's worth an overnight stay too.
I come from the West Midlands and I've been to Shrewsbury loads of times as I have/had several relatives who lived there and nearby. A little further west is Welshpool and Powis Castle to take in a little more old architecture.
I really didn't use my time in the West Midlands well did I? So many places I should have visited, almost on my doorstep. But then I had a friend in Coventry who had never been to the Bullring! Although she's not really a shopper, it's worth it to see the two bulls, the real statue and the Jelly Belly one in Selfridges 🙂
I did live outside the cross that supposedly marked the centre of England, and shopped at the Heart of England Co-op. Only it wasn't they re-worked out the centre and it was a few miles north - oh well. Nearer Fillongley, I believe. That name always makes me laugh.
Rodders...
March 5, 2014 at 3:16 am
Ed Wagner (3/3/2014)
Steve Jones - SSC Editor (3/3/2014)
Ed Wagner (3/3/2014)
Steve Jones - SSC Editor (3/3/2014)
Steve Jones - SSC Editor (3/3/2014)
Going to submit to SQLBits. Gonna be a busy summer, it looks like.I am. Might be slightly longer in real time as I might interrupt for a few events.
So how's the knee?
hurts, sore, 7wks to cut
Meaning 7 more weeks until surgery?
Yes, Apr 25 is the date. Trying to exercise and strengthen it before then
March 5, 2014 at 7:56 am
Hey folks. so what's I miss?
😀
[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 5, 2014 at 7:59 am
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.
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 5, 2014 at 8:05 am
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.
[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 5, 2014 at 8:29 am
RBarryYoung (3/5/2014)
Hey folks. so what's I miss?😀
All the questions on the site have suddenly become well researched an insightful explorations of the deeper meaning of data, databases, disaster recovery and all other aspects of our business. You can learn as much from reading the questions now as you do from some of the answers. It's become a ....
Ah, who am I kidding.
Same ole, same ole. Providing tech support to parts of the world that are incapable of reading documentation and telling people that, yes, your backups are important, and no, we can't recover that table you dropped yesterday.
How're things?
"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 5, 2014 at 8:54 am
Grant Fritchey (3/5/2014)
All the questions on the site have suddenly become well researched an insightful explorations of the deeper meaning of data, databases, disaster recovery and all other aspects of our business. You can learn as much from reading the questions now as you do from some of the answers. ...
Hmm, I'm pretty sure that's one of the seven signs of the apocalypse.
Same ole, same ole. Providing tech support to parts of the world that are incapable of reading documentation and telling people that, yes, your backups are important, and no, we can't recover that table you dropped yesterday.
Wow, Microsoft still hasn't fixed that "Dropped Table" bug? 😀
How're things?
OK. The kids have finally moved out and are on their own. We think it may stick this time. The wife and I are busy selling the house so we can move into a smaller place. Business is good for now, but nothing much new.
[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 5, 2014 at 9:57 am
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.
Are you better now?
I can't remember which script it was - it was in response to a thread you had answered here on SSC, but the script you provided was linked to your site. Somebody was having problems with it and I was gonna try to help.
You might have an email somewhere if you are still subscribed to that thread. It will take me some time to dig which one it was about.
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 5, 2014 at 10:01 am
Welcome back, Barry. Good to see your smiling face again.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 5, 2014 at 10:31 am
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...)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 5, 2014 at 10:53 am
Evil Kraig F (3/5/2014)
Other than I apparently created a 3! point question for the QotD... 😎(I didn't think it was THAT difficult...)
It was very misleading though 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 43,141 through 43,155 (of 66,738 total)
You must be logged in to reply to this topic. Login to reply