Forum Replies Created

Viewing 15 posts - 46 through 60 (of 138 total)

  • RE: Five Useful SQL Server Management Practices

    lptech - Wednesday, January 18, 2017 10:00 AM

    My experience is that a monitoring tool is preferable to 'roll your own' solutions. Setting...

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

    January 18, 2017 at 11:57 am

    #1923516

  • RE: Five Useful SQL Server Management Practices

    christoffersen366 - Wednesday, January 18, 2017 2:36 AM

    Great list and I agree with all of it except for 5. Alerts might work...

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

    January 18, 2017 at 2:57 am

    #1923359

  • RE: Five Useful SQL Server Management Practices

    andrew.whettam - Wednesday, January 18, 2017 2:50 AM

    Br. Kenneth Igiri - Tuesday, January 17, 2017 11:45 PM

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

    January 18, 2017 at 2:55 am

    #1923357

  • RE: How to Capture Deleted Records

    Great Article. Thanks so much. I particularly like the fact that you transform the row to XML. Neat.

    maybe it can even be extended... store the audit data in a separate...

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

    December 19, 2016 at 5:44 pm

    #1918789

  • RE: SQL Server 2016: The New @OneResultSet Parameter in SP_SpaceUsed

    Welcome Sirs. Thanks for reading

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

    November 30, 2016 at 2:44 pm

    #1915290

  • RE: Understanding the OVER clause

    Very enlightening for me. Much appreciated.

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

    September 30, 2016 at 5:17 pm

    #1904282

  • RE: SQL Server 2016 Install - VS Shell Installation Failure

    Br. Kenneth Igiri (7/19/2016)

    hawg (6/2/2016)

    Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do...

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

    July 19, 2016 at 7:58 am

    #1890865

  • RE: SQL Server 2016 Install - VS Shell Installation Failure

    hawg (6/2/2016)

    Here is an update on what the issue was for me. Exit code 5 is an "access denied" code. The problem had to do with UAC settings...

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

    July 19, 2016 at 6:00 am

    #1890820

  • RE: CHECKDB found 0 allocation errors and 21 consistency errors in table

    muthukkumaran Kaliyamoorthy (7/18/2016)

    Br. Kenneth Igiri (7/18/2016)

    I think you should also check row count of the affected tables before and after repair_allow_data_loss.

    Yep, Already did that. Since, There was a variation.

    Depending on...

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

    July 19, 2016 at 1:50 am

    #1890777

  • RE: CHECKDB found 0 allocation errors and 21 consistency errors in table

    I think you should also check row count of the affected tables before and after repair_allow_data_loss.

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

    July 18, 2016 at 8:34 am

    #1890611

  • RE: SQL 2012 to 2016 - Possible Application Issues

    Taranjit Singh-373811 (7/17/2016)

    From SQL Server 2014 onwards , MS have changed Cardinality Estimator. This has improved some of the application, while degraded some of the queries drastically leading to roll...

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

    July 18, 2016 at 8:32 am

    #1890610

  • RE: Upgrade to SQL Server 2016 - Unauthorized operation - Cannot Open Reg SubKey

    Oh my goodness! I can't believe it. It was McAfee again!!! Been at this all day. Thank so much.

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

    July 14, 2016 at 9:36 am

    #1890140

  • RE: Microsoft SQL Developer Certification For beginers

    kailashsingh85 (7/13/2016)

    Hello,

    Anyone suggest for Microsoft SQL DBA Certification For beginners.

    Please let me know topics, exam level wise, fee where we can attend.

    Thanks,

    Kailash

    You can get those details at this site, Kailash:...

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

    July 14, 2016 at 8:38 am

    #1890130

  • RE: SQL Server 2016 Upgrade Advisor Seems Really Buggy

    I should add that you need to "Allow Blocked Content" when opening the resulting HTML file on IE

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

    July 14, 2016 at 8:34 am

    #1890126

  • RE: SQL Server 2016 Upgrade Advisor Seems Really Buggy

    You need to save the report as HTML then read the report. You will see the issue there. I will post a screen shot shortly.

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

    July 14, 2016 at 8:08 am

    #1890120

Viewing 15 posts - 46 through 60 (of 138 total)