February 1, 2012 at 9:38 am
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
I agree especially when you are deleting anything. I hate when I have to make a change that could cause loss of data. For example, a current task I have put off is to move a column from one table to another. I realize that as long as the new column is populated correctly the old data can be reproduced, but I have a healthy dose of paranoia.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2012 at 9:46 am
Evil Kraig F (1/31/2012)
A
robotDBA may not injure data or, through inaction, allow data to come to harm.A
robotDBA must obey the orders given to it by managers, except where such orders would conflict with the First Law.A
robotDBA must protect its own existence as long as such protection does not conflict with HIPAA, SOX.[/quote-0]
That sounded better in my head, but SOX overrides the managers, so it loses the whole 'previous law' thing.
I LOVE it. Those books are among my all-time favorites.
As Gus suggested later that if you reverse the second and third laws and it would work great. You could put together an article based on those laws. I wish I'd have thought of doing something like that in the past. I'm not the most creative person in the world.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 1, 2012 at 9:52 am
Jack Corbett (2/1/2012)
Evil Kraig F (1/31/2012)
A
robotDBA may not injure data or, through inaction, allow data to come to harm.A
robotDBA must obey the orders given to it by managers, except where such orders would conflict with the First Law.A
robotDBA must protect its own existence as long as such protection does not conflict with HIPAA, SOX.[/quote-0]
That sounded better in my head, but SOX overrides the managers, so it loses the whole 'previous law' thing.
I LOVE it. Those books are among my all-time favorites.
As Gus suggested later that if you reverse the second and third laws and it would work great. You could put together an article based on those laws. I wish I'd have thought of doing something like that in the past. I'm not the most creative person in the world.
I would modify Craig's second law23 to read "... except when such orders are likely to make the DBA a sacrificial lamb for managers' mistakes."
February 1, 2012 at 10:14 am
mtillman-921105 (1/31/2012)
OCTom (1/31/2012)[hr
A link for SQL geometry.
http://msdn.microsoft.com/en-us/library/cc280487.aspx
What I'm waiting for is the SQL Astrology data type. That way I can write joins on people who are compatible.
Would those be left, right, or inner joins? I suppose a self join would be out! 🙂
It depends on one's political view. I tend to be right of center, so, I guess a right join would be best.
Most people just say that I'm off center, anyway.
February 1, 2012 at 10:40 am
Calling for backup here, if you could. Guy's got data that apparently is inconstently left out of his query in what he swears is a static system. I'm not sure what else to ask the guy to try to get him out of his jam.
He's either ESL or a newbie, so patience is required. I'm hoping slightly different phrasing, at least, may be able to help him understand better. Thanks folks.
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
February 1, 2012 at 10:48 am
L' Eomot Inversé (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Is this guy annoying the hell out of anyone else?Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.
Looks like a language-barrier thing to me. At least mostly that.
You mean johnitech.itech maybe doesn't understand the topics he's responding on? Or maybe doesn't understand the articles he's linking in his responses?
I don't see any spam there, but I also don't see anything useful either (e.g. a link to a boring SQL 2000 merge replication overview article isn't going to help anyone troubleshoot an SQL 2008 R2 Merge problem) and all his posts (as far as I've checked) seem to be either unhelpful links or unhelpful something else. I suppose it could be a language problem (he's said "I don't understand" at least once) but it doesn't really seem to fit a language problem pattern.
I'm talking about the pattern of use of the language. "I'm not understand" type stuff. His posts, except where he's copy-and-pasting from somewhere else, show a pattern, but not a usual English-native one. I'm used to the Spanish, French, German, Hindi, Chinese, and Japanese patterns of ESL English-use, and it doesn't appear to be one of those. Though I am rusty on those (recently thought I was seeing a German pattern, turned out it was Romanian), so I could be wrong. There are also pattern differences to Anglo-English (I hate that redundancy, but it's necessary these days), US-English, Australian-English, Indian-English, et al, with Hong Kong-English being the most divergent pattern while still being "grew up speaking English". All recognizable patterns if you're used to them.
What I see in his posts is ESL grammatical patterns (verb conjugation issues, adj/adv sequence/voice issues, pronoun awkwardness), just not one I'm used to.
So, not so much "doesn't understand what he's replying to" as much as "his posts are hard to understand because of comm protocol violations". The fact that they're only partially sequitur in many cases doesn't render them spam-like, in my opinion.
(And there I go again with far too much answer to such a simple question.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 1, 2012 at 10:48 am
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Is this guy annoying the hell out of anyone else?Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.
Looks like a language-barrier thing to me. At least mostly that.
I'm not sure there's anything wrong here. That's his only post, and it seems he/she is trying to lay out an issue. Can I ask what's annoying?
I'm definitely talking about the replier, not the OP, in that one. That's who I thought Howard meant.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 1, 2012 at 10:52 am
Jack Corbett (2/1/2012)
Evil Kraig F (1/31/2012)
A
robotDBA may not injure data or, through inaction, allow data to come to harm.A
robotDBA must obey the orders given to it by managers, except where such orders would conflict with the First Law.A
robotDBA must protect its own existence as long as such protection does not conflict with HIPAA, SOX.[/quote-0]
That sounded better in my head, but SOX overrides the managers, so it loses the whole 'previous law' thing.
I LOVE it. Those books are among my all-time favorites.
As Gus suggested later that if you reverse the second and third laws and it would work great. You could put together an article based on those laws. I wish I'd have thought of doing something like that in the past. I'm not the most creative person in the world.
I think Phil Factor may have already done so. Not sure, but it sounds familiar from years ago.
If he hasn't, would definitely be an entertaining read if he did!
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 1, 2012 at 11:03 am
Jack Corbett (2/1/2012)
Evil Kraig F (1/31/2012)
A
robotDBA may not injure data or, through inaction, allow data to come to harm.A
robotDBA must obey the orders given to it by managers, except where such orders would conflict with the First Law.A
robotDBA must protect its own existence as long as such protection does not conflict with HIPAA, SOX.[/quote-0]
That sounded better in my head, but SOX overrides the managers, so it loses the whole 'previous law' thing.
I LOVE it. Those books are among my all-time favorites.
As Gus suggested later that if you reverse the second and third laws and it would work great. You could put together an article based on those laws. I wish I'd have thought of doing something like that in the past. I'm not the most creative person in the world.
I always liked the Caves of Steel description of the enormous city in those books. The funny thing is that with a population density of just 20,000 people per square mile (equivalent to Boston and its suburbs) you could fit the entire population of the USA in the Boston-Washington corridor, much like in the books, but much more livable.
--------------------------------------
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
February 1, 2012 at 6:31 pm
Prior last post Posted Today @ 1:03 PM
Now 8:25 PM DECLARE @t TIME
SELECT @t = '7:22'
SELECT DATEDIFF(mi, 0, @t)
Which is 442 minutes
What did the site crash, this thread get too long ?
February 1, 2012 at 6:39 pm
bitbucket-25253 (2/1/2012)
Prior last post Posted Today @ 1:03 PMNow 8:25 PM
DECLARE @t TIMESELECT @t = '7:22'
SELECT DATEDIFF(mi, 0, @t)
Which is 442 minutes
What did the site crash, this thread get too long ?
Naah, we're not up to a smallint yet.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 2, 2012 at 1:59 am
GSquared (2/1/2012)
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Is this guy annoying the hell out of anyone else?Not sure whether to call it spam or not, but most of his posts wouldn't pass the Turing Test.
Looks like a language-barrier thing to me. At least mostly that.
I'm not sure there's anything wrong here. That's his only post, and it seems he/she is trying to lay out an issue. Can I ask what's annoying?
I'm definitely talking about the replier, not the OP, in that one. That's who I thought Howard meant.
Yes, definitely talking about the replier. I've no problem at all with the use of language, just the inane random posting of links that sound a bit like the subject, but provide no actual help.
More examples yesterday include:
http://www.sqlservercentral.com/Forums/Topic1245163-391-1.aspx#bm1245503
and
http://www.sqlservercentral.com/Forums/Topic1245368-391-1.aspx#bm1245506
This one appears lucid and on topic:
http://www.sqlservercentral.com/Forums/Topic1245302-391-1.aspx#bm1245410
But is in fact completely ripped off from the KB article linked and here (unlinked):
February 2, 2012 at 2:02 am
I know that Google is restricted in China, but is it totally banned in India or something?
http://www.sqlservercentral.com/Forums/Topic1245517-391-1.aspx?Update=1
(yes, I'm grumpy. Baby is stealing away much much needed sleep)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 2, 2012 at 2:11 am
Koen Verbeeck (2/2/2012)
I know that Google is restricted in China, but is it totally banned in India or something?http://www.sqlservercentral.com/Forums/Topic1245517-391-1.aspx?Update=1
A beautifully researched and detailed question:
I have to insert data from excel sheet to sql server table.
so can you please provide me the solution for how to do this in details.
I am using sql server 2008.
I just pass these by completely. On other sites, the question would simply be closed or deleted as too poor to exist.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
February 2, 2012 at 2:15 am
SQL Kiwi (2/2/2012)
I just pass these by completely. On other sites, the question would simply be closed or deleted as too poor to exist.
Are you saying we are too nice for the Internet? 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 34,111 through 34,125 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply