Forum Replies Created

Viewing 15 posts - 91 through 105 (of 151 total)

  • RE: how to find and update data between two tables in different databases

    mtlsql (6/28/2015)


    I have a hard time understanding your example, so I don't know if this is the answer you're looking for, but have you looked into the syntax for a...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: How Can I Control "Buffer Manager Free Pages" Spikes

    GilaMonster (6/27/2015)


    If you don't feel like the alert is useful, disable it.

    OK. Thanks. Will consider that option.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: How Can I Control "Buffer Manager Free Pages" Spikes

    GilaMonster (6/26/2015)


    Why would you want more than 20% of you memory to not be used? Surely the point is to ensure that the data cache is used, not that SQL...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    Thanks a lot... 🙂

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    Oscardmg (2/19/2015)


    Hello

    I want to know if after you rebuild and reorganize the need to update the statistics with the command "EXEC sp_updatestats"

    Thanks.

    A reindex also updates stats with a good sample...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    james.a.payne (2/17/2015)


    OP: Something that might be useful for you down the track is to only reorganize indexes that allow page locks. Otherwise it will throw an error and the index...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    ScottPletcher (2/17/2015)


    There is no such thing as an accurate, global freespace percentage. Freespace needs to be set index by index. Thus, a generic rebuild should never specify a...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    jdurandt (2/16/2015)


    106 automatically created databases....

    Wow! :crazy:

    Interesting script though, thanks! 🙂

    haha... 106 as at last count... I would have mentioned the application but I fear being sued 😀

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Rebuilding Index - 1 Instance, 106 Databases

    shivendrakumaryadav60 (2/16/2015)


    Hi,

    . wow..nice script...:-)...very true.....I am having the same scenario. And index maintenance become a very crucial in this situation. I am using more or less same script...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: Edition Upgrade from MS SQL 2012 C0 to MS SQL 2012 Enterprise

    maliqiakbar (1/30/2015)


    Select @@version is the command to give you information about sql server edition that is used. If you cannot even go to the instance have you try restarting the...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: Edition Upgrade from MS SQL 2012 C0 to MS SQL 2012 Enterprise

    maliqiakbar (1/30/2015)


    have you check it by running @@version command?

    In my case we are already past 180 days so I can no longer access the instance to check @@version. Could this...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: Edition Upgrade from MS SQL 2012 C0 to MS SQL 2012 Enterprise

    The instance is not clustered.

    I ran setup and used the maintenance> Edition Upgrade option on installation centre.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Fragmented Disk and High PAGEIOLATCH Waits

    kdburger (4/20/2012)


    I'm just a novice, and probably shouldn't even post to this site. But, I wanted to ask what is likely a rediculous question. How did you 'extend the...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: The Real World: Fragmented Disk and High PAGEIOLATCH Waits

    ... Thus, My general recommendation in a SAN environment would be to present a new LUN to the server, partition and format it correctly, then move the data files. Yes,...

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

  • RE: Replication - How to tell if transaction has been applied to a subscriber

    The replication Monitor also helps. Rightclick your pubication and select Launch Replication Monitor.

    Br. Kenneth Igiri
    https://kennethigiri.com
    All nations come to my light, all kings to the brightness of my rising

Viewing 15 posts - 91 through 105 (of 151 total)