Default Fill factor

Hi
There are a lot of articles about the fillfactor.
I did change the fill factor and that did not work as intended.
How do I get back to the default fill factor
I am using sp_msforeachtable undocumented database procedure
and when the indexes are rebuilt the fill factor that shows up
in origfillfactor is the one I am trying to move away from

Your help will be appreciated

VinceHi

Without knowing the previous values then you probably have to restore the
backup.

John

"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0310200423.ca35b7a@.posting.google.co m...
> Hi
> There are a lot of articles about the fillfactor.
> I did change the fill factor and that did not work as intended.
> How do I get back to the default fill factor
> I am using sp_msforeachtable undocumented database procedure
> and when the indexes are rebuilt the fill factor that shows up
> in origfillfactor is the one I am trying to move away from
> Your help will be appreciated
> Vince|||Thanks John for your time....
There is a development database which is a copy of the database in
question.
The origfillfactor in sysindexes is 0 for all tables.I am assuming
this is the value assigned for the fill factor of the indexes.
Vince

Hi

Without knowing the previous values then you probably have to restore
the
backup.
John
> "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> news:2fa13ee7.0310200423.ca35b7a@.posting.google.co m...
> > Hi
> > There are a lot of articles about the fillfactor.
> > I did change the fill factor and that did not work as intended.
> > How do I get back to the default fill factor
> > I am using sp_msforeachtable undocumented database procedure
> > and when the indexes are rebuilt the fill factor that shows up
> > in origfillfactor is the one I am trying to move away from
> > Your help will be appreciated
> > Vince|||Hi

The OrigFillFactor field in sysindexes is the original fill factor used when
the index was created. It is not maintained if changed, therefore the value
before you made your changes may not have been the same.

http://msdn.microsoft.com/library/d..._sys-i_76wj.asp
A fill factor of 0 will mean that the index was originally created with full
data/leaf pages, which would tend to imply that you don't expect the data to
change often/at all. If this is not the case there could be some impact on
performance.

http://msdn.microsoft.com/library/d...config_5k8e.asp

Rather than changing the index on-mass you may want to try the index tuning
wizard to see what it suggests, or a combination of both!!!

John

"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0310200900.5e5b7a4a@.posting.google.c om...
> Thanks John for your time....
> There is a development database which is a copy of the database in
> question.
> The origfillfactor in sysindexes is 0 for all tables.I am assuming
> this is the value assigned for the fill factor of the indexes.
> Vince
> Hi
> Without knowing the previous values then you probably have to restore
> the
> backup.
> John
> > "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> > news:2fa13ee7.0310200423.ca35b7a@.posting.google.co m...
> > > Hi
> > > There are a lot of articles about the fillfactor.
> > > I did change the fill factor and that did not work as intended.
> > > How do I get back to the default fill factor
> > > I am using sp_msforeachtable undocumented database procedure
> > > and when the indexes are rebuilt the fill factor that shows up
> > > in origfillfactor is the one I am trying to move away from
> > > > Your help will be appreciated
> > > > Vince|||I ran sp_configure and discovered that the config_value was 0 but on
sysindexes the origfillfactor was 100.
Thought this values should be the same!!

Vince

"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<3f94ec4d$0$249$ed9e5944@.reading.news.pipex.net>...
> Hi
> The OrigFillFactor field in sysindexes is the original fill factor used when
> the index was created. It is not maintained if changed, therefore the value
> before you made your changes may not have been the same.
> http://msdn.microsoft.com/library/d..._sys-i_76wj.asp
> A fill factor of 0 will mean that the index was originally created with full
> data/leaf pages, which would tend to imply that you don't expect the data to
> change often/at all. If this is not the case there could be some impact on
> performance.
> http://msdn.microsoft.com/library/d...config_5k8e.asp
> Rather than changing the index on-mass you may want to try the index tuning
> wizard to see what it suggests, or a combination of both!!!
> John
>
> "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> news:2fa13ee7.0310200900.5e5b7a4a@.posting.google.c om...
> > Thanks John for your time....
> > There is a development database which is a copy of the database in
> > question.
> > The origfillfactor in sysindexes is 0 for all tables.I am assuming
> > this is the value assigned for the fill factor of the indexes.
> > Vince
> > Hi
> > Without knowing the previous values then you probably have to restore
> > the
> > backup.
> > John
> > > > "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> > > news:2fa13ee7.0310200423.ca35b7a@.posting.google.co m...
> > > > Hi
> > > > There are a lot of articles about the fillfactor.
> > > > I did change the fill factor and that did not work as intended.
> > > > How do I get back to the default fill factor
> > > > I am using sp_msforeachtable undocumented database procedure
> > > > and when the indexes are rebuilt the fill factor that shows up
> > > > in origfillfactor is the one I am trying to move away from
> > > > > > Your help will be appreciated
> > > > > > Vince

Decimals Converting Back to Integers? Whats Going On?

I am trying use the decimal data type for a field in SQL Server. When I input the values below, they round off.

73.827 Rounds to 74

1925.1 Rounds to 1925

119.79 Rounds to 120

What am I missing? Access never gave me this issue. Do you see any reason this would happen? I am entering the values into the table directly!

What do you mean by "entering the values into the table directly"? And, where are you seeing them rounded?

|||

If I open the table in Enterprise Manager and view all my data. I can add data as well. You know, direct data entry in a table.

When I type 2.756, It rounds to the nearest integer. 2.756 will round to 3. The datatype for the column is decimal. Seems simple problem, but I can't seem to find the resolution.

|||

defyant_2004:

If I open the table in Enterprise Manager and view all my data. I can add data as well. You know, direct data entry in a table.

When I type 2.756, It rounds to the nearest integer. 2.756 will round to 3. The datatype for the column is decimal. Seems simple problem, but I can't seem to find the resolution.

What precision and scale do you have the decimal field set for?

|||

By default the precision will be set to 0 for decimal fields. You might need to adjust it.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

decimal precision of number output

I have a field on my report that is getting a number back from the supporting
stored proc. This number is sometimes a whole number, sometimes a decimal
number.
I want the number output to have 2 decimal places, no matter what the input.
I have tried the conditional formatting on the textbox, but it doesn't seem
to work. Is there a bug? Or am I doing something wrong?
I have input into the "format" section of the properties on the textbox:
#####.##
#,##
d2
D2
2D
2d
d#.##
d#,##
and many variations of the supposed formatting that is supposed to work.
Any suggestions?
Thanks!Hi,
Use an expression like FormatNumber(data,2).
Thanks|||The formatcode property of textboxes uses .NET format codes as defined on
MSDN. For numeric values check these links:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandardnumericformatstrings.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomnumericformatstrings.asp
In your case, it sounds like you want formatcode N2
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"david boardman" <davidboardman@.discussions.microsoft.com> wrote in message
news:8A5FB147-B81B-40AB-9929-091F141358AD@.microsoft.com...
>I have a field on my report that is getting a number back from the
>supporting
> stored proc. This number is sometimes a whole number, sometimes a decimal
> number.
> I want the number output to have 2 decimal places, no matter what the
> input.
> I have tried the conditional formatting on the textbox, but it doesn't
> seem
> to work. Is there a bug? Or am I doing something wrong?
> I have input into the "format" section of the properties on the textbox:
> #####.##
> #,##
> d2
> D2
> 2D
> 2d
> d#.##
> d#,##
> and many variations of the supposed formatting that is supposed to work.
> Any suggestions?
> Thanks!|||Try N2
"david boardman" wrote:
> I have a field on my report that is getting a number back from the supporting
> stored proc. This number is sometimes a whole number, sometimes a decimal
> number.
> I want the number output to have 2 decimal places, no matter what the input.
> I have tried the conditional formatting on the textbox, but it doesn't seem
> to work. Is there a bug? Or am I doing something wrong?
> I have input into the "format" section of the properties on the textbox:
> #####.##
> #,##
> d2
> D2
> 2D
> 2d
> d#.##
> d#,##
> and many variations of the supposed formatting that is supposed to work.
> Any suggestions?
> Thanks!

Debug output no longer displaying?

I must have hit some setting to turn off the debug output, but I can't find how to get it back on. The debug output window displays when I execute a package, I just don't get the execution output I had been getting. Sorry to bother you with such trivia, but any help you can provide is appreciated. Thanks.

If I understand you correctly, then what you are looking for is under 'View - Output'.

Pipo

|||That's what I am looking at, but the output window is empty - nothing is being generated in the window when I execute the package. It had been before - just not anymore.|||Got it. When I right click within the output window the option for program output was not checked. When I clicked on that option to set the check on, I then began to get the output trace again.