Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Jack Corbett SSC Guru Points: 184393 More actions · Answer 1

GSquared (12/16/2010)
I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till you get used to them.
I've always thought From should come before Select anyway. Makes more sense to me. So starting with "Select * From", building the From clause, and then going back and building the Select clause, and getting Intellisense prompts that way, seems okay to me.

So you'd like Linq. A Linq query looks like this:

var orders = from o in Context.Orders

select o

where o.OrderDate gt "2010-01-01"

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

GSquared SSC Guru Points: 260824 More actions · Answer 2

Jack Corbett (12/16/2010)
GSquared (12/16/2010)
I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till you get used to them.
I've always thought From should come before Select anyway. Makes more sense to me. So starting with "Select * From", building the From clause, and then going back and building the Select clause, and getting Intellisense prompts that way, seems okay to me.
So you'd like Linq. A Linq query looks like this:
var orders = from o in Context.Orders
select o
where o.OrderDate gt "2010-01-01"

I'm somewhat familiar with Linq. I like From being first, but the rest of the syntax isn't comfortable to me.

- 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 3

Grant Fritchey (12/16/2010)
I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed.

Likewise. The thing I really like about SQLPrompt is all the config options. I have mine set to not autocomplete on <space> or <.>, but to require <enter>. That way, if what it suggests is wrong, I can just keep on typing and it won't second-guess me (like the built in one often does)

Now I just need to figure out why the v5 preview version stopped working on my laptop.

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

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 4

GilaMonster (12/16/2010)
Grant Fritchey (12/16/2010)
I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed.
Likewise. The thing I really like about SQLPrompt is all the config options. I have mine set to not autocomplete on <space> or <.>, but to require <enter>. That way, if what it suggests is wrong, I can just keep on typing and it won't second-guess me (like the built in one often does)
Now I just need to figure out why the v5 preview version stopped working on my laptop.

Nah, they just released v5. Uninstall the preview.

"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

WayneS SSC Guru Points: 95409 More actions · Answer 5

bitbucket-25253 (12/16/2010)
WayneS (12/15/2010)
My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?
Wayne I believe it was a good question, and I for one of many people learned from it. I did not answer correctly, but garnishing points is not the award, learning is the true purpose of the QOD and in that regard many, many people benefited from it.
Thanks for a good QOD.

Thanks for the kind words Ron. I think the folks over there screaming the most were the ones that didn't like missing their QotD points... and then they do multiple posts just to get "their" points back.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Ron McCullough SSC Guru Points: 63877 More actions · Answer 6

WayneS (12/16/2010)
bitbucket-25253 (12/16/2010)
WayneS (12/15/2010)
My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?
Wayne I believe it was a good question, and I for one of many people learned from it. I did not answer correctly, but garnishing points is not the award, learning is the true purpose of the QOD and in that regard many, many people benefited from it.
Thanks for a good QOD.
Thanks for the kind words Ron. I think the folks over there screaming the most were the ones that didn't like missing their QotD points... and then they do multiple posts just to get "their" points back.

Wayne do not be discouraged, generate another QOD and then another... I have been beaten from pilar to post on a few of mine. If memory serves me correctly Steve award points to everyone on two of those.

Now keep submitting those QODs, and catch up with me. (Submitted my 36th QOD a few days back, so far returned once for amplification of the explanation, and not yet scheduled)

Added at 6:23 PM EST

The QODs had an average of 2,225 attempts - not including those who might have viewed but did not attempt to answer. Believe this, on average, is a larger number of viewers (People who might learn something) than a typical forum posting assisting one OP. Not saying that, that assistance is not valuable, which of course it is very valuable. But the QOD is as good a training delivery system. as a typical forum post

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 7

GilaMonster (12/16/2010)
Grant Fritchey (12/16/2010)
I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed.
Likewise. The thing I really like about SQLPrompt is all the config options. I have mine set to not autocomplete on <space> or <.>, but to require <enter>. That way, if what it suggests is wrong, I can just keep on typing and it won't second-guess me (like the built in one often does)
Now I just need to figure out why the v5 preview version stopped working on my laptop.

I need to change that. I set up <.> as an option, and wish I hadn't much of the time. That's how lazy I am, can't go un-check something...

v5 preview quit for me too, wouldn't let me revert, had to uninstall, reinstall v4<whatever> to get it back.

---------------------------------------------------------
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."

WayneS SSC Guru Points: 95409 More actions · Answer 8

I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95409 More actions · Answer 9

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and Denali, I'll need to upgrade (again) at $100.

So, what say you?

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

TomThomson SSC Guru Points: 104773 More actions · Answer 10

Brandie Tarvin (12/15/2010)
Not believing I'm actually going to get an answer to the question I posted on the thread Wayne just linked, I'm going to ask the question here.
Has anyone heard of the MONEY data type having a math problem?
I use that type quite a bit and I've never heard of or experienced a problem with that data type. So any information on the "MONEY math problem" Celko speaks of would be greatly appreciated.

Well, you did get an answer.

And on coalesce, you were just making yourself look silly. Don't let the fact that Celko often (usually?) writes in online fora as an obnoxious *** blind you to the fact that he gets most things right.

Tom

mister.magoo SSC-Forever Points: 47068 More actions · Answer 11

WayneS (12/16/2010)
What are your preferences for VM machines - VMWare or VirtualPC?
I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and Denali, I'll need to upgrade (again) at $100.
So, what say you?

Check out Oracle's (previously Sun's) VirtualBox - it's free and can run VMWare and Virtual PC images as well as it's own. I find it to be excellent.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

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

WayneS (12/16/2010)
I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....

Hehehe, and as usual, I'm not helping any... :Whistling:

- 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

WayneS SSC Guru Points: 95409 More actions · Answer 13

Craig Farrell (12/16/2010)
WayneS (12/16/2010)
I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....
Hehehe, and as usual, I'm not helping any... :Whistling:

I wouldn't say that... if nothing else, you've spawned off a good sidebar topic (which I don't think it had started when I posted that originally).

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

WayneS SSC Guru Points: 95409 More actions · Answer 14

Brandie Tarvin (12/16/2010)
Steve Jones - SSC Editor (12/16/2010)
I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds a new table, you might end up with some weird joins. Hopefully that gets caught, but I find that Intellisense messes me up as often as it helps.
Intellisense annoys me. I type too fast for it and end up with either the wrong object or having to type extra characters to get out of it. So I've given up on it and turned it off.

Here's just two of the reasons why I've turned it off:

SELECT RN = row_number() OVER (partition_fragment_id

SELECT nchar

FROM dbo.Tally

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 15

Steve Jones - SSC Editor (12/16/2010)
Jeff Moden (12/15/2010)
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?
It depends... where's your other hand? 🙂
A knife, a real knife

Heh... the one on the right with the skirt... that's you, huh? 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)