SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Where a Rose is not a rose…


Where a Rose is not a rose…

Author
Message
Phil Factor
Phil Factor
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4922 Visits: 3031
Comments posted to this topic are about the item Where a Rose is not a rose…


Best wishes,

Phil Factor
Simple Talk
Don Green
Don Green
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 15
{
sure it wasn't the waggon and horses pub you were going to, rather than the Wagon and Horses Pub?
}
ben.mcintyre
ben.mcintyre
Old Hand
Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)Old Hand (373 reputation)

Group: General Forum Members
Points: 373 Visits: 403
Funny, but I can hear a voice screaming at me somewhere around the back of my head. It's saying 'Visual Basic' ...
Andy in Pembs
Andy in Pembs
SSC-Enthusiastic
SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)SSC-Enthusiastic (177 reputation)

Group: General Forum Members
Points: 177 Visits: 40
Funny that Ben, just what I was thinking.
A very insightful piece, Phil, struck a chord with me.

Now this may be a little off-topic but understanding what people are asking / describing reminds me of an incident years (and years!) back where three of us from one major Bank IT office were seconded to another in London, and were being shown a demo by someone – lets just call him “Bob”.
This was back in the days where you actually typed "win" to start windows, and Bob typed "win:" so one of us asked "What's the colon for?"
Well Bob started to spiel off what happens when you eat food, going into detail about the large intestine, small intestine, rectum and of course, the colon, while the three of us exchanged silent, bemused and amused glances, not wanting to stop Bob who was in full flow, and obviously thought that the supposed question about the part of the body was completely normal for one of his demos.
Incidentally the colon was to start windows without the splash screen.
Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18981 Visits: 12426
While I mostly agree with the sentiment expressed in the editorial, there is one place where I don't. Where, in fact, I'd even reverse the statement:

"There really is little justification for not having a case-sensitive collation for database on a dev server"

When developing code, you can never be entirely sure what server(s) it will be deployed on. One of them could be neglecting Phil's good advice and using a case sensitive collation. And surely, you would not want your deployment fail because users get bucketloads of "Table cUstOMer not found" errors, because the table is acutally called "CusTOmeR".

Make sure you always develop and test on a case-sensitive server, and you'll never have these problems.

(And an added benefit is that you don't get the confusion sometimes caused by using different case for the same object in the same query).


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Ewan Hampson
Ewan Hampson
Right there with Babe
Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)Right there with Babe (726 reputation)

Group: General Forum Members
Points: 726 Visits: 1826
Unless we can devise special sounds for curly brackets (open and close), semi-colons and maybe an altered intonation for upper-case

Not sure about upper/lower case, but Victor Borge's phonetic punctuation could fit the bill... (I can't check out video/audio links at work, but you know where to search...)
Shaun McGuile
Shaun McGuile
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 1060
How archaic is talking some one through code?

Did you not have a smart device - and type the SQL then electronically send it to the guy so he could just cut and paste the code into place?

No?

How last year are you? ;-)

Hiding under a desk from SSIS Implemenation Work Crazy
Phil Factor
Phil Factor
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4922 Visits: 3031
"There really is little justification for not having a case-sensitive collation for database on a dev server"


Hugo, I heartily agree with the sentiment, but I hate to actually recommend having a case-sensitive DEV machine because developers tend to get bored with correcting errors in their perfectly sensible mixed-case object names and just do everything in lower case. I've seen it happen so many times. It is precisely what you want to avoid. What we need instead is a utility that takes the original names in the metadata, complete with their original capitalisation, and creates a script that corrects the case of the names elsewhere in all the code that references the object, according to the original definition. Hmm... Maybe I shall write such a thing. I'm hopeless at remembering capitalisation, which is why I'm hopeless at JavaScript (or is it Javascript?)


Best wishes,

Phil Factor
Simple Talk
Phil Factor
Phil Factor
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4922 Visits: 3031
Did you not have a smart device - and type the SQL then electronically send it to the guy so he could just cut and paste the code into place?


I'd have given my eye-teeth for a remote app that gives an unpleasant electric shock to the holder of an iPhone whilst you're talking to him, when he is in panic-mode. Like the movies where they give a hysterical person a sharp slap and they're then instantly OK.


Best wishes,

Phil Factor
Simple Talk
jcrawf02
jcrawf02
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5020 Visits: 19324
Phil Factor (5/21/2010)
Did you not have a smart device - and type the SQL then electronically send it to the guy so he could just cut and paste the code into place?


I'd have given my eye-teeth for a remote app that gives an unpleasant electric shock to the holder of an iPhone whilst you're talking to him, when he is in panic-mode. Like the movies where they give a hysterical person a sharp slap and they're then instantly OK.
Now THAT's progress! Would it work through a bluetooth earpiece?

---------------------------------------------------------
How best to post your question
How to post performance problems
Tally Table:What it is and how it replaces a loop

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search