Jeff

Can you please give an example of Determinant values in these columns.

For example, one of the columns values would be something like

(columnA-columnB)/ColumnC =

1043.2250

98765.2750

556.3250

11432.0950

etc (there is no predictability).

Thanks

Dan

Gail

Although they are not the same, the end result of Rebuild also accomplishes (or includes) what is done through a reorg (rearranging leaf level pages), right?

Dan

Thanks Jeff

Gus has some very good points on this issue, that will be very helpful continuation for this post, for future readers.

http://www.sqlservercentral.com/Forums/FindPost807402.aspx

Jeff has given some good examples of why...

trying to determine which indexes are not going to be used often by execution plan, and thus lessen the overhead of unnecessary indexes.

then, is there a way to see which indexes are selective and which are not, from elsewhere in SQL Server, in one shot, instead of traversing each index, one at...

can you explain what do you mean by 'cooked into the CPU'

Seth

Some developer do their big queries with sort in tempdb option, and the tempdb bloats up big time. that was the concern.

Dan

Gail

sorry, I was getting the 2 mixed up.

I meant to quote that sp_updatestats is perhaps better than Auto_update_stats

Dan

Silverfox,

You are right, you had already given me the right answer. I guess I was in disbelief. When I saw BOL quoted, I was humbled to accept an answer.

Appreciate your...

GSquared

Thanks for sharing several 'behind-the-scenes' tips on this topic.

Is there a MS doc that explains how their algorithms work for different operations/types?

Dan

Bru

It is 2GB; takes 20 minutes to run the maintenance tasks.

free_mascot, I will consider putting selected tables through a job for rebuild. Thanks for the tip.

Gail, thanks for mentioning sp_updatestate-...

Thx, it is a good discussion.

Is Microsoft planning to drop any of the decimal related data types in the future releases of SQL Servers?

I got my answer here..

http://www.sqlservercentral.com/Forums/Topic739604-360-1.aspx

Silverfox

I guess it perhaps also depends on what the interviewer considers as an easy or hard question, not?

yes, your questions were down to earth.

Dan