Post reply

Table contain 1991627343 rows

  • August 11, 2011 at 5:53 am

    #246136

    Hello,

    Anyone help me following situation,

    I have one table contain 1991627343 rows,

    when am using count(*)-am getting the error "Msg 10054, Level 20, State 0, Line 0

    A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"

    But using Count(Columnname)-getting output 991627343 rows

    I couldn't use this table for joining with anyother table.

    could anyone help me on this,how to proceed,how can i use this table for join with other table.

    Thanks,

    tony

  • August 11, 2011 at 6:07 am

    #1367209

    That error means that the connection was closed either by SQL or due to a server restart or something similar.

    Run this on the DB and post the results.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply