Forum Replies Created

Viewing 15 posts - 11,626 through 11,640 (of 49,552 total)

  • RE: Performance on 10 million row table

    UNION ALL, not UNION. Otherwise you're paying for an unnecessary distinct sort.

    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

    September 20, 2013 at 4:53 pm

    #1652082

  • RE: ScanCount Difference

    Have a look at the execution plans if you want to see how the two queries are run differently. Ignore the scan count, it does not give you particularly useful...

    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

    September 20, 2013 at 8:23 am

    #1651943

  • RE: ScanCount Difference

    Ignore the scan count. It's not the number of times the table has been scanned. It's not consistent.

    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

    September 20, 2013 at 6:47 am

    #1651893

  • RE: List the available fields in a DBCC command

    As I said above, if it's CheckDB you're running, you'll need to use the TABLERESULTS option, checkDB does not by default return a resultset. Other DBCC statements do, so it...

    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

    September 20, 2013 at 6:45 am

    #1651891

  • RE: List the available fields in a DBCC command

    If this is a DBCC statement that only returns messages and you want to insert into a table, you have to use the TABLERESULTS option, otherwise it will only return...

    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

    September 20, 2013 at 6:42 am

    #1651889

  • RE: List the available fields in a DBCC command

    Execute it once and see?

    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

    September 20, 2013 at 6:24 am

    #1651879

  • RE: Beginners Question on Table-Valued Functions

    If you're trying to avoid access to a table, maybe stored procedures?

    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

    September 20, 2013 at 5:57 am

    #1651870

  • RE: Optimize TSQL

    Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    September 20, 2013 at 5:47 am

    #1651869

  • RE: Execution Plans Question

    Is that plan with them being run together with other stuff, or them running separately?

    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

    September 20, 2013 at 5:45 am

    #1651867

  • RE: Invalid object name 'sys.spt_values'

    Honestly, if something's messed up master, I would recommend restoring it from the latest backup before whatever happened.

    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

    September 20, 2013 at 3:27 am

    #1651819

  • RE: Partition Existing Table with Primary Key Clustered Index

    First thing. Why are you partitioning? What's the goal here?

    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

    September 19, 2013 at 4:16 pm

    #1651714

  • RE: Need to set Max Memory?

    dan-572483 (9/19/2013)

    It is said that SQL will gradually consume more and more RAM until the server has to page memory, slowing everything to a crawl.

    No, it'll consume memory until Windows...

    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

    September 19, 2013 at 4:14 pm

    #1651711

  • RE: Execution Plans Question

    Brandie Tarvin (9/19/2013)

    Jack Corbett (9/19/2013)

    Brandie Tarvin (9/19/2013)

    Thanks, Jack.

    Huh. Apparently the Key Lookup shook itself out of the execution plan a bit later on. Now I've got Clustered Index...

    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

    September 19, 2013 at 2:41 pm

    #1651673

  • RE: Execution Plans Question

    Brandie Tarvin (9/19/2013)

    Okay, this is interesting. When I run the first two queries in conjuntion with everything else, the first execution plan changes back to a Key Lookup.

    When I run...

    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

    September 19, 2013 at 2:40 pm

    #1651672

  • RE: Why do i see writes in profiler trace when my query is only a select?

    You could filter for Writes = 0, but that will exclude anything that touches TempDB, so maybe not what you want. Why do you want to exclude anything that writes?

    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

    September 19, 2013 at 12:30 pm

    #1651637

Viewing 15 posts - 11,626 through 11,640 (of 49,552 total)