Forum Replies Created

Viewing 15 posts - 226 through 240 (of 5,841 total)

  • RE: Help with query

    schleep - Wednesday, July 12, 2017 11:21 AM

    Sorry, was -- and am  -- out to lunch :Whistling:

    Precisely!

    But thinking on it over...

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

    July 12, 2017 at 12:42 pm

    #1950618

  • RE: Help with query

    I have annotated the expected results to try to understand better. Am I on the right track? One thing that still gets me is that it (almost) seems like order...

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

    July 12, 2017 at 10:43 am

    #1950594

  • RE: Help with query

    John Mitchell-245523 - Wednesday, July 12, 2017 10:23 AM

    I think he wants all combinations of one word from each group of synonyms....

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

    July 12, 2017 at 10:28 am

    #1950591

  • RE: Help with query

    I'm, sorry, but I can't for the life of me figure out what you need here. I'll blame it on percocet. 🙂

    1) You have a groupid field that...

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

    July 12, 2017 at 9:54 am

    #1950580

  • RE: Memory Needed More

    Sadly I am just overwhelmed and can't dig into this as much as I would like. I did slap together a quick demo and verified that the backup was the...

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

    July 10, 2017 at 9:13 pm

    #1950286

  • RE: Memory Needed More

    Sue_H - Monday, July 10, 2017 2:41 PM

    TheSQLGuru - Monday, July 10, 2017 1:32 PM

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

    July 10, 2017 at 2:57 pm

    #1950265

  • RE: Memory Needed More

    Rechana Rajan - Monday, July 10, 2017 12:16 AM

    We have server with 16 core 64GB RAM in Active\Passive Cluster,out of which 56GB...

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

    July 10, 2017 at 1:32 pm

    #1950242

  • RE: Trigger for Auditing

    I don't like the unnecessary TOP 1 1 you have in your code, although fortunately the optimizer has been coded to ignore it and do the same thing as a...

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

    July 10, 2017 at 1:28 pm

    #1950240

  • RE: Splitting TempDB

    Mike Scalise - Thursday, July 6, 2017 5:28 AM

    I guess I'm not understanding the comment(s) about why to use sockets instead of...

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

    July 6, 2017 at 3:04 pm

    #1949828

  • RE: Simple/Easy Way To Test Stored Procedures And Functions

    tSQLt.org

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

    July 6, 2017 at 3:01 pm

    #1949826

  • RE: Case statement - Count When

    danijel.bozic87 - Tuesday, July 4, 2017 10:02 PM

    Hi
    I am trying to add in the case statement below 
    if sn_status <> 'COMP' and...

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

    July 5, 2017 at 7:25 am

    #1949468

  • RE: Trigger for Auditing

    Jeff Moden - Wednesday, July 5, 2017 6:46 AM

    Talib123 - Wednesday, July 5, 2017 4:41 AM

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

    July 5, 2017 at 7:23 am

    #1949465

  • RE: Cross Apply Timing Out on Large (1bn rows) Table

    Jacob Wilkins - Tuesday, July 4, 2017 10:14 AM

    TheSQLGuru - Tuesday, July 4, 2017 10:02 AM

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

    July 4, 2017 at 1:42 pm

    #1949370

  • RE: Reasons to have Mirroring AND local backups?

    JaybeeSQL - Tuesday, July 4, 2017 9:50 AM

    TheSQLGuru - Tuesday, July 4, 2017 8:59 AM

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

    July 4, 2017 at 10:13 am

    #1949349

  • RE: Cross Apply Timing Out on Large (1bn rows) Table

    Almost certainly a view in play indeed Smile

    Cheers!

    I travel a quite a lot for client visits and especially to present at conferences. So I tell you what Jacob:...

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

    July 4, 2017 at 10:02 am

    #1949347

Viewing 15 posts - 226 through 240 (of 5,841 total)