Forum Replies Created

Viewing 15 posts - 22,651 through 22,665 (of 49,552 total)

  • RE: Index scan vs. seek

    Lexa (10/28/2011)

    Execution plans is 100% index seek on my_index

    In your initial post you said you had a scan.

    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

    October 28, 2011 at 10:01 am

    #1400702

  • RE: SQL Server 2008 memory usage exceeds configured Max Server Memory

    You can only control the buffer pool. The non-buffer pool memory should be relatively small, unless you're doing weird things with CLR. If SQL as a whole is using too...

    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

    October 28, 2011 at 10:01 am

    #1400701

  • RE: [Trigger] Update a Datetime column when insert/update/delete

    Bulk operations in general, regardless of where they originate, don't fire triggers by default.

    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

    October 28, 2011 at 9:20 am

    #1400678

  • RE: Backup

    'full' is not a keyword on backups.

    p.s. please don't create stored procedures starting with sp_. sp means system procedure, and yours is not a system procedure.

    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

    October 28, 2011 at 9:11 am

    #1400672

  • RE: Are the posted questions getting worse?

    GSquared (10/28/2011)

    I improved the typing input by getting a better (more predictive) "keyboard" for it. But input is still very, very slow and cumbersome compared to a real keyboard.

    I...

    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

    October 28, 2011 at 6:57 am

    #1400608

  • RE: Are the posted questions getting worse?

    Kiara (10/28/2011)

    Hm. That's good to hear - because I've had several of our iPad crowd tell me otherwise when I asked them to help me figure out why the thing...

    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

    October 28, 2011 at 6:55 am

    #1400606

  • RE: Trigger Help

    Add in

    @data.value('(/EVENT_INSTANCE/HostName)[1]', 'varchar(256)')

    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

    October 28, 2011 at 6:40 am

    #1400599

  • RE: SQL Server 2008 memory usage exceeds configured Max Server Memory

    Yup. Perfectly normal.

    Max server memory is the max size of the buffer pool, the memory area that contains the data cache, plan cache and a whole bunch of other caches....

    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

    October 28, 2011 at 6:36 am

    #1400598

  • RE: Are the posted questions getting worse?

    Kiara (10/28/2011)

    Second is that I find Apple's refusal to allow, say, an iPad to charge from the USB port on my ThinkPad unacceptable. Every other device I have can be...

    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

    October 28, 2011 at 6:33 am

    #1400596

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    jorge_gomes98 (10/28/2011)

    I notice if i can recover bad sectors in failed disk.

    Possibly, but disk recovery companies charge huge amounts of money.

    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

    October 28, 2011 at 6:30 am

    #1400593

  • RE: Replication & Shrink log file

    No, but why are you trying to shrink the log?

    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

    October 28, 2011 at 5:49 am

    #1400577

  • RE: Help - Reading data from row by row - without using cursor?

    Why? 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

    October 28, 2011 at 5:49 am

    #1400574

  • RE: DBCC checkdb fials on several databases, but not all

    Ninja's_RGR'us (10/28/2011)

    Unless Gails recommends a reboot don't do it. The situation might just get worse.

    Reboot - not necessary. Restart of SQL may help, or may do nothing

    For NTFS you...

    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

    October 28, 2011 at 5:46 am

    #1400572

  • RE: Index scan vs. seek

    JonFox (10/28/2011)

    okbangas (10/28/2011)

    JonFox (10/27/2011)

    Index fragmentation shouldn't have an impact on whether the query optimizer chooses a scan over a seek; the optimizer tries to minimize reads when choosing a query...

    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

    October 28, 2011 at 5:41 am

    #1400569

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    I doubt you'll recover anything that you haven't already got.

    Probably a good time to impress on management that a good backup would have saved days of work and prevented 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

    October 28, 2011 at 5:41 am

    #1400568

Viewing 15 posts - 22,651 through 22,665 (of 49,552 total)