Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 52,546 through 52,560 (of 66,712 total)

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Phil Parkin (2/4/2016)
Grant Fritchey (2/4/2016)
Grumpy DBA (2/4/2016)
In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point out all of the Select *'s and ask the developers to replace with column names... the pushback was unbelievable - "it takes too long to type the column names"... and their manager backed them, argh.
I believe these developers went to the Dark Side many years ago and fail to see the goodness of the light side.
Clearly they needed a SQL Prompt license.
Or a quick refresher on how to click and drag from Object Explorer.

That's too much work. It involves moving my hand from the keyboard to the mouse.

Can I get my SQL Prompt license now? Pretty please.

Ok, I'll just get the columns from a system view.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 2

Luis Cazares (2/4/2016)
Phil Parkin (2/4/2016)
Grant Fritchey (2/4/2016)
Grumpy DBA (2/4/2016)
In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code review I would point out all of the Select *'s and ask the developers to replace with column names... the pushback was unbelievable - "it takes too long to type the column names"... and their manager backed them, argh.
I believe these developers went to the Dark Side many years ago and fail to see the goodness of the light side.
Clearly they needed a SQL Prompt license.
Or a quick refresher on how to click and drag from Object Explorer.
That's too much work. It involves moving my hand from the keyboard to the mouse.
Can I get my SQL Prompt license now? Pretty please.
Ok, I'll just get the columns from a system view.

I do that all the time. Information_Schema.Columns is a wonderful tool for a quick-n-dirty cut-n-paste.

Well, as long as I remember to remove the identity columns from my INSERT statements, that is. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

Grant Fritchey (2/4/2016)
Eirikur Eiriksson (2/4/2016)
For fun (screenshot from a RedGate presentation)
😎
Why do you think I'm working on that database?
Ha!
I'm pretty sure that's one of Steve's presentations.

I'm sure that's my presentation...

where I fix Grant's code.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Steve Jones - SSC Editor (2/4/2016)
Grant Fritchey (2/4/2016)
Eirikur Eiriksson (2/4/2016)
For fun (screenshot from a RedGate presentation)
😎
Why do you think I'm working on that database?
Ha!
I'm pretty sure that's one of Steve's presentations.
I'm sure that's my presentation...
where I fix Grant's code.

Hey, most things aren't completely useless. Some can serve as a good example of what not to do...except when necessary. 😛

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 5

Steve Jones - SSC Editor (2/4/2016)
I'm sure that's my presentation...
where I fix Grant's code.

Ha! Love you too!

I have to go back and tune his "fixes" later so...

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 6

Steve Jones - SSC Editor (2/4/2016)
Grant Fritchey (2/4/2016)
Eirikur Eiriksson (2/4/2016)
For fun (screenshot from a RedGate presentation)
😎
Why do you think I'm working on that database?
Ha!
I'm pretty sure that's one of Steve's presentations.
I'm sure that's my presentation...
where I fix Grant's code.

This was Alex demonstrating DLM & CI, did an impressive job, must add that I removed the bad practice comment from the screenshot ( for fun)

I am very impressed by the coverage of the products but struggling with fitting them into the hybrid legacy/ cloud scenario I'm dealing with. So far it's the best contender I've seen.

😎

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 7

Grant Fritchey (2/4/2016)
Steve Jones - SSC Editor (2/4/2016)
I'm sure that's my presentation...
where I fix Grant's code.
Ha! Love you too!
I have to go back and tune his "fixes" later so...

You mean fix his tune 😀

😎

jasona.work SSC Guru Points: 50117 More actions · Answer 8

Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...

The curiosity is KILLING ME!!!

MUST...

READ...

RESPONSE...

:hehe:

(Plus I checked, I don't have him on my ignore list, only one person has made that)

((Or maybe the guy's on my buddy list, can't recall))

Luis Cazares SSC Guru Points: 183706 More actions · Answer 9

jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
MUST...
READ...
RESPONSE...
:hehe:
(Plus I checked, I don't have him on my ignore list, only one person has made that)
((Or maybe the guy's on my buddy list, can't recall))

Posts by CELKO are removed, and are only visible if you're fast enough to get to the thread before they're deleted.

Although, he leaves some trails of his activity.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

jasona.work SSC Guru Points: 50117 More actions · Answer 10

Luis Cazares (2/4/2016)
jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
MUST...
READ...
RESPONSE...
:hehe:
(Plus I checked, I don't have him on my ignore list, only one person has made that)
((Or maybe the guy's on my buddy list, can't recall))
Posts by CELKO are removed, and are only visible if you're fast enough to get to the thread before they're deleted.
Although, he leaves some trails of his activity.

That's right...

Still, now I'm curious what he wrote...

Phil Parkin SSC Guru Points: 246960 More actions · Answer 11

jasona.work (2/4/2016)
Luis Cazares (2/4/2016)
jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
MUST...
READ...
RESPONSE...
:hehe:
(Plus I checked, I don't have him on my ignore list, only one person has made that)
((Or maybe the guy's on my buddy list, can't recall))
Posts by CELKO are removed, and are only visible if you're fast enough to get to the thread before they're deleted.
Although, he leaves some trails of his activity.
That's right...
Still, now I'm curious what he wrote...

Whereas I am curious about his 'trails'.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

Phil Parkin (2/4/2016)
jasona.work (2/4/2016)
Luis Cazares (2/4/2016)
jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
MUST...
READ...
RESPONSE...
:hehe:
(Plus I checked, I don't have him on my ignore list, only one person has made that)
((Or maybe the guy's on my buddy list, can't recall))
Posts by CELKO are removed, and are only visible if you're fast enough to get to the thread before they're deleted.
Although, he leaves some trails of his activity.
That's right...
Still, now I'm curious what he wrote...
Whereas I am curious about his 'trails'.

Well, I guess that's one way of describing what he leaves behind. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

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

jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!

He was probably calling you incompetent and pointing out that real database people only use standard features which don't get deprecated.

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

Michael L John One Orange Chip Points: 27055 More actions · Answer 14

GilaMonster (2/4/2016)
jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
He was probably calling you incompetent and pointing out that real database people only use standard features which don't get deprecated.

Like this? http://www.sqlservercentral.com/Forums/Topic1758203-3412-2.aspx

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Grumpy DBA SSChampion Points: 12515 More actions · Answer 15

Michael L John (2/4/2016)
GilaMonster (2/4/2016)
jasona.work (2/4/2016)
Man, there's a reply to one of my topics (which really already has been answered, although Gail raised an important point) by CELKO, and I can't read it...
The curiosity is KILLING ME!!!
He was probably calling you incompetent and pointing out that real database people only use standard features which don't get deprecated.
Like this? http://www.sqlservercentral.com/Forums/Topic1758203-3412-2.aspx

But everything CELKO no longer exists... I went through some other threads and can only find him if someone else quoted him. It's as if he never existed here, kind of a "It's a wonderful life" situation.