Forum Replies Created

Viewing 15 posts - 166 through 180 (of 5,841 total)

  • RE: Finding Consecutive Values For a Record

    I sure hope someone can do some benchmarking on these!! :Whistling:

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

    August 30, 2017 at 6:00 pm

    #1957576

  • RE: Finding Consecutive Values For a Record

    Luis Cazares - Wednesday, August 30, 2017 1:00 PM

    drew.allen - Wednesday, August 30, 2017 12:16 PM

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

    August 30, 2017 at 1:44 pm

    #1957547

  • RE: AVG Disk Transfer goes out of scale randomly

    Numerous things can result in a huge bottleneck on a disk. They include:
    Antivirus, backups, snapshot access, controller (or other shared IO component) congestion due to non-problematic-disk load, driver/firmware bug...

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

    August 30, 2017 at 10:48 am

    #1957515

  • RE: Finding Consecutive Values For a Record

    Odd, but not the oddest thing I have come across when linked servers were involved! :w00t:

    There are a variety of ways you can make that query run on...

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

    August 28, 2017 at 5:10 pm

    #1957167

  • RE: Finding Consecutive Values For a Record

    A very fast but hard-coded way would be to use CASE, similar to this pseudo-code. It should work due to short-cutting in the CASE execution:

    CASE WHEN...

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

    August 28, 2017 at 9:15 am

    #1957108

  • RE: AVG Disk Transfer goes out of scale randomly

    A) So you are running  SQL Server database on a single rotating disk? May I suggest you start there as the root cause of your problems? 🙂 And are all...

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

    August 28, 2017 at 9:09 am

    #1957106

  • RE: What kind of technology should i use?

    Chris Harshman - Thursday, August 24, 2017 6:49 AM

    I thought mirroring was deprecated in SQL Server 2012... even though it still seems...

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

    August 24, 2017 at 12:07 pm

    #1956696

  • RE: What kind of technology should i use?

    Adding a witness server to database mirroring is FAR LESS risky, difficult, problematic, BUGGY, etc., etc. than a Failover Cluster Instance and Always On Availability Group. 

    Anyway, best of...

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

    August 23, 2017 at 7:43 pm

    #1956534

  • RE: What kind of technology should i use?

    miguelv06 - Wednesday, August 23, 2017 9:59 AM

    TheSQLGuru - Wednesday, August 23, 2017 9:45 AM

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

    August 23, 2017 at 2:12 pm

    #1956494

  • RE: What kind of technology should i use?

    miguelv06 - Wednesday, August 23, 2017 9:30 AM

    On the test i have done mirroring takes 2-3 seconds... But i can live with...

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

    August 23, 2017 at 9:45 am

    #1956430

  • RE: Using The SQL Server Debugger

    Jeff Moden - Tuesday, August 22, 2017 9:29 AM

    TheSQLGuru - Tuesday, August 22, 2017 7:35 AM

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

    August 22, 2017 at 9:44 pm

    #1956275

  • RE: Reindex maintenance plan error

    Ola.hallengren.com is my go-to solution for MX.

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

    August 22, 2017 at 9:43 pm

    #1956273

  • RE: Append variable to query

    OOPSIE!! Coffee clearly hasn't kicked in yet! 🙂

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

    August 22, 2017 at 7:47 am

    #1956161

  • RE: Using The SQL Server Debugger

    IMHO the SQL Server debugger is essentially useless. Which is a damn shame...

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

    August 22, 2017 at 7:35 am

    #1956158

  • RE: Query optimization - Select Into .. Alter Table ADD CONSTRAINT PRIMARY KEY ([ID] ASC)

    Also, did you do any analysis while the code was running for that 1 hour? What if someone had a lock on a table and you simply waited for THAT...

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

    August 22, 2017 at 7:34 am

    #1956157

Viewing 15 posts - 166 through 180 (of 5,841 total)