Page 3 of 3 FirstFirst 123
Results 21 to 29 of 29

Getting started with PowerPivot

This is a discussion on Getting started with PowerPivot within the PowerPivot Questions forums, part of the Question Forums category; Originally Posted by RoryA The database size limitation for SQL Server 2012 is 524,272 terabytes which should be enough... Bloody ...

  1. #21
    Board Regular
    Join Date
    May 2012
    Posts
    330

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by RoryA View Post
    The database size limitation for SQL Server 2012 is 524,272 terabytes which should be enough...
    Bloody well hope so!

  2. #22
    Board Regular
    Join Date
    May 2012
    Posts
    330

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by RoryA View Post
    The database size limitation for SQL Server 2012 is 524,272 terabytes which should be enough...
    I'm confused.

    This is where I got the 10GB limit:

    SQL Server 2008 R2 Express Database Size Limit Increased to 10GB - SQL Server Express WebLog - Site Home - MSDN Blogs

  3. #23
    New Member
    Join Date
    Mar 2013
    Posts
    20

    Default Re: Getting started with PowerPivot

    I am no expert, but SQL Server 2008 R2 Express is probably not the same as SQL Server 2012 without Express in the name.

  4. #24
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    East Sussex
    Posts
    22,133

    Default Re: Getting started with PowerPivot

    Not even the same version, never mind same SKU.

  5. #25
    Board Regular
    Join Date
    May 2012
    Posts
    330

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by RoryA View Post
    Not even the same version, never mind same SKU.
    I've got SQL Server Man Studio 2008 R2 so what's its limit?

  6. #26
    New Member
    Join Date
    Mar 2013
    Posts
    20

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by dugdugdug View Post
    I've got SQL Server Man Studio 2008 R2 so what's its limit?
    You are probably right about the file size, Express is a free verison, therefore there will be some limits, if you have a full Version, those will be removed.

    Where do you get your csv files from? I might be easier to get odbc access to that database and load data in smaller chunks below a million rows, as you need them, instead of setting up a new database. And even if you have done that, the million row Limit in Excel will still exist.

    Also, have you tried your VBA Code on something Close to a million rows? As far as I remember, this could be really slow/not work at all, maybe because VBA does not take advantage of several processor cores.

    Have you ever worked with Excel tables and created your on columns with Excel functions? The if clauses you mentioned above could be created there as well, and whenever the data is refreshed, it would recalculate your columns automatically. If yes, you could do the same with Powerpivot, as I ried to explain above. Maybe you should just give it a try.
    Last edited by prez02; Apr 4th, 2013 at 12:56 PM.

  7. #27
    Board Regular
    Join Date
    May 2012
    Posts
    330

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by prez02 View Post
    You are probably right about the file size, Express is a free verison, therefore there will be some limits, if you have a full Version, those will be removed.

    Where do you get your csv files from? I might be easier to get odbc access to that database and load data in smaller chunks below a million rows, as you need them, instead of setting up a new database. And even if you have done that, the million row Limit in Excel will still exist.

    Also, have you tried your VBA Code on something Close to a million rows? As far as I remember, this could be really slow/not work at all, maybe because VBA does not take advantage of several processor cores.

    Have you ever worked with Excel tables and created your on columns with Excel functions? The if clauses you mentioned above could be created there as well, and whenever the data is refreshed, it would recalculate your columns automatically. If yes, you could do the same with Powerpivot, as I ried to explain above. Maybe you should just give it a try.
    Thanks for your tips.

    My csv files are "floating around" at the moment, ie my programs are based on the assumption that such files exists and are stored somewhere on the network drive (which is slow) somy first step involves copying it to my C drive.

    For security reasons, I have no direct access to where the data is stored, possibly in a SQL database.

    A million rows is not a problem if I only do a few things to it. My method is involves using arrays so Redim myarray(1 to n, 1 to m) As Variant, where n is 200,000, m is 300 is possible (though I am not sure what the limit is) but as I constantly do my manipulation and create further sub arrays, the memory limit will be eventually be reached and the program crashes.

    Isn't Excel tables used for formatting purposes? My tasks include more complicated procedures so not sure if that would work.

  8. #28
    New Member
    Join Date
    Mar 2013
    Posts
    20

    Default Re: Getting started with PowerPivot

    Quote Originally Posted by dugdugdug View Post
    Thanks for your tips.

    [...]
    Isn't Excel tables used for formatting purposes? [...]
    Here is another tip, statements like that will not help you to make friends in an Excel forum.

    Excel is used in a lot of different ways and can do a lot of different things. You can use it to accidently bring down a whole investment bank, if youl like that sort of thing.

    I am not sure what you are trying to achieve, why you have to transform your data in the way you do, what the results should be and who is using them for what purpose.. Maybe someone could help you looking at your code and tell you if this can be achieved in another way, e.g via Excel functions or not. Good luck.

    Carsten

  9. #29
    New Member
    Join Date
    Mar 2013
    Posts
    20

    Default Re: Getting started with PowerPivot

    JIC, additional information about SQL Server Express RAM limit: link
    Last edited by prez02; Apr 5th, 2013 at 10:02 AM.

Page 3 of 3 FirstFirst 123

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com