Gail

I do not (yet) use that trace. Do you recommend it? is it's only job to make sure SQL gets all the memory buffered at one time, in the beginning?

So,...

Akhil,

can you please explain the part "correlate this data with the profiler", please..

thx

Dan

I want to know if there is a sure way to know if SQL Server has more memory than it needs especially in the 64 bit OS environment.

In 32 bit...

Paul

Will the buffer pool be allocated and unused? in the scenario of the Ent Edition and the other factors?

how could we see how much is allocated and used/unused?...

thanks for the link.

can you put in your words of what it has meant to you in practical everyday work from the perspective of moving from 2005 to 2008...

After you use Shrink+Alter to reduce the size, if you issue another alter command to increase the size, does that become the 'new' initial size?

I am with you in principle. I am asking what is technically going on inside, that may block a shrink, even when there is enough unused space.

GSquared

Had you by any chance posted the scripts you were referring to, in,

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

in this site?

I am scanning through the articles section once in a while. I will...

Is there performance impact when queries have to do multiple joins between different schemas?

Hi

Float always gives the result of the calculator. That is why I assumed that Float will always be accurate. Can you give an example when Decimal gives better...

Jeff

Let me try to summarize you:

*Bigger the precision (is it and/or scale), better the accuracy,especially in multiplication by a big number (Example: 2.45454545 (precision 9;scale 2) is more accurate than...

Paul White

The Blog you mentioned says that you can avoid FP by using decimal. That is exactly Gus says is not possible to avoid

Dan

Gus

According to wiki, 5244.11 has 6 significant digits, not? The 3 rules for SD are:

1. All non-zero digits are significant.

2. In a number without a decimal point, only zeros...

64 bit seems to have many advantages over 32.

What exactly is the formula to calculate the max GB Ram - physical memory in 32 and 64 bits with AWE? (2...

Gus,

I like your approach on #1. Excellent!

On #2 & 3, you mention that all decimals are converted to FP for internal calculation; my question in #4 is why then the...