Forum Replies Created

Viewing 15 posts - 481 through 495 (of 758 total)

  • RE: Index Range_scans

    HowardW (8/8/2012)

    Because it's not a UNIQUE index, so it's retrieving a range of values that match your criteria rather than a singleton lookup.

    Thanks

    I don't understand this because my result returns...

    August 10, 2012 at 4:16 am

    #1524303

  • RE: SQL Query Performance

    Grant Fritchey (7/31/2012)

    SQLSACT (7/31/2012)

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that...

    August 2, 2012 at 5:11 am

    #1520736

  • RE: Index Usage - Deleted

    opc.three (8/1/2012)

    SQLSACT (7/31/2012)

    pooyan_pdm (7/31/2012)

    To increase the performance of DELETE operation the records are not deleted immediately, instead they are marked as ghosted . A background process called ghost cleanup...

    August 2, 2012 at 2:19 am

    #1520686

  • RE: SQL Query Performance

    GilaMonster (8/1/2012)

    Yes.

    Great Stuff - Thanks

    I'm finding the performance part of SQL Server to be a very challenging side

    August 1, 2012 at 8:22 am

    #1520308

  • RE: SQL Query Performance

    Grant Fritchey (8/1/2012)

    Looks ok. No, it doesn't ignore procedures. Procedures show up in both query stats and proc stats. You can just use proc stats to narrow down what you're...

    August 1, 2012 at 8:13 am

    #1520295

  • RE: SQL Query Performance

    GilaMonster (8/1/2012)

    SQLSACT (7/31/2012)

    I've put this together for a "SQL is Slow Now" situation, am I on the right track here?

    Two things:

    - Firstly cross apply to sys.dm_sql_text for the SQL...

    August 1, 2012 at 6:09 am

    #1520202

  • RE: SQL Query Performance

    Grant Fritchey (7/31/2012)

    SQLSACT (7/31/2012)

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that...

    July 31, 2012 at 11:53 pm

    #1520078

  • RE: SQL Query Performance

    Grant Fritchey (7/31/2012)

    SQLSACT (7/31/2012)

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that...

    July 31, 2012 at 11:49 pm

    #1520077

  • RE: Index Usage - Deleted

    pooyan_pdm (7/31/2012)

    To increase the performance of DELETE operation the records are not deleted immediately, instead they are marked as ghosted . A background process called ghost cleanup task later...

    July 31, 2012 at 11:46 pm

    #1520075

  • RE: SQL Query Performance

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that DMV is lost....

    July 31, 2012 at 10:28 am

    #1519841

  • RE: SQL Query Performance

    Grant Fritchey (7/31/2012)

    The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that DMV is lost....

    July 31, 2012 at 10:25 am

    #1519837

  • RE: keeping dev and live databases in sync

    erics44 (7/31/2012)

    Does anyone know of any ways to keep a dev database up-to-date with changes on a live database without doubling up on the work?

    Thanks in advance

    Log Shipping or a...

    July 31, 2012 at 5:00 am

    #1519613

  • RE: Sysadmin Priveleges

    anthony.green (7/26/2012)

    If you grant the server level role sysadmin you dont need to grant anything else as your effictivly saying you can do what you want where you want.

    Thanks

    July 26, 2012 at 2:15 am

    #1517775

  • RE: profiler trace based on program name

    sage8 (7/25/2012)

    hi,

    a request was made for us to capture a profiler trace given a program name.

    though i do see the column Program_Name in sp_who2, what is the equivalent event/column...

    July 25, 2012 at 11:51 pm

    #1517740

  • RE: Index Usage - Lookups

    GilaMonster (7/24/2012)

    Your query is returning too high a % of rows for the seek and key lookup to be cost effective then.

    300 rows is too small to test and draw...

    July 24, 2012 at 6:41 am

    #1516746

Viewing 15 posts - 481 through 495 (of 758 total)