Forum Replies Created

Viewing 15 posts - 76 through 90 (of 5,841 total)

  • RE: Automate LogSHipping for multiple databases

    Everything related to log shipping is available to you for direct manipulation and execution, including system tables and sproc and jobs. Script one out using the GUI and create the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 17, 2018 at 4:54 pm

    #1976252

  • RE: UPDATE() function in a trigger

    Aaron N. Cutshall - Wednesday, January 17, 2018 1:17 PM

    I have a database environment to support that features instead-of triggers on views...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 17, 2018 at 4:52 pm

    #1976251

  • RE: AlwaysON AG in SQL serer 2012

    Database admin(DBA) - Wednesday, January 17, 2018 2:22 PM

    Hi All,

    I'm planning to setup AlwayON AG top of fail-over cluster feature enabled for...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 17, 2018 at 4:50 pm

    #1976250

  • RE: Memory pressure and SQL errors

    Eliyahu - Wednesday, January 17, 2018 4:07 PM

    After migration from 2008R2 to 2016, we are plugged with unexplained SQL errors like "cannot...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 17, 2018 at 4:48 pm

    #1976249

  • RE: When updating one row in a table, update trigger creates 3 rows in audit table

    webskater - Tuesday, January 16, 2018 6:54 AM

    TheSQLGuru - Monday, January 15, 2018 4:11 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 16, 2018 at 7:29 pm

    #1976088

  • RE: When updating one row in a table, update trigger creates 3 rows in audit table

    1) Don't declare variables and put stuff into them and then use in SELECT like that. Just put the system function calls in the SELECT.

    2) Are you 100%...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 15, 2018 at 4:11 pm

    #1975940

  • RE: Ola's maintenance solution taking too long on VLDB's

    Nadrek - Friday, January 12, 2018 7:58 AM

    TheSQLGuru - Thursday, January 11, 2018 4:13 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 12, 2018 at 2:19 pm

    #1975788

  • RE: Using Trace Flag 2453 to Improve Table Variable Performance

    nirav.gandhi7 - Wednesday, January 10, 2018 8:33 PM

    Thanks. but right now we are not going to change any objects on current database.we...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 11, 2018 at 6:45 pm

    #1975660

  • RE: Ola's maintenance solution taking too long on VLDB's

    Eric M Russell - Thursday, January 11, 2018 7:23 AM

    Does anyone here besides me implement partitioning on indexes just for taking advantage...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 11, 2018 at 4:13 pm

    #1975654

  • RE: Query with Where clause + 3 OR clauses not working

    Glad the mismatched datatypes worked out. Like I said - biggest performance problem in total in all my consulting. 😎

    I don't have time to dig into it, plus...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 11, 2018 at 4:10 pm

    #1975653

  • RE: Query with Where clause + 3 OR clauses not working

    jeffshelix - Wednesday, January 10, 2018 4:12 PM

    after 40 minutes, none of the three conditions were returned in my results  . ....

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 10, 2018 at 8:20 pm

    #1975437

  • RE: Ola's maintenance solution taking too long on VLDB's

    Jeff Moden - Wednesday, January 10, 2018 4:17 PM

    TheSQLGuru - Wednesday, January 10, 2018 9:55 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 10, 2018 at 8:16 pm

    #1975436

  • RE: Using Trace Flag 2453 to Improve Table Variable Performance

    nirav.gandhi7 - Tuesday, January 9, 2018 6:13 AM

    We have enabled trace 2453( table variable performance) in SQL(2016) Server level and fix...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 10, 2018 at 9:58 am

    #1975339

  • RE: Ola's maintenance solution taking too long on VLDB's

    1) I don't know why anyone hasn't asked the obvious question yet: What is the server you are running all this on? Please provide details, especially on CPU, RAM and...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 10, 2018 at 9:55 am

    #1975338

  • RE: Splitting TempDB across multiple files

    1) You absolutely can harm performance by having too many tempdb files on insufficient IO performance storage. I have fixed this numerous times at clients.

    2) PLE is an...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    January 10, 2018 at 9:45 am

    #1975329

Viewing 15 posts - 76 through 90 (of 5,841 total)