March 7, 2011 at 12:16 pm
Duncan Pryde (3/7/2011)
Totally irrelevant to the question of course, but I needed to tell someone:I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)
It's been a tough journey, but feels good to have finally got up to date. :hehe:
Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD
March 7, 2011 at 12:28 pm
Great Question - thanks Ron
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
March 7, 2011 at 1:00 pm
Jamie - It was my understanding that this question was about how data is stored in the data pages. What did you see that made you think about query optimization?
Made sense to me.
Jamie
March 8, 2011 at 1:09 am
bitbucket-25253 (3/7/2011)
Duncan Pryde (3/7/2011)
Totally irrelevant to the question of course, but I needed to tell someone:I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)
It's been a tough journey, but feels good to have finally got up to date. :hehe:
Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD
Funny you should say that, but I've got one coming out on Wednesday. I've had about 3 others published so far, to mixed-ish reviews!
March 8, 2011 at 6:19 am
Duncan Pryde (3/8/2011)
bitbucket-25253 (3/7/2011)
Duncan Pryde (3/7/2011)
Totally irrelevant to the question of course, but I needed to tell someone:I've now finally answered every QOD in existance! (until tomorrow's comes out, anyway)
It's been a tough journey, but feels good to have finally got up to date. :hehe:
Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD
Funny you should say that, but I've got one coming out on Wednesday. I've had about 3 others published so far, to mixed-ish reviews!
Congratulations - keep up submitting for it is a quick method of teaching others, and even if you can not or care not to submitt a full length article you do contribute to the community.
March 8, 2011 at 7:02 am
Jamie Longstreet-481950 (3/7/2011)
Jamie - It was my understanding that this question was about how data is stored in the data pages. What did you see that made you think about query optimization?
It certainly makes more sense to think about optimization in terms of paging rather than the size of the table within the join and the way SQL moves the query around inside of the pages - which is probably why I didn't consider paging because it seems to be more of a function of the native client than something one has a handle on.
I did not think it was possible to make a more off topic and negative statement that made less sense.
The question was about DDL and data storage.
You are making negative statements about DML and querry optimization that make no sense.
March 17, 2011 at 3:04 am
Excellent Question.
Now i am looking Query optimization and all the objects shown in execuation plan.Do you have any idea where i can find some good thoughts to go in this direction.
March 17, 2011 at 3:44 am
I did not think it was possible to make a more off topic and negative statement that made less sense.
The question was about DDL and data storage.
You are making negative statements about DML and querry optimization that make no sense.
Glad I could help you with that.
Jamie
March 22, 2011 at 12:43 pm
Bad question.
You were trying to be tricky in your question. It could have been straight-forward and simple that to SAVE SPACE... which column should I prefer to make NULL over another.
--
:hehe:
August 8, 2011 at 6:05 am
Excellent question, I guessed the right answer, but I definitely learned something.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 10 posts - 16 through 24 (of 24 total)
You must be logged in to reply to this topic. Login to reply