Forum Replies Created

Viewing 15 posts - 556 through 570 (of 9,728 total)

  • 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

  • RE: Are the posted questions getting worse?

    frederico_fonseca - Saturday, October 13, 2018 6:10 PM

    jasona.work - Friday, October 12, 2018 12:03 PM

    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 14, 2018 at 5:01 am

    #2009504

  • RE: Anyone see a problem with this?

    Matt Miller (4) - Saturday, October 13, 2018 10:23 AM

    DesNorton - Saturday, October 13, 2018 5:53 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 13, 2018 at 12:55 pm

    #2009500

Viewing 15 posts - 556 through 570 (of 9,728 total)