Post reply

Insert into table varying with time

  • April 14, 2014 at 3:32 am

    #1705686

    If there isn't any blocking or any other SQL statement running at that moment..could network congestion be an issue ? or automatic file growth happening at the background ? ... SSC experts would be able to provide more insight ..

  • April 14, 2014 at 3:47 am

    #1705695

    This is normal.

    This is due to internal SQL Server processing. Sometime when query plan is available for your query it will executed immediately. Also in the destination table if pagesplit or anyother thing needs to be happening than it may take slightly longer time. Also it depends on the server load and resource availability.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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