Forum Replies Created

Viewing 15 posts - 23,251 through 23,265 (of 49,552 total)

  • RE: Know when to hold 'em

    sturner (9/27/2011)

    GilaMonster (9/27/2011)

    Great for people from the East coast, far from great for anyone coming from Europe (or for that matter just about anywhere outside the USA). Oh well..

    Sadly, my...

    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 27, 2011 at 9:15 am

    #1387236

  • RE: Know when to hold 'em

    Steve Jones - SSC Editor (9/27/2011)

    It is coming to Charlotte in 2013, IIRC

    Great for people from the East coast, far from great for anyone coming from Europe (or for that...

    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 27, 2011 at 8:44 am

    #1387215

  • RE: Know when to hold 'em

    sturner (9/27/2011)

    Maybe someday you'll have one these PASS summits on the east coast so I can attend.:cool:

    http://www.sqlpass.org/Community/PASSBlog/entryid/334/Announcing-PASS-Summit-2013-in-Charlotte.aspx

    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 27, 2011 at 8:39 am

    #1387206

  • RE: Log File Size is CRITICAL **

    http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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 27, 2011 at 8:35 am

    #1387199

  • RE: How to avoid sort warnings?

    Sort warnings (and hash warnings) are typically due to row estimation errors. You may have parameter sniffing, you may have stale stats. Check for both.

    btw, IN and INNER JOIN can't...

    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 27, 2011 at 8:34 am

    #1387197

  • RE: REBUILD for heaps

    opc.three (9/27/2011)

    Disabled indexes are not maintained...unless BOL is wrong which is something Gail has compelled me to consider given all the times she has cited incorrect docs 😉 That is...

    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 27, 2011 at 8:00 am

    #1387170

  • RE: Need Joins statement

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 27, 2011 at 7:42 am

    #1387152

  • RE: want to remove subquery from join?

    Since you're looking for two different sets of data from that table, you will need to have it in the query twice. Whether as subqueries or in a join won't...

    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 27, 2011 at 7:32 am

    #1387146

  • RE: Identifying a process that is blocking our APP

    Exactly the way Grant's just said. It doesn't matter where the SQL is coming from, blocking is detected the same way.

    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 27, 2011 at 5:45 am

    #1387047

  • RE: Profiler and execution plan giving different results

    As I said, if you want more accurate estimations, don't use table variables. The insert probably has a fairly accurate cost, but using the table variable to insert into other...

    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 27, 2011 at 4:06 am

    #1387018

  • RE: Profiler and execution plan giving different results

    Don't use table variables unless you're using them in a way that doesn't affect the costings (insert into @var and straight select * from @var). Joins, filters, aggregations, etc are...

    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 27, 2011 at 3:58 am

    #1387015

  • RE: Performance issues

    Tivoli Workload Scheduler I believe.

    If so, then this error needs to be taken up with the Tivoli support, it's not a SQL Server error.

    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 27, 2011 at 3:50 am

    #1387011

  • RE: Profiler and execution plan giving different results

    Ramji29 (9/27/2011)

    This makes a bit sense.... Now I'm testing on my test box... and if I rebuild all indexes of the tables involved and update statistics.... Can I expect to...

    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 27, 2011 at 3:44 am

    #1387008

  • RE: total_pages in Sys.allocation_untis returning negative values ?

    There isn't one. DBCC UPDATEUSAGE is what fixes this kind of error. Shouldn't be necessary to run after SQL 2005 SP3.

    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 27, 2011 at 3:43 am

    #1387004

  • RE: total_pages in Sys.allocation_untis returning negative values ?

    DBCC UPDATEUSAGE.

    Let me guess, a database upgraded from SQL 2000?

    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 27, 2011 at 3:28 am

    #1386995

Viewing 15 posts - 23,251 through 23,265 (of 49,552 total)