Forum Replies Created

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

  • RE: Are the posted questions getting worse?

    Sigh.

    Why oh why oh why do users not understand their own requirements? I've had to explain this one to the BA 3 times already and they're still trying...

    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 16, 2018 at 4:38 am

    #2009830

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

    I am doing a similar thing myself for a database and have discovered the joys of SQL Audit. Now that you've given us some sample code, I'm willing to share...

    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 16, 2018 at 4:05 am

    #2009824

  • RE: Are the posted questions getting worse?

    OMG. Is it snowing in Florida? Is that ice I see on the roads?

    I think I might actually LIKE a post from Mr. ANSI-Standards-Override-All!

    <thump>

    Someone,...

    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 16, 2018 at 4:01 am

    #2009823

  • RE: What's wrong with my table?

    Jeff Moden - Monday, October 15, 2018 12:19 PM

    It's official, folks.  The man is NOT an idiot.  Rather, he's quite clever, as 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 12:20 pm

    #2009692

  • RE: Query slow. Help improve?

    SQLStud 74876 - Monday, October 15, 2018 12:04 PM

    Jeff Moden - Saturday, October 13, 2018 10:25 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 12:19 pm

    #2009691

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 12:04 PM

    Brandie Tarvin - Monday, October 15, 2018 11:07 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 12:12 pm

    #2009687

  • RE: What's wrong with my table?

    SQLStud 74876 - Monday, October 15, 2018 11:53 AM

    Ahhh man!  You guys are a tough crowd!

    We are trying to help. If you...

    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 12:10 pm

    #2009686

  • RE: Are the posted questions getting worse?

    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 11:40 am

    #2009677

  • RE: Finding recent date from two tables

    Jonathan AC Roberts - Monday, October 15, 2018 11:25 AM

    Brandie Tarvin - Monday, October 15, 2018 11:15...

    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 11:31 am

    #2009675

  • RE: Finding recent date from two tables

    sgmunson - Monday, October 15, 2018 10:19 AM

    salamlemon - Wednesday, October 10, 2018 9:20 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 15, 2018 at 11:15 am

    #2009667

  • RE: Are the posted questions getting worse?

    Thom A - Monday, October 15, 2018 11:00 AM

    Brandie Tarvin - Monday, October 15, 2018 10: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 15, 2018 at 11:07 am

    #2009665

  • RE: Is this query correct ?

    Thom A - Monday, October 15, 2018 8:00 AM

    Jonathan AC Roberts - Monday, October 15, 2018 7:51...

    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 11:04 am

    #2009663

  • RE: Are the posted questions getting worse?

    So this slow query guy seems to not be answering up to any of his 3 threads. Is he really that busy or does he not like the answers we're...

    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:53 am

    #2009659

  • 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

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