Are the posted questions getting worse?
-
-
L' Eomot Inversé (1/9/2012)
Brandie Tarvin (1/9/2012)
@set Snobby = On;Ex-squeeze me. My fiction does not "waste time." It is Art (with a capital A, even). True Art is never a waste of anyone's time as its edification capabilities enhance our cultural zeitgheist.
@set Snobby = Off;
Set Pedantic = On; Set BadJokes = On
Do they also enhance hour "h"-haddition capabilities? hIs this han h
aArtistic hattempt to hout do Catullus, hor perhaps heven Catullus's hArrius? (hI mean the hwon wot chommoda dicebat quando commoda dicere velit.)Set BadJokes = Off; Set Pedantic = Off;
So funny I can't even START laughing! :hehe:
Seriously, didn't get a single word in that post.
-
Jeff Moden (1/7/2012)
L' Eomot Inversé (1/7/2012)
Brandie Tarvin (1/6/2012)
At the risk of being virtually lynched, I can see the use in underscores in table names and especially in constraint names.I use them in constraint names; sometimes also to separate prefixes in table names (eg when I have a bunch of a couple of dozent tables concerned with music those table names might all begin begin Music_; but the also might have teh "_", it depends whether there's already an established convention that _ is used that way in this database); very rarley for anything else.
I shall now run away and hide before anyone finds the pork chop launcher.
I won't run away and hide, but I'm wearing my pork chop proof hat and box for the rest of today, just in case.
No porkchops to offer on the subject of underscores. I just think they're a PITA to type and, for me anyway, they actually make complex code a bit more difficult to read (which is probably exactly the opposite that others think).
They do have their uses and yeah, I do use them for index names (eg: IX_SomeTableName_SomeColumnName_SomeOtherColumnName), constraint names (eg: PK_SomeTableName), etc. I very rarely use them for column names although I've used them there for certain prefixes as well. I really don't like to see underscores being used as a replacment for title-casing where someone separates all upper or lower cased words with underscores.
Still, if you're really interested in seeing me raise hell and prop it up on pile of porkchops, let's talk about the position of commas, mathematical operators, and column aliases. 😀
Ditto on index and constraint names. I also use underscores in many-to-many relationship table names (e.g.: "Orders_Jobs" in one database where orders were split into multiple jobs and a job could come from multiple orders).
Agree with you on readability. Lots of studies on the subject in the world of typography and typesetting, and CamelCase is generally faster for both sight-reading and comprehension than Under_Scores. CONSTANTCASE (or constantcase) is the slowest standard method for either item.
- 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
-
I use spaces in my constraint and index names 😛
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
Roy Ernest (1/9/2012)
I see lots of comments regarding post counts... Does everybody have a target? I have never thought about it at all.When I get time post some thing, Thats it. 🙂
I don't set a quantitative target on that. Just help where I can.
- 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
-
Paul's contest with Jack makes me think of this movie a few years back. A new electronic voting program is supposed to be the best thing in the universe, but the code gives politicians votes based on their initials and how the initials rank in the alphabet. An "A" ranks higher than a "C" for instance. And if the candidate has double initials "HH" or "JJ", they rank higher than the single initial candidates.
Jack's first and last name will always outrank Paul's first and last name, so the only way Paul can get ahead in the SSC leaderboard is to outsmart the system (or change his name). Right? @=)
Yeah, just ignore me today. I'm not making any sense, am I?
-
GilaMonster (1/9/2012)
Ninja's_RGR'us (1/9/2012)
There was a time I loved fiction, got any books to recommend?Yes
http://sqlinthewild.co.za/index.php/2012/01/01/2011-book-review/
http://sqlskills.com/BLOGS/PAUL/post/2011-the-year-in-books.aspx
We both have 2010 posts as well if you feel like hunting
I threw this to Steve last week too, Jo Walton has some pretty good reviews, so I would bet you could get some good material by culling this list:
http://www.tor.com/features/series/ok-where-do-i-start-with-that
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"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."
-
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛I don't set a quantitative target on that.
Just like my naming standard of Caps on Consonants and lower case for vowels?
note: i merged Paul's post and Gus' post when reading the thread and thought it was funny. Completely missed that Gus was quoting Roy (at first).
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 -
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛And spell out table names as grammatically correct sentences, including punctuation?
create table dbo.[These are orders placed by our customers.] ([A numerical code assigned to the order. This is a surrogate key for the table.] int identity primary key,
...)
🙂
- 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
-
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛And spell out table names as grammatically correct sentences, including punctuation?
create table dbo.[These are orders placed by our customers.] ([A numerical code assigned to the order. This is a surrogate key for the table.] int identity primary key,
...)
🙂
In Klingon
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]"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."
-
SQLRNNR (1/9/2012)
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛I don't set a quantitative target on that.
Just like my naming standard of Caps on Consonants and lower case for vowels?
note: i merged Paul's post and Gus' post when reading the thread and thought it was funny. Completely missed that Gus was quoting Roy (at first).
Garbled or not, it does end up being a true statement. I don't set a quantitative target for spaces in constraint and index names. True. :w00t:
- 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
-
jcrawf02 (1/9/2012)
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛And spell out table names as grammatically correct sentences, including punctuation?
create table dbo.[These are orders placed by our customers.] ([A numerical code assigned to the order. This is a surrogate key for the table.] int identity primary key,
...)
🙂
In Klingon
Geeks.
-
Brandie Tarvin (1/9/2012)
Jack's first and last name will always outrank Paul's first and last name, so the only way Paul can get ahead in the SSC leaderboard is to outsmart the system (or change his name). Right? @=)🙁 :crying:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
GSquared (1/9/2012)
SQL Kiwi (1/9/2012)
I use spaces in my constraint and index names 😛And spell out table names as grammatically correct sentences, including punctuation?
No, that would be silly 😛
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi -
SQL Kiwi (1/9/2012)
Brandie Tarvin (1/9/2012)
Jack's first and last name will always outrank Paul's first and last name, so the only way Paul can get ahead in the SSC leaderboard is to outsmart the system (or change his name). Right? @=)🙁 :crying:
Try changing your screen name. Maybe that'll work. @=)
Viewing 15 posts - 33,421 through 33,435 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply