Forum Replies Created

Viewing 15 posts - 25,906 through 25,920 (of 49,552 total)

  • RE: Does anybody know the list of execution plans which include FULL-TABLE SCAN

    You would need to look into the xml plan itself and look for table scan or clustered index scan operators.

    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

    May 26, 2011 at 8:11 am

    #1330333

  • RE: Are the posted questions getting worse?

    Roy Ernest (5/26/2011)

    I have an idea for one of persons who want to go to SQL Pass summit for free (Except air travel). Make list here who wants to go...

    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

    May 26, 2011 at 8:09 am

    #1330332

  • RE: Execution Plan Aging

    Fraggle-805517 (5/26/2011)

    When my company writes procedures, it often passes in a QueryType to a stored procedure. This is so that they can keep code in one place for the...

    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

    May 26, 2011 at 6:34 am

    #1330247

  • RE: Execution Plan Aging

    Well I haven't even started to think about such a post so...

    The profiler event is called "Performance Statistics" It's a single event.

    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

    May 26, 2011 at 6:31 am

    #1330241

  • RE: My intellisense is not working

    What's the version of the SQL Server that you are connected 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

    May 26, 2011 at 5:40 am

    #1330196

  • RE: Strange Results, Operator Precedence !

    AND takes precedence over OR, it's done first. So without brackets this:

    ID = 1 OR ID = 2 AND Salary > 500 AND Salary < 1000

    is actually evaluated...

    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

    May 26, 2011 at 5:39 am

    #1330195

  • RE: Execution Plan Aging

    If you want the exact time it goes away, profiler (server side trace better) the performance statistics event (under Performance)

    Hmm, that event needs a blog post.

    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

    May 26, 2011 at 5:22 am

    #1330179

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/25/2011)

    Steve Jones - SSC Editor (5/25/2011)

    GilaMonster (5/25/2011)

    Grant and I are talking Execution plans for a whole day at PASS Summit this year.

    You are all coming? Right?

    Is 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

    May 26, 2011 at 4:53 am

    #1330157

  • RE: Are the posted questions getting worse?

    Jeff Moden (5/25/2011)

    GilaMonster (5/23/2011)

    Just got a PM and a mail asking for some free consulting. I sympathise with people in tough situations, but that doesn't mean I'm willing to give...

    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

    May 26, 2011 at 4:43 am

    #1330152

  • RE: can we take backup at two sparate disk at one time .

    Please don't post the same question in several places.

    Replies to this please to http://www.sqlservercentral.com/Forums/Topic1115242-1550-1.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

    May 26, 2011 at 4:43 am

    #1330151

  • RE: Backup error

    Ivan Mohapatra (5/26/2011)

    hi sir ,

    i am taking backup from sql server authentication from my system in office but it is throughing error.

    Msg 3201, Level 16, State 1, Line 1

    Cannot...

    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

    May 26, 2011 at 4:43 am

    #1330150

  • RE: can we take backup at two sparate disk at one time .

    Are you going to tell us the 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

    May 26, 2011 at 4:29 am

    #1330139

  • RE: How to get the last index rebuild date?

    Sumanta Roy (5/26/2011)

    Select Name as IndexName,

    STATS_DATE ( object_id , index_id ) as IndexCreatedDate

    From sys.indexes

    That is not the last rebuild date of the index, it's the date the statistics were...

    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

    May 26, 2011 at 4:27 am

    #1330136

  • RE: Are the posted questions getting worse?

    Jim Murphy (5/25/2011)

    I guess, I would love to see a precon (not necessarily this one, but here's an idea for the future), where we walk in and have a business...

    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

    May 26, 2011 at 4:25 am

    #1330134

  • RE: Statistics for performance

    sqlnaive (5/26/2011)

    While checking the indexes on few of the tables I found that one clustered index shows two entries. One for IN_ROW_DATA and another for LOB_DATA. Though there are only...

    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

    May 26, 2011 at 4:21 am

    #1330131

Viewing 15 posts - 25,906 through 25,920 (of 49,552 total)