Are the posted questions getting worse?

Question

Post reply

Are the posted questions getting worse?

Viewing 15 posts - 15,541 through 15,555 (of 66,712 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

May 27, 2010 at 1:31 pm

#1173562

Here is some really good advice.

tosscrosby SSCoach Points: 18045 More actions · Answer 2

Lynn Pettis (5/27/2010)
Please, anyone, if I am wrong here let me know.

I don't see anything wrong with what you've stated. Spot on if you ask me. And doing sp2 then sp3 adds, IMO, an uncessary step to the process. And as you stated unless M$ stated to the contrary about the service packs, I'd go with sp3, in dev\staging first of course, test and promote if no issues are uncovered. GP seems ready to go over the edge again, always looking to provoke and defend his/her response as the gospel truth. It's funny, this poster didn't start out this way when they were a newbie.

-- You can't be late until you show up.

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

You're perfectly correct. The only service pack that I'm aware of that's not cumulative is Vista SP 2. Requires SP1 first.

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

tosscrosby SSCoach Points: 18045 More actions · Answer 4

Lynn Pettis (5/27/2010)
Here is some really good advice.

That's not a database analyst I want on my team or to even have server access for that matter!! :w00t:

-- You can't be late until you show up.

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

Lynn Pettis (5/27/2010)
Please, anyone, if I am wrong here let me know.

In regards to service packs, you are 100% correct.

"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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Paul White NZ (5/27/2010)
Dave Ballantyne (5/27/2010)
I find intellisense and its most annoying when putting together test code , ie where im quite happy for a column called 'A','B' or 'ID'. Can never remember to hit 'ESC' rather than space or column. Though ,even then ,i find it of limited use in production quality code.
I find getting into the habit of typing SELECT * FROM dbo.Table T helps. Going back and typing "T." over the star brings up the column names.
Always using an alias is a good habit to get into IMO.

That is a good tip. I have started doing that - but the tables and system objects are the most problematic for intellisense and it's level of intelligence.

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

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 7

Lynn Pettis (5/27/2010)
Steve Jones - Editor (5/27/2010)
I'd say avoid all large, generic ERP programs. I think they all suck. I worked for JD Edwards and Peoplesoft, both of which were POS products in my mind.
From what I have found from our PeopleSoft support team, it got worse after they were bought by Oracle.

I hear rumblings of an Enterprise 1 project about to start.

Sounds like I need to take a long trip.

Greg E

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

Lynn Pettis (5/27/2010)
Here is some really good advice.

Ow.

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

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

GilaMonster (5/27/2010)
Lynn Pettis (5/27/2010)
Here is some really good advice.
Ow.

Geez, some people. Clearly you should reboot the server.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

jcrawf02 (5/27/2010)
GilaMonster (5/27/2010)
Lynn Pettis (5/27/2010)
Here is some really good advice.
Ow.
Geez, some people. Clearly you should reboot the server.

Well, that treats the symptom, not the problem. What really needs to be done is to determine what is causing the growth and fix the code. Agreed?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

Lynn Pettis (5/27/2010)
jcrawf02 (5/27/2010)
GilaMonster (5/27/2010)
Lynn Pettis (5/27/2010)
Here is some really good advice.
Ow.
Geez, some people. Clearly you should reboot the server.
Well, that treats the symptom, not the problem. What really needs to be done is to determine what is causing the growth and fix the code. Agreed?

Agreed.

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 12

I find it interesting when people want to stop the logging process because the t-log is just sooo big after a reorg/rebuild.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 13

Everyone wants to stop the log. Until they lose some data, then they want more of a log.

Jeff Moden SSC Guru Points: 1004365 More actions · Answer 14

jcrawf02 (5/27/2010)
Paul White NZ (5/27/2010)
Note to self: avoid PeopleSoft.
You have four too many letters on the end there.

Heh... ironicly, I'm glad to see I'm not alone in that. 😀

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

WayneS SSC Guru Points: 95460 More actions · Answer 15

jcrawf02 (5/27/2010)
Paul White NZ (5/27/2010)
Note to self: avoid PeopleSoft.
You have four too many letters on the end there.

LOL

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