Forum Replies Created

Viewing 15 posts - 211 through 225 (of 5,841 total)

  • RE: My db has a lot of PAGELATCH_SH waits going on

    Jacob Wilkins - Friday, July 21, 2017 11:55 AM

    PAGEIOLATCH_* waits occur when a page has to be fetched from disk into the...

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

    July 21, 2017 at 2:36 pm

    #1952216

  • RE: Stored procedure is a lot slower than standard query

    richardmgreen1 - Friday, July 21, 2017 4:59 AM

    Hi Gail

    The linked servers are using an account with SysAdmin privileges.  It's a SQL-only login.
    I'll...

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

    July 21, 2017 at 11:54 am

    #1952172

  • RE: My db has a lot of PAGELATCH_SH waits going on

    Perry Whittle - Friday, July 21, 2017 6:45 AM

    girac127 - Thursday, July 20, 2017 8:51 AM

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

    July 21, 2017 at 11:44 am

    #1952169

  • RE: My db has a lot of PAGELATCH_SH waits going on

    girac127 - Thursday, July 20, 2017 12:09 PM

    TheSQLGuru - Thursday, July 20, 2017 10:40 AM

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

    July 20, 2017 at 8:13 pm

    #1951993

  • RE: My db has a lot of PAGELATCH_SH waits going on

    girac127 - Thursday, July 20, 2017 8:51 AM

    Hi all, Hope this topic is in the right area. 

    I have a highly normalized Dynamics...

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

    July 20, 2017 at 10:40 am

    #1951913

  • RE: Need help to find employee history

    Sunitha, you have enough visits and points on SSC.com to know how to post a question on the forum. We need create table scripts, inserts and expected output. There probably...

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

    July 18, 2017 at 6:50 am

    #1951379

  • RE: In place 2012 to 2104 upgrade and log shipping

    tcronin 95651 - Monday, July 17, 2017 9:47 AM

    not a choice with this one so will have to wing it.

    Good luck. I...

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

    July 17, 2017 at 11:34 am

    #1951231

  • RE: In place 2012 to 2104 upgrade and log shipping

    tcronin 95651 - Monday, July 17, 2017 8:14 AM

    GOing to do in place upgrade from 2012 to 2014.  Currently have log shipping....

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

    July 17, 2017 at 9:40 am

    #1951197

  • RE: Using Queues

    mike 57299 - Sunday, July 16, 2017 10:51 AM

    I am trying to figure out queues.  Doing a batch of items doesn't solve...

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

    July 16, 2017 at 5:06 pm

    #1951074

  • RE: Using Queues

    mike 57299 - Saturday, July 15, 2017 4:39 PM

    if I have 30 items and agent runs every second - it will still...

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

    July 16, 2017 at 9:07 am

    #1951055

  • RE: Using Queues

    mike 57299 - Friday, July 14, 2017 4:48 PM

    I have searched for the last 4 hours looking for how to implement a...

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

    July 14, 2017 at 4:56 pm

    #1951018

  • RE: Sum when between

    danijel.bozic87 - Wednesday, July 12, 2017 10:07 PM

    TheSQLGuru - Wednesday, July 12, 2017 8:13 PM

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

    July 13, 2017 at 1:55 pm

    #1950839

  • RE: Query to check the tables part of procedures

    If you have dynamic SQL in play there is no way to know what tables were affected, at least with any certainty. A grep of the plan cache would get...

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

    July 12, 2017 at 8:18 pm

    #1950667

  • RE: Parameterless stored procedure to update insert

    If you are just doing one row operations just pass in the remote row values as parameters for the sproc. Then you can use MERGE if you wish. NOTE: MERGE...

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

    July 12, 2017 at 8:16 pm

    #1950666

  • RE: Sum when between

    Look up Itzik Ben-Gan Gaps and Islands TSQL to find a number of solutions to this classic problem.

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

    July 12, 2017 at 8:13 pm

    #1950665

Viewing 15 posts - 211 through 225 (of 5,841 total)