Forum Replies Created

Viewing 15 posts - 16 through 30 (of 5,842 total)

  • RE: Huge table.and poor performance.

    I have run 500+ MILLION row (uncompressed) table queries on my LAPTOP, taking < 10 seconds each time.

    My experience says that indexing is not even close to...

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

    February 13, 2018 at 2:05 pm

    #1979652

  • RE: Log Shipping

    NewBornDBA2017 - Tuesday, February 13, 2018 9:53 AM

    I have couple of questions regarding Log Shipping. I have a DB on SQL Server...

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

    February 13, 2018 at 1:59 pm

    #1979651

  • RE: Query - Performance between dates

    Did you try the query with OPTION (RECOMPILE) at the end of it?

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

    February 12, 2018 at 10:52 pm

    #1979556

  • RE: Slow Query when perform INNER JOIN Between a very large partioned table and a non partitioned table

    karim.diouf - Friday, February 9, 2018 3:25 PM

    I have a very large - partitioned - table with about 50 millions records. Partition...

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

    February 10, 2018 at 6:41 am

    #1979342

  • RE: Anyone do Peer to Peer or Merge Replication bi-coastal with 4 tb database?

    1) I have had clients REMOVE replication (both forms) because of it, well, being problematic (or worse). Bi-directional data modification/synchronization is just about the hardest nut to crack in all...

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

    February 8, 2018 at 10:46 am

    #1979069

  • RE: SQL Server 2014 Meltdown / Spectre Patch - GDR Path

    ft55 - Thursday, February 8, 2018 7:02 AM

    As part of the mitigation process for the Meltdown and Spectre vulnerability we are looking...

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

    February 8, 2018 at 9:26 am

    #1979046

  • RE: Best replication solution for poor connectivity scenario

    S_Kumar_S - Wednesday, February 7, 2018 10:47 PM

    Hi All
    I am struggling to configure transnational replication between some retail stores and head quarter....

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

    February 8, 2018 at 9:22 am

    #1979044

  • RE: DB compression with San compression

    Thanks for the thoughts.

    The Koenigseggs are FAR more than pure art. There is some SPECTACTULAR engineering function behind their form!! 🙂

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

    February 7, 2018 at 8:21 pm

    #1978976

  • RE: Stored Procedure Help and dealing with Where Clause

    Dynamic SQL is how I would go (guarding against SQL Injection, obviously). That will allow you to remove the ORs completely because you will KNOW what was passed in because...

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

    February 7, 2018 at 10:28 am

    #1978931

  • RE: Trigger insert

    ScottPletcher - Wednesday, February 7, 2018 7:56 AM

    TheSQLGuru - Tuesday, February 6, 2018 3:55 PM

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

    February 7, 2018 at 10:24 am

    #1978929

  • RE: TDE and Logshipping

    PearlJammer1 - Wednesday, February 7, 2018 5:29 AM

    Hi
    We already have an established Log Shipping environment.The secondary has the databases in the 'Non...

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

    February 7, 2018 at 5:56 am

    #1978844

  • RE: DB compression with San compression

    Jason A. Long - Tuesday, February 6, 2018 4:55 PM

    TheSQLGuru - Tuesday, February 6, 2018 3:56 PM

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

    February 7, 2018 at 4:36 am

    #1978827

  • RE: DB compression with San compression

    Jason A. Long - Tuesday, February 6, 2018 1:44 PM

    When we moved to a Pure Storage SAN, one of their boastful claims...

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

    February 6, 2018 at 3:56 pm

    #1978802

  • RE: Trigger insert

    Ahh, an extra de-reference. Works for me.

    I never expect compression to be available though because the vast majority of SQL Server instances are not Enterprise Edition (or 2016SP1+,...

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

    February 6, 2018 at 3:55 pm

    #1978801

  • RE: Trigger insert

    ScottPletcher - Tuesday, February 6, 2018 10:03 AM

    Fascinating.  You recommend a very inefficient method then say what a great tuner you...

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

    February 6, 2018 at 1:15 pm

    #1978769

Viewing 15 posts - 16 through 30 (of 5,842 total)