Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:10 PM
Points: 5,669, Visits: 6,475
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

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
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