Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tommyspain

    Proccessor goes 100% Deleting rows

    Hi all: I made a stored procedure as recomended to delete thousands of rows but, why is proccessor burning at 100%? and, how can I monitor it to know what is it doing? This is the procedure fired from a job in Server Manager: CREATE PROCEDURE deletingStat AS Declare @rc int Select @rc=100...
  2. tommyspain

    Deleting thousands of registries

    Thanks guys!!
  3. tommyspain

    Deleting thousands of registries

    I cannot delete (10000000) registries. I tried DELETE FROM stat WHERE idx=62 It sends timeout and the proccessor stays on 100% during so long. I guess there is another way to do it. Thanks in advance.
  4. tommyspain

    AWK output from a tcp stream

    How to massage this input #-------------------------------------------------- interface: eth0 (172.26.0.0/255.255.255.0) filter: ip and ( dst net 212.22.34.154 ) match: GET|POST T 172.26.0.2:33104 -> 212.22.34.154:80 [AP] GET /?idprod=3875 HTTP/1.1..Host: www.novabinary.net..User-Agent...
  5. tommyspain

    How to automate table synchronizing

    Hi all: I'm trying to synchronize some fields from a database to other database that is in a web server and automate that synchronization... Thanks
  6. tommyspain

    How to a foreing key

    Hi all: I'm just trying to add a registry in table A, and then add a registry with a foreing key (autonumeric id from table A) in table B. how do I know the value of the autonumeric field in table A I just added, to insert it to table B Thanks Tomix

Part and Inventory Search

Back
Top