Forum Replies Created

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

  • RE: LCK_M_U delete 4999 rows.

    bmg002 - Friday, February 17, 2017 8:36 AM

    charliex - Friday, February 17, 2017 8:17 AM

    February 17, 2017 at 8:52 am

    #1929142

  • RE: LCK_M_U delete 4999 rows.

    bmg002 - Friday, February 17, 2017 8:04 AM

    What do you get from:
    SELECT count(*) FROM tablename 
    WHERE Column >= getdate()-5

    I am wondering if instead...

    February 17, 2017 at 8:17 am

    #1929128

  • RE: LCK_M_U delete 4999 rows.

    John Mitchell-245523 - Friday, February 17, 2017 7:10 AM

    If you aren't using the while loop any more, what method are you using...

    February 17, 2017 at 7:43 am

    #1929111

  • RE: LCK_M_U delete 4999 rows.

    ScottPletcher - Thursday, February 16, 2017 4:38 PM

    How is the table clustered?  If it's clustered on the date, you'll be...

    February 17, 2017 at 6:56 am

    #1929089

  • RE: ODBC Connection Timeouts SQL Server 2008 R2 Cluster

    thomas.gundolf (5/15/2012)

    Hello,

    thank you. My problem is bit different. Not just the first call brings the error. The whole time there are errors randomly.

    My Instance is a clustered instance, so it's...

    July 14, 2012 at 5:45 pm

    #1512839

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