Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 49,552 total)

  • RE: CTE Script Needed for delete statement

    GilaMonster (6/29/2016)

    Does that table have an index on the DueDate column?

    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

    June 29, 2016 at 3:42 pm

    #1887747

  • RE: CTE Script Needed for delete statement

    LinksUp (6/29/2016)

    It said something along the lines that transactions are logged but that the space used will be overwritten.

    Yup, that's correct. Simple recovery means that the log space is automatically...

    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

    June 29, 2016 at 3:05 pm

    #1887743

  • RE: t-sql 2012 add data row to temp table

    Maybe remove the WHERE clause that's filtering out the inactive rows? A guess, because you haven't posted the definition of the procedure, so I have no idea what it inserts...

    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

    June 29, 2016 at 2:57 pm

    #1887738

  • RE: CTE Script Needed for delete statement

    Sree Divya (6/29/2016)

    is there any possibility of chance to delete the rows from table WHERE DueDate = '20020701'; USING CTE Funcion.

    Yes, but I don't know why you'd want to seeing...

    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

    June 29, 2016 at 2:40 pm

    #1887733

  • RE: CTE Script Needed for delete statement

    LinksUp (6/29/2016)

    You could try and put the database in simple recovery mode to minimize logging.

    ALTER DATABASE database_name SET Recovery SIMPLE

    -- Do Deletes

    ALTER DATABASE CIS SET Recovery FULL

    Gah!!!

    Simple recovery does not...

    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

    June 29, 2016 at 2:38 pm

    #1887731

  • RE: Are the posted questions getting worse?

    TomThomson (6/29/2016)

    In fact real Britons don't approve of these non-Brit Anglo-Saxon and Norman-French invaders calling themselves Britons. 😛

    You know, after a thousand or so years, I think we can...

    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

    June 29, 2016 at 2:10 pm

    #1887722

  • RE: What is this WHERE clause

    It's the same as WHERE 1=1, a logical condition that can never be false, will never exclude any rows and is ignored by the Query Optimiser

    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

    June 29, 2016 at 2:07 pm

    #1887720

  • RE: SQL Server 2016 is Out and It's Fabulous!

    Jeff Moden (6/29/2016)

    According to Wayne, if you run it in 2014 or better, it still runs but not as expected. Instead of making unique rows, it makes identical rows...

    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

    June 29, 2016 at 2:02 pm

    #1887716

  • RE: Deadlocks with Object Locks - NO objectids

    Screen shots are useless, please post the XML deadlock graph here. Profiler does capture the XML.

    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

    June 29, 2016 at 10:36 am

    #1887681

  • RE: Licensing - Multiplexing

    Please post new questions in a new thread. Thanks

    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

    June 29, 2016 at 10:35 am

    #1887680

  • RE: locked_page_allocations kb is zero will this improve or degrade any performance

    That will only be non-zero if the SQL Server is running with locked pages enabled. Without that, it can't lock pages and hence that value will be zero.

    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

    June 29, 2016 at 7:59 am

    #1887632

  • RE: Deadlock on simple query

    Probably a key-lookup deadlock, table scans wouldn't cause a deadlock if it's just these two queries.

    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

    June 29, 2016 at 6:58 am

    #1887605

  • RE: SQL Server 2016 is Out and It's Fabulous!

    Jeff Moden (6/28/2016)

    Steve Jones - SSC Editor (6/28/2016)

    Jeff Moden (6/25/2016)

    From the Article:

    “This doesn’t work like it used to.”

    While I agree that it probably has fewer bugs that previous releases,...

    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

    June 29, 2016 at 4:54 am

    #1887562

  • RE: Are the posted questions getting worse?

    Hehehe https://www.rockpapershotgun.com/2016/06/28/civilization-vi-english-civ-trailer/

    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

    June 29, 2016 at 3:57 am

    #1887548

  • RE: Deadlock on simple query

    Can you post the deadlock graph?

    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

    June 29, 2016 at 3:17 am

    #1887535

Viewing 15 posts - 2,866 through 2,880 (of 49,552 total)