locked
Row Limitation RRS feed

  • Question

  • Hey Everyone, 

    When we make the data views then every time my data records gets truncated. It happens only when the no of records are more than 100000.For me it happens every time since my no of records are close to 80-90 millions. So is there any default value for this. Is there any configuration file that we can edit & change the no of records value. If anyone knows please help. Thanks in advance.

    Thanks 

    Shivam 

    Friday, February 12, 2016 12:52 PM

Answers

  • Hi Shivam,

    There are not any limitations on Number of rows on a table or set of tables. It has limitations of database of up to 10GB for SQL 2008R2 onwards.

    Regards,

    Balwant.


    Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCSA (SQL 2012) , MCTS (SQL Server 2005) http://blog.vspatel.co.uk/

    Friday, February 12, 2016 12:57 PM

All replies

  • Hi Shivam,

    There are not any limitations on Number of rows on a table or set of tables. It has limitations of database of up to 10GB for SQL 2008R2 onwards.

    Regards,

    Balwant.


    Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCSA (SQL 2012) , MCTS (SQL Server 2005) http://blog.vspatel.co.uk/

    Friday, February 12, 2016 12:57 PM
  • Hello Shivam,

    Where / what for a front end application is limiting the rows of the result set?


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, February 12, 2016 1:04 PM
  • Sql server have no limitation command like mysql, but may be you can use 'select top 100 * from [table]'
    Wednesday, February 17, 2016 3:47 AM
  • In addition to Top

    Also check for session setting like

    SET ROWCOUNT 100000
    Refer : https://msdn.microsoft.com/en-IN/library/ms188774.aspx?f=255&MSPPError=-2147217396

    Please let us know where(Application) you are facing this issue


    Thanks Saravana Kumar C

    Wednesday, February 17, 2016 4:59 AM