Are the posted questions getting worse?

Question

Are the posted questions getting worse?

Viewing 15 posts - 44,131 through 44,145 (of 66,000 total)

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

SQLRNNR SSC Guru Points: 281324 More actions · Answer 1

Koen Verbeeck (6/6/2014)
I think I have finally met the "exception on the rule" for SELECT *.
Select on an Oracle view with all the of the columns in the SELECT clause: 36 minutes (for 250,000 rows. Unfortunately I have no control over the view definition). SELECT * on same view: 2 minutes 50 seconds.
I am not kidding.
I talked with the Oracle DBA and he confirmed there are 2 different execution plans. The fast one is with nested loops, the second one with hashing.
He thinks that the SELECT * is faster because Oracle doesn't have to touch every table mentioned in the view to see if one of the selected columns is in there. When all the columns are explicitly mentioned, he has to check every table. Somehow this results in a vastly different execution plan.

I have seen the same behavior in very wide denormalized tables in SQL Server. I wrote a blog post about it.

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

Andrew Kernodle SSCertifiable Points: 5314 More actions · Answer 2

Impromptu announcement-of-not-too-much-note time, I suppose!

Decided to switch my posting name from one of my usual online aliases to my own name. Read Brad McGehee's book on becoming an exceptional DBA, and online branding was a pretty healthy focus.

I figured it couldn't hurt, and I registered for the site under my pseudonym since I figured I wouldn't get too involved with it. Well, that changed a decent bit :-).

So, err, I guess this is part where I should make the remark that I'm Andrew, and I'm a SQLHolic :-P.

Well, back to the regularly scheduled activity of The Thread 😀

- 😀

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 3

Andrew Kernodle (6/6/2014)
So, err, I guess this is part where I should make the remark that I'm Andrew, and I'm a SQLHolic :-P.

HI ANDREW!!! 😛

--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)
Intro to Tally Tables and Functions

Luis Cazares SSC Guru Points: 183686 More actions · Answer 4

Hi Andrew!

Could you remind me your previous username? My ADHD won't let me remember. 😀

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

Andrew Kernodle SSCertifiable Points: 5314 More actions · Answer 5

Oh great, now I look at my previous post and I notice I didn't even mention that part :-P. I'm the poster previously known as hisakimatama! Clearly my faulty memory is a result of me ingesting too much SQLhol in the last hour 🙂

- 😀

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 6

Okay, I really need to step away from this person:

Welsh Corgi (6/8/2014)
Lynn Pettis (6/7/2014)
Welsh Corgi (6/7/2014)
That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?
Thanks a bunch!
Divide twice by 1024.0.
Syntax please? :unsure:

< RANT >

Really, you need someone to actually spell this out for you?

Joined: 2/18/2005 10:38:00 AM (4,213 visits since) and still can't do simple queries??

You have been working with SQL Server for over 9 years, this should be second nature by now.

< /RANT >

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 7

Lynn Pettis (6/8/2014)
Okay, I really need to step away from this person:
Welsh Corgi (6/8/2014)
Lynn Pettis (6/7/2014)
Welsh Corgi (6/7/2014)
That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?
Thanks a bunch!
Divide twice by 1024.0.
Syntax please? :unsure:
< RANT >
Really, you need someone to actually spell this out for you?
Joined: 2/18/2005 10:38:00 AM (4,213 visits since) and still can't do simple queries??
You have been working with SQL Server for over 9 years, this should be second nature by now.
< /RANT >

Wut? This seems inbelievable.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

Koen Verbeeck (6/8/2014)
Wut? This seems inbelievable.

Not the first time I've seen that kind of thing from that person.

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

Ed Wagner SSC Guru Points: 287015 More actions · Answer 9

I saw that exact post over the weekend and had to look at it twice to make sure I wasn't missing something. I too was in disbelief.

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

Greg Edwards-268690 SSC-Insane Points: 20667 More actions · Answer 10

Koen Verbeeck (6/8/2014)
Lynn Pettis (6/8/2014)
Okay, I really need to step away from this person:
Welsh Corgi (6/8/2014)
Lynn Pettis (6/7/2014)
Welsh Corgi (6/7/2014)
That is sweet. I have the sizes stored in KB's. What statement could I used to convert from KB to GB?
Thanks a bunch!
Divide twice by 1024.0.
Syntax please? :unsure:
< RANT >
Really, you need someone to actually spell this out for you?
Joined: 2/18/2005 10:38:00 AM (4,213 visits since) and still can't do simple queries??
You have been working with SQL Server for over 9 years, this should be second nature by now.
< /RANT >
Wut? This seems inbelievable.

Which one - Lynn staying away, or the asking for clarification? 😛

Both are a bit surprising, although not exactly shocking.

Sometimes a quick glance and quick reply leads to some interesting online exchanges.

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

Corgi's trolling, just ignore. Not a new developer, he/she will figure it out.

Curious, is the TITD actually a TITD now?

---------------------------------------------------------
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: 442447 More actions · Answer 12

jcrawf02 (6/9/2014)
Corgi's trolling, just ignore. Not a new developer, he/she will figure it out.
Curious, is the TITD actually a TITD now?

Not really. Could be if I slept in transient quarters. Glad I don't.

WayneS SSC Guru Points: 95405 More actions · Answer 13

Lynn Pettis (6/9/2014)
jcrawf02 (6/9/2014)
Corgi's trolling, just ignore. Not a new developer, he/she will figure it out.
Curious, is the TITD actually a TITD now?
Not really. Could be if I slept in transient quarters. Glad I don't.

I envision the TITD to be something like this:

http://somedayillbethere.com/wp-content/uploads/2013/01/desert-camp.jpg

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

jasona.work SSC Guru Points: 50021 More actions · Answer 14

Awful quiet in here over the last couple days...

Should we turn out the lights on this thread?

:hehe:

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 15

jasona.work (6/13/2014)
Awful quiet in here over the last couple days...
Should we turn out the lights on this thread?
:hehe:

Why not? I could use some sleep 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP