Forum Replies Created

Viewing 15 posts - 451 through 465 (of 5,841 total)

  • RE: Too many workers?

    First off: If you want something fixed "now" you really need to get someone on the phone

    to see what is connected/running the best thing I know of is...

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

    January 30, 2017 at 3:14 pm

    #1925743

  • RE: SQL Pivot Query

    Do a web search for dynamic pivot sql server for some options.

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

    January 30, 2017 at 12:33 pm

    #1925712

  • RE: Latency issues in Transactional Replication

    A) IIRC both secondary databases have their files on the same disk system, so latencies between files "should" be identical and thus not a factor here. Something to verify though.

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

    January 30, 2017 at 12:31 pm

    #1925711

  • RE: Table Valued Function with primary key and spatial index - is this possible?

    olibbhq - Monday, January 30, 2017 4:39 AM

    Good morning,

    I have tried to find documentation of it but have been unable to. Can...

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

    January 30, 2017 at 9:37 am

    #1925633

  • RE: Latency issues in Transactional Replication

    rogelio.vidaurri - Monday, January 30, 2017 7:14 AM

    Hi again,

    Something strange though, just with this new database's replication:

    instance A (active):
    database    replicated transactions    replication rate trans/sec    replication...

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

    January 30, 2017 at 9:06 am

    #1925622

  • RE: Point Stored Procs At Read-only Instance of AG Group

    Listener:

    ">https://msdn.microsoft.com/en-us/library/hh213417.aspx

    Do note that if you make a secondary database readable you will modify PRIMARY data structures to have a 14-byte version store pointer placed...

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

    January 25, 2017 at 9:48 am

    #1924905

  • RE: case when statement not displaying derived column data

    It REALLY helps us help you to provide a create table script, some INSERT statements for sample data and your expected outputs.

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

    January 20, 2017 at 6:21 pm

    #1924174

  • RE: Month and Year Columns

    Oh, perhaps you can cheat and add a persisted computed column to the table?!? 😀

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

    January 19, 2017 at 2:48 pm

    #1923885

  • RE: Month and Year Columns

    lkennedy76 - Thursday, January 19, 2017 2:34 PM

    I tried
    where [Year]=Year(GetDate())-1
    AND [Month]=Month(

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

    January 19, 2017 at 2:46 pm

    #1923882

  • RE: Month and Year Columns

    lkennedy76 - Thursday, January 19, 2017 1:14 PM

    drew.allen - Thursday, January 19, 2017 1:09 PM

    When...

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

    January 19, 2017 at 1:37 pm

    #1923853

  • RE: Latency issues in Transactional Replication

    not discarded yet
    however, we can ping now
    A -> B 72ms
    B -> A 72ms
    A -> C 1ms
    C -> A 1ms

    Didn't you say...

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

    January 18, 2017 at 6:01 pm

    #1923587

  • RE: Latency issues in Transactional Replication

    sjimmo - Wednesday, January 18, 2017 3:18 PM

    rogelio.vidaurri - Wednesday, January 18, 2017 1:30 PM

    "It...

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

    January 18, 2017 at 4:07 pm

    #1923571

  • RE: Latency issues in Transactional Replication

    rogelio.vidaurri - Wednesday, January 18, 2017 1:20 PM

    TheSQLGuru - Wednesday, January 18, 2017 11:46 AM

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

    January 18, 2017 at 2:04 pm

    #1923549

  • RE: Latency issues in Transactional Replication

    rogelio.vidaurri - Wednesday, January 18, 2017 9:10 AM

    both tables are exactly the same in constraints, keys, indexes, no triggers, etc.
    the only difference is...

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

    January 18, 2017 at 11:46 am

    #1923513

  • RE: Latency issues in Transactional Replication

    The number of rows in a replicated table isn't of importance from a replication performance perspective. It is how much DML activity occurs.

    Check the 2017 table for foreign...

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

    January 18, 2017 at 8:38 am

    #1923449

Viewing 15 posts - 451 through 465 (of 5,841 total)