SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by bitbucket / Table Design / Latest Posts

RE: Table Design

hakan.winther — Mon, 08 Aug 2011 06:05:41 GMT

Excellent question, I guessed the right answer, but I definitely learned something.

RE: Table Design

Slick84 — Tue, 22 Mar 2011 12:43:09 GMT

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.

RE: Table Design

Jamie Longstreet-481950 — Thu, 17 Mar 2011 03:44:26 GMT

[quote]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.[/quote]Glad I could help you with that.

RE: Table Design

amit_adarsh — Thu, 17 Mar 2011 03:04:16 GMT

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.

RE: Table Design

SanDroid — Tue, 08 Mar 2011 07:02:54 GMT

[quote][b]Jamie Longstreet-481950 (3/7/2011)[/b][hr][quote]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? [/quote]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. [/quote]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.

RE: Table Design

bitbucket-25253 — Tue, 08 Mar 2011 06:19:19 GMT

[quote][b]Duncan Pryde (3/8/2011)[/b][hr][quote][b]bitbucket-25253 (3/7/2011)[/b][hr][quote][b]Duncan Pryde (3/7/2011)[/b][hr]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:[/quote]Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD[/quote]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![/quote]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.

RE: Table Design

Duncan Pryde — Tue, 08 Mar 2011 01:09:44 GMT

[quote][b]bitbucket-25253 (3/7/2011)[/b][hr][quote][b]Duncan Pryde (3/7/2011)[/b][hr]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:[/quote]Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD[/quote]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!

RE: Table Design

Jamie Longstreet-481950 — Mon, 07 Mar 2011 13:00:16 GMT

[quote]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? [/quote]Made sense to me.

RE: Table Design

SQLRNNR — Mon, 07 Mar 2011 12:28:34 GMT

Great Question - thanks Ron

RE: Table Design

bitbucket-25253 — Mon, 07 Mar 2011 12:16:57 GMT

[quote][b]Duncan Pryde (3/7/2011)[/b][hr]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:[/quote]Congratulations .. now time to turn the other cheek as the saying goes and submit a question for the QOD

RE: Table Design

Duncan Pryde — Mon, 07 Mar 2011 07:52:46 GMT

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:

RE: Table Design

Surii — Mon, 07 Mar 2011 07:42:14 GMT

Great question!! Learned something new today.Thanks!!

RE: Table Design

Duncan Pryde — Mon, 07 Mar 2011 07:32:59 GMT

Interesting question - thanks.The link in the explanation seems to be for page containing all Kimberly's SQL 2005 articles- for the exact post relating to this question I think the link is: [url=http://sqlskills.com/BLOGS/KIMBERLY/post/Column-order-doesnt-matter-generally-but-IT-DEPENDS!.aspx]http://sqlskills.com/BLOGS/KIMBERLY/post/Column-order-doesnt-matter-generally-but-IT-DEPENDS!.aspx[/url]

RE: Table Design

SanDroid — Mon, 07 Mar 2011 06:51:29 GMT

Great Monday Morning QOTD. Thank you.

RE: Table Design

SanDroid — Mon, 07 Mar 2011 06:49:06 GMT

[quote][b]Jamie Longstreet-481950 (3/7/2011)[/b][hr]This is a good question because it shows just how naive the SQL system can be when it comes to query optimization.[/quote]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?

RE: Table Design

Chris Houghton — Mon, 07 Mar 2011 06:39:06 GMT

Guessed the correct answer for the right reasons. Had to read it a few times to understand what was being asked. I learned something new here. Nice question!

RE: Table Design

bitbucket-25253 — Mon, 07 Mar 2011 06:19:56 GMT

[quote]Jamie Longstreet-481950 Posted Today @ 4:28 AMOther than speaking of your own expertise, what is there to convince a developer to follow these obscure rules... [/quote] Least anyone feels that it is my own expertise, let me forcefully point out that I found this gem of information by reading a blog posting by Kimberly L. Tripp (link included in the justification for the correct answer). I hope that this question introduces many to use all the resources available to them, SqlServerCentral, Books On Line, among the obvious and the not so obvious, blog postings of many highly qualified individuals to delve deeper into the inner workings of SQL Server.

RE: Table Design

Nakul Vachhrajani — Mon, 07 Mar 2011 05:26:28 GMT

Thank-you for this great question! Because I started off with main-frame COBOL, I went with common sense (even before the SQL mind took over) and came to the conclusion that the last column, if kept NULL will provide with the maximum savings.Once again, thank-you, and have a great day!

RE: Table Design

sujitkmishra — Mon, 07 Mar 2011 05:05:57 GMT

Excellent question. Thanks

RE: Table Design

paul s-306273 — Mon, 07 Mar 2011 03:20:27 GMT

Excellent question today - thanks Ron.

RE: Table Design

Jamie Longstreet-481950 — Mon, 07 Mar 2011 02:28:06 GMT

good question

RE: Table Design

Carlo Romagnano — Mon, 07 Mar 2011 01:17:51 GMT

Thank you for qotd. I really learnt something new and useful.I should read it 10 times carefully, but at last, when I understand that the goal of qotd was to save space on disk I answered quickly 'c40'.

RE: Table Design

mohammed moinudheen — Sun, 06 Mar 2011 23:29:01 GMT

This is a great question. Even though I knew SQL Server will re-arrange fixed width columns first and the variable columns last, I was unable to get this right.

RE: Table Design

Koen Verbeeck — Sun, 06 Mar 2011 11:45:44 GMT

Nice question, thanks.I had to read it a few times...

Table Design

bitbucket-25253 — Sat, 05 Mar 2011 18:44:20 GMT

Comments posted to this topic are about the item [B]Table Design[/B]