Forum Replies Created

Viewing 15 posts - 61 through 75 (of 151 total)

  • 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

  • RE: Simulating Failure in AlwaysOn AG

    Thanks all. I eventually solved this by setting the Maximum Failures in the specified period for the Cluster Role which has the same name as my Availability Group to...

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

    July 7, 2016 at 12:29 am

    #1888845

  • RE: Simulating Failure in AlwaysOn AG

    Beatrix Kiddo (7/5/2016)

    Br. Kenneth Igiri (7/5/2016)the AG instance role does not automatically start on the secondary.

    So you have two SQL instances with at least one Availability Group on there? Can...

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

    July 5, 2016 at 3:05 pm

    #1888572

  • RE: SQL 2012 to 2016 - Possible Application Issues

    Thanks a lot folks. Will heck out what Upgrade Advisor can tell me. And definitely we are testing but wanted some experience too since I believe some folk out there...

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

    July 4, 2016 at 10:07 am

    #1888337

Viewing 15 posts - 61 through 75 (of 151 total)