| Author |
Topic |
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
 Posted - 2004-02-12 : 09:20:43
|
| I need some help from those that patrol the forums in great detail. I'm looking for a thread with a really difficult question about SQL Server that we never answered adequately. Something along the lines of "Why does SQL Server do this" or "How does the engine or query parser handle this"? Has anyone seen a thread like that?===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-02-12 : 09:28:09
|
I am reminded of the "Singelton Select vs Cursor" debate that never received an adequate treatment.  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30286 |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-02-12 : 10:02:06
|
| What about the question...."Where part 2 of the famous Trees and Hierarchies article Rob?"It seems to qualify..... |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2004-02-12 : 15:27:10
|
Most of the threads in the Analysis Services forum? |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-02-12 : 15:51:44
|
| I have the opportunity to submit threads to the SQL Server development team. As you can imagine I'm going to be fairly strict in what I forward them. If you find a thread that may be appropriate to get a response from them, please email it to me or post a link to it here.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-12 : 16:31:11
|
| I think we've had some where the execution plan was different even though the indexes and queries were the same on two different boxes. I can't point you at a specific one, but I bet a search on execution plan might turn up something.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-12 : 17:08:23
|
| What about the ones where a sproc takes longer to run than sql in qa?Where is that thread...Brett8-) |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-13 : 01:15:54
|
| Yeah, there ya go Brett! Find that one Graz!<Yoda>Use my mad searching skills I must.</Yoda>Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2004-02-13 : 04:21:01
|
quote:
Originally posted by X002548
What about the ones where a sproc takes longer to run than sql in qa?
Isn't that just where the auto-parameterization of SPs means that it generates an execution plan that suitable for any parameter value, but worse for the particular value you're giving it? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-02-13 : 09:19:45
|
| Well...what I don't know could fill the Laurentian Abyss...And what I try to understand I backfill with OS/390 DB2 architecure...But huh?Brett8-) |
|
|
|
|
Find a Challenging Thread