Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

First time aggregation Expand / Collapse
Posted Wednesday, April 29, 2009 4:33 AM


Group: General Forum Members
Last Login: Friday, July 5, 2013 12:58 AM
Points: 16, Visits: 191

How to decide first time aggregation percentage i.e 1%,10% or 90%. What is the criteria to decide the percentage.

Use 1% on this criteria or Use 40% on this criteria etc.

Thanx in advance.

kamal maurya
Post #706622
Posted Wednesday, April 29, 2009 11:20 AM



Group: General Forum Members
Last Login: Yesterday @ 11:56 AM
Points: 7,508, Visits: 8,664
I'm new to this myself, but I'll take a stab at the answer.

I don't think there is a real criteria. I think it depends on how you want your numbers to turn out. No more, no less.

I can't find this percentage thing in BOL, though, to be certain.

Brandie Tarvin, MCITP Database Administrator

LiveJournal Blog:
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #707077
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse