Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 17,176 through 17,190 (of 66,712 total)

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

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

Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!

Good luck, I'm sure you'll do great at the new job.

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

Jack Corbett (8/5/2010)
Lynn Pettis (8/5/2010)
Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.
Good luck!! And don't worry, you should make it no problem!
I second that!

I third that!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

Jack Corbett (8/5/2010)
Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!
Good luck, I'm sure you'll do great at the new job.

I second that!

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

Never mind... 😉

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

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

Steve Jones - Editor (8/5/2010)
Wish me luck. My PASS Board interview is tomorrow. We'll see if I'm still in the running after that.

Break a leg, Steve. You'll do well.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

Jeff Moden (8/5/2010)
Never mind... 😉

Sure back down about not building anything other than a gynormous building.

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

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

Chad Crawford (8/5/2010)
Made me think of the MIDDLE JOIN question that showed up in the QOD once

Yes I remember that one (without looking it up). Very sneaky and rather fun.

I didn't get my QotD points that day.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 8

jcrawf02 (8/5/2010)
Paul White NZ (8/5/2010)
I feel a blog entry coming on...
About time, we've only seen what, ten from you in the last two weeks?? :w00t: Don't you sleep?

Something on chasm / fan traps would be really 😎

A related issue at work this week, two tables joined by two columns, except the values are "legacy" in one table and "new" in the other. Translation via two lookup tables each translating one column, something like this:

SELECT ...

FROM LegacyTable L

INNER JOIN Lookup1 L1 ON L1.LegacyColumn = L.Column1

INNER JOIN Lookup2 L2 ON L2.LegacyColumn = L.Column2

INNER JOIN NewTable N ON N.Column1 = L1.NewColumn

AND N.Column2 = L2.NewColumn

Running this generates a monster work table as you might expect because SQL Server will only join two tables in one process. Putting the two lookups into a CTE to provide both pairs of columns in one "object" didn't help, in fact the plan didn't really change. Putting the two lookups into a real object - a temp table - brought the run time down from 20 minutes (at least...I stopped it) to about 8 seconds. Jack's trick is definitely worth a try with this real-world example.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 9

Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!

Good luck today Lynn, a smooth flowing last day on a job can work wonders for your confidence on your first day at the next.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 10

Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!

Best of luck with the new challenge !

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

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

The Dixie Flatline (8/5/2010)
but I have heard people claim that indexing every column was the way to go because "it keeps the indexes small" and "SQL can put together all the data from the indexes quicker".

I have a part-written blog post on that.

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 12

Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.

There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 13

GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.
There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.

Access is often a trojan horse that allows non-tech people to create small data-driven applications outside the IT department.

It almost always means it's horribly designed, horribly coded and sooner or later it will run out of control.

When that happens, they bring it to the IT and want it fixed right away.

-- Gianluca Sartori

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 14

Gianluca Sartori (8/6/2010)
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.
There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
Access is often a trojan horse that allows non-tech people to create small data-driven applications outside the IT department.
It almost always means it's horribly designed, horribly coded and sooner or later it will run out of control.
When that happens, they bring it to the IT and want it fixed right away.

and every one has got his/her onw littlebit modified version that started from the original very small little functinality mdb. 😉 Preferably on a network drive, executed remote, with front-end-side "worker" tables, ....

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

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

Gianluca Sartori (8/6/2010)
GilaMonster (8/6/2010)
Jack Corbett (8/5/2010)
AHHHHHH! You said a swear word!!! Access.
There's nothing wrong with Access when used appropriately. The problem is it's seldom used appropriately.
Access is often a trojan horse that allows non-tech people to create small data-driven applications outside the IT department.
It almost always means it's horribly designed, horribly coded and sooner or later it will run out of control.

See 'used appropriately'. If they didn't have Access, they'd be creating their databases in Excel.

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