Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 30,136 through 30,150 (of 66,712 total)

You must be logged in to reply to this topic. Login to reply

GSquared SSC Guru Points: 260824 More actions · Answer 1

L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:

Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)

- 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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:
Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)

While you're at it, could you reduce the supply of apostrophes please. I'd like to inhibit monstrosities like "CD's for sale"

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

GSquared SSC Guru Points: 260824 More actions · Answer 3

GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:
Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)
While you're at it, could you reduce the supply of apostrophes please. I'd like to inhibit monstrosities like "CD's for sale"

Actually, by this theory, a good, well-nested dynamic SQL string should be able to glut the market on apostrophe's completely. -- couldn't resist

- 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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

GSquared (9/20/2011)
GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:
Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)
While you're at it, could you reduce the supply of apostrophes please. I'd like to inhibit monstrosities like "CD's for sale"
Actually, by this theory, a good, well-nested dynamic SQL string should be able to glut the market on apostrophe's completely. -- couldn't resist

I think I have just the nested dynamic sql cursor to fit the bill.

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

SQLRNNR (9/20/2011)
GSquared (9/20/2011)
GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:
Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)
While you're at it, could you reduce the supply of apostrophes please. I'd like to inhibit monstrosities like "CD's for sale"
Actually, by this theory, a good, well-nested dynamic SQL string should be able to glut the market on apostrophe's completely. -- couldn't resist
I think I have just the nested dynamic sql cursor to fit the bill.

No need for a cursor, some double-hop OPENQUERY with dynamic SQL fun will do the job just fine.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

GilaMonster (9/20/2011)
SQLRNNR (9/20/2011)
GSquared (9/20/2011)
GilaMonster (9/20/2011)
GSquared (9/20/2011)
L' Eomot Inversé (9/20/2011)
WayneS (9/20/2011)
GSquared (9/20/2011)
Of course, I'm also one of the few people I know who tries to terminate every T-SQL statement with a semicolon. Not needed, but it keeps things tidy in my opinion, and MS does say it will be needed in a future version (http://msdn.microsoft.com/en-us/library/ms177563.aspx).
I try to do so also... and our Jr is getting tired of code being returned because they don't have them, so he's starting to also.
But think of the damage you may be causing - a world shortage of semicolons resulting from overuse by certain people would be a major catastrophe. :hehe::hehe::hehe:
Actually, it works the other way around. We're increasing the supply without increasing the demand, and driving the price of semicolons down. Semicolon futures are down by about half so far, and don't look like they've hit bottom yet. If you have them in your 401(k), sell now before it gets even worse! (I'm aiming for a bear market on punctuation in general.)
While you're at it, could you reduce the supply of apostrophes please. I'd like to inhibit monstrosities like "CD's for sale"
Actually, by this theory, a good, well-nested dynamic SQL string should be able to glut the market on apostrophe's completely. -- couldn't resist
I think I have just the nested dynamic sql cursor to fit the bill.
No need for a cursor, some OPENQUERY with dynamic SQL fun will do the job just fine.

Oh ok - just saying I already have a query that is a dynamic sql nested cursor, blah blah blah:-D:-D:-D:-D

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

LutzM SSC Guru Points: 107049 More actions · Answer 7

We just need to be careful: once we're short on apostrophes, quite a few letters (including the "blank") will be in highe demand, too. (It's vs. it is not, won't vs. will not a.s.o.).

I guess that's one of the major reason behind the goal to avoid c.u.r.s.o.r.'s *cough* and loop's. Better performance is just a side effect. 😀

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Paul White SSC Guru Points: 150467 More actions · Answer 8

Amateurs.

SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)

Apostrophes all gone :laugh:

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

LutzM (9/20/2011)
We just need to be careful: once we're short on apostrophes, quite a few letters (including the "blank") will be in highe demand, too. (It's vs. it is not, won't vs. will not a.s.o.).

Maybe then fantasy and sci-fi authors will stop inflicting things like B'Z'or'ef, K'chak'!'op and Ph'nglui Mglw'nafh Cthulhu R'lyeh on us.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)
Apostrophes all gone :laugh:

Memory too. :crash:

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Paul White SSC Guru Points: 150467 More actions · Answer 11

GilaMonster (9/20/2011)
SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)
Apostrophes all gone :laugh:
Memory too. :crash:

I actually tried running this command before I posted it. :pinch:

I clicked 'cancel' nearly ten minutes ago now :crying:

I wonder if I'll get a blue sc

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

SQL Kiwi (9/20/2011)
GilaMonster (9/20/2011)
SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)
Apostrophes all gone :laugh:
Memory too. :crash:
I actually tried running this command before I posted it. :pinch:
I clicked 'cancel' nearly ten minutes ago now :crying:
I wonder if I'll get a blue sc

Sounds production worthy, right?

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 13

SQL Kiwi (9/20/2011)
GilaMonster (9/20/2011)
SQL Kiwi (9/20/2011)
Amateurs.
SELECT REPLICATE(CONVERT(VARCHAR(MAX), CHAR(39)), 9223372036854775807)
Apostrophes all gone :laugh:
Memory too. :crash:
I actually tried running this command before I posted it. :pinch:
I clicked 'cancel' nearly ten minutes ago now :crying:
I wonder if I'll get a blue sc

Famous last words :-D.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 14

Ninja's_RGR'us

SSC Guru

Points: 294069

September 20, 2011 at 3:22 pm

#1384209

Ninja FINALLY overtakes Lowell!

:-D:w00t::cool:

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 15

Remi, I'd say you need a hobby, but apparently you already had one... Poor Lowell.

What will Lowell ever do with himself now?! Shame on you, Remi. You've stolen his dreams... his heart... his kindness... Now he's Celko.

- Craig Farrell

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