Why (Sometime) SQL Server query insert twice instead of once? specially when traffic jam and slow response of Network.

One of the possibilities. The table is not having a primary key or unique key. The constraints may be disabled before firing the insert statement. If the table is having primary foreign key relation ship it is not at all possible.Or might be be you are seeing a merge replication or snap shot replication of the server.