Forum Replies Created

Viewing 15 posts - 541 through 555 (of 9,715 total)

  • RE: Log shipping restore

    Another option to consider is a secondary availability group database. Assuming the instance is clustered, you can set up an AG and it'll always move the transactions without needing to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 10:46 am

    #2009658

  • RE: Talking about SARG

    Well, I'm going to start with Lowell's solution first, on account of these staging tables being wide and long. See how that works. Then maybe later I'll try the self-outer...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 10:32 am

    #2009656

  • RE: Talking about SARG

    Thom A - Monday, October 15, 2018 10:01 AM

    Like, Lowell, though, if i'm looking for a specific insurer, I use an OR,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 10:08 am

    #2009649

  • RE: Talking about SARG

    Lowell - Monday, October 15, 2018 9:29 AM

    Brandie I've always done something like this to keep it Sarg-able; does that help? it's...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 10:02 am

    #2009647

  • RE: Talking about SARG

    ScottPletcher - Monday, October 15, 2018 9:36 AM

    Never use ISNULL() in a JOIN (or WHERE) is a good rule.

    To avoid issues with NULL,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 10:01 am

    #2009646

  • RE: Object Explorer keeps "drifting"

    jasona.work - Monday, October 15, 2018 9:01 AM

    Brandie Tarvin - Monday, October 15, 2018 8:09 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 9:07 am

    #2009629

  • RE: SQL server Audit Trigger for INSERT , UPDATE , DELETE

    SQL learner22 - Thursday, October 11, 2018 10:22 AM


    Hi SQL Central Colleagues, 
    I was as asked to create  DDL trigger...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 9:00 am

    #2009626

  • RE: badly perfoming query when IS NOT NULL used in the WHERE clause

    ChrisM@Work - Monday, October 15, 2018 6:43 AM

    solus - Monday, October 15, 2018 6:12 AM

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 8:59 am

    #2009625

  • RE: What's wrong with my table?

    SQLStud 74876 - Friday, October 12, 2018 5:24 PM

    Some guy at the company I'm creating a database for tells me my table...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 8:56 am

    #2009624

  • RE: Object Explorer keeps "drifting"

    Grant Fritchey - Monday, October 15, 2018 7:33 AM

    Haunted mouse for Halloween. Seems appropriate.

    HA! I didn't even think about that.

    Now if I...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 8:09 am

    #2009619

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 5:55 AM

    A day never passes by when user stupidly doesn't amaze me. Playing a little...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 6:06 am

    #2009575

  • RE: Are the posted questions getting worse?

    ChrisM@Work - Monday, October 15, 2018 1:36 AM

    There was a still a fair amount of damage (fences down, missing roofs) visible from...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 5:41 am

    #2009568

  • RE: Running SSIS Package in scheduled job

    sindhupavani123 - Monday, October 15, 2018 4:53 AM

    Hi ,

    Haven't used SSIS Package as I still had issues , selected TSQL in SQL...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 5:03 am

    #2009565

  • RE: Running SSIS Package in scheduled job

    sindhupavani123 - Monday, October 15, 2018 4:38 AM

    Many thanks for all information.

    I still have problems doing this.

    I have created stored procedure and...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 4:43 am

    #2009558

  • RE: Object Explorer keeps "drifting"

    Nevermind. I realized it was happening in IE 11 also, so did a little googling that didn't include the words "SQL Server."

    Apparently my Bluetooth mouse (even though...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    October 15, 2018 at 4:18 am

    #2009549

Viewing 15 posts - 541 through 555 (of 9,715 total)