May 16, 2009 at 3:17 am
WayneS (5/15/2009)
Now THAT looks like a nice place to relax
Thanks Wayne (and Flo from earlier). It's fascinating to see where everyone is from - can't believe this hasn't been done before!
On the corruption subject, I had an interesting discussion once with some one who had stopped taking backups altogether because (a) they took too long and used too much space; and (b) they had just upgraded to 2K5 and turned on the CHECKSUM page verify option. Apparently that negates the need for backups. Scary eh?
A combined effort from a number of people managed to change his mind...eventually.
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 16, 2009 at 9:10 pm
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?
Heh... don'cha just love homework, test, or interview questions?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2009 at 1:54 am
Hey Paul
Nice new avatar! Is it Raumati Beach?
May 17, 2009 at 5:31 am
May 17, 2009 at 5:33 am
Florian Reischl (5/17/2009)
Nice new avatar! Is it Raumati Beach?
It is indeed! It is a view from Matatua Road over the sea toward Kapiti Island.
Thought it time for an avatar change - no hope of keeping up with Bob though!!!
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
May 17, 2009 at 7:08 am
GilaMonster (5/15/2009)
GSquared (5/15/2009)
Gail: Check out the second story on this page[/url]. You'll get a chuckle out of it.Hehe. That's not an uncommon comment. I showed someone a photo of me (attached) once (the same one I use as an avatar here) and their next question was along the lines of 'Is that how you get to work?' (asked seriously)
Anyone like to guess where that photo was actually taken?
Loved the 'twit' in the comments too:
"Seriously, guy doesn't even recognise the capital city of South Africa!
Oh wait, or is that Johannesburg...? "
It's neither. The capital's Pretoria.
Gail, you are misleading the fellows here. The last time I checked there are three capitals. Parliament sitting in Cape Town (yes, Luthuli House wouldn't mind that being moved to a more ANC-friendly place), Constitutional Court in Bloemfontein, and the President plus administration sitting in Pretoria.
As to where the picture was taken, the elephant, judging by its rather small ears, could well be an Indian one. Then again, maybe it was a young female. Background picture fits in with the area around Pelindaba.
May 17, 2009 at 7:22 am
Jan Van der Eecken (5/17/2009)
GilaMonster (5/15/2009)
GSquared (5/15/2009)
Gail: Check out the second story on this page[/url]. You'll get a chuckle out of it.Hehe. That's not an uncommon comment. I showed someone a photo of me (attached) once (the same one I use as an avatar here) and their next question was along the lines of 'Is that how you get to work?' (asked seriously)
Anyone like to guess where that photo was actually taken?
Loved the 'twit' in the comments too:
"Seriously, guy doesn't even recognise the capital city of South Africa!
Oh wait, or is that Johannesburg...? "
It's neither. The capital's Pretoria.
Gail, you are misleading the fellows here. The last time I checked there are three capitals. Parliament sitting in Cape Town (yes, Luthuli House wouldn't mind that being moved to a more ANC-friendly place), Constitutional Court in Bloemfontein, and the President plus administration sitting in Pretoria.
As to where the picture was taken, the elephant, judging by its rather small ears, could well be an Indian one. Then again, maybe it was a young female. Background picture fits in with the area around Pelindaba.
Ooops, apologies Gail, I should first have caught up with the 50-odd posts I hadn't seen yet.
May 17, 2009 at 7:41 am
Jeff Moden (5/16/2009)
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?Heh... don'cha just love homework, test, or interview questions?
Jeff, you left out a possibility. Exceeded the max number of ixdexes allowed on the same table. :o)
Anyone that ever runs into that one needs to review their use of indexes.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 17, 2009 at 7:47 am
Since Lynn calls this place the Water Cooler, I thought I'd give it a bash and ask you guys who are in the US a totally off-topic question.
I'm a committee member of a baseball club down here at the tip of Africa. Yes, we do indeed play this All-American sport down here, got a nice league with about 15 clubs running in Cape Town ;-). As you can imagine it is however a bit difficult to source equipment, so my question is whether any one of you has contacts, be it family or friends or just acquaintances, who deal in baseball gear? Balls are not an issue, we can source them here for about 60 Rand (plus-minus 7 US$). What we do need is catchers' harnesses, mits, helmets, bats etc. So if anyone of you can point me to a trustworthy link it would be very much appreciated, especially by the 60-odd kids from the townships that attend our development academy.
Please, don't go running off searching. If you don't know of anyone, just ignore this post.
May 17, 2009 at 9:38 am
Jan Van der Eecken (5/17/2009)
Since Lynn calls this place the Water Cooler, I thought I'd give it a bash and ask you guys who are in the US a totally off-topic question.I'm a committee member of a baseball club down here at the tip of Africa. Yes, we do indeed play this All-American sport down here, got a nice league with about 15 clubs running in Cape Town ;-). As you can imagine it is however a bit difficult to source equipment, so my question is whether any one of you has contacts, be it family or friends or just acquaintances, who deal in baseball gear? Balls are not an issue, we can source them here for about 60 Rand (plus-minus 7 US$). What we do need is catchers' harnesses, mits, helmets, bats etc. So if anyone of you can point me to a trustworthy link it would be very much appreciated, especially by the 60-odd kids from the townships that attend our development academy.
Please, don't go running off searching. If you don't know of anyone, just ignore this post.
But that isn't how a community works. If we don't know, we'll start asking around. I don't know, but you can be sure I'll start asking a few people I know questions. Hopefully I'll get an answer I can post back.
May 17, 2009 at 9:39 am
Alvin Ramard (5/17/2009)
Jeff Moden (5/16/2009)
Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?Heh... don'cha just love homework, test, or interview questions?
Jeff, you left out a possibility. Exceeded the max number of ixdexes allowed on the same table. :o)
Anyone that ever runs into that one needs to review their use of indexes.
Heh... that's why I said that "it contains many of the reasons you seek" instead of "all". Gotta leave some reasons for them to find on their own. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
May 17, 2009 at 10:00 am
Jan,
Good to hear you play baseball down under.
I've used Baseball Warehouse, but that's in the US. Not sure about shipping things to SA. You might also try Play It Again sports. They're local stores in places in the US, with a mix of new and used equipment. However they might take a large order from you and send a mix of new and used stuff at a good price. Often it's equipment someone bought for their kids and then their kids gave up the game.
If you come to PASS, I have a kids aluminum bat I'll bring and donate to you.
May 17, 2009 at 10:04 am
Lynn Pettis (5/17/2009)
Jan Van der Eecken (5/17/2009)
Since Lynn calls this place the Water Cooler, I thought I'd give it a bash and ask you guys who are in the US a totally off-topic question.I'm a committee member of a baseball club down here at the tip of Africa. Yes, we do indeed play this All-American sport down here, got a nice league with about 15 clubs running in Cape Town ;-). As you can imagine it is however a bit difficult to source equipment, so my question is whether any one of you has contacts, be it family or friends or just acquaintances, who deal in baseball gear? Balls are not an issue, we can source them here for about 60 Rand (plus-minus 7 US$). What we do need is catchers' harnesses, mits, helmets, bats etc. So if anyone of you can point me to a trustworthy link it would be very much appreciated, especially by the 60-odd kids from the townships that attend our development academy.
Please, don't go running off searching. If you don't know of anyone, just ignore this post.
But that isn't how a community works. If we don't know, we'll start asking around. I don't know, but you can be sure I'll start asking a few people I know questions. Hopefully I'll get an answer I can post back.
Thanks Lynn, I appreciate it, but please don't spend too much effort on it.
May 17, 2009 at 10:14 am
Steve Jones - Editor (5/17/2009)
Jan,Good to hear you play baseball down under.
I've used Baseball Warehouse, but that's in the US. Not sure about shipping things to SA. You might also try Play It Again sports. They're local stores in places in the US, with a mix of new and used equipment. However they might take a large order from you and send a mix of new and used stuff at a good price. Often it's equipment someone bought for their kids and then their kids gave up the game.
If you come to PASS, I have a kids aluminum bat I'll bring and donate to you.
Heh Steve, the Ozzies would object calling SA down-under. They somehow have a trademark on this term. But thanks for the tips so far. I'm not gonna make it to PASS simply for a lack of funds. But if you are serious about donating a bat, why don't you hand it to Gail? We would surely figure out a way to get it down to CT. And take a pic of the handing-over for the clubhouse picture gallery!
Viewing 15 posts - 4,546 through 4,560 (of 66,708 total)
You must be logged in to reply to this topic. Login to reply