Forum Replies Created

Viewing 15 posts - 1,441 through 1,455 (of 9,720 total)

  • RE: Cleaning up "rotten" tables - need help with code

    Jeff Moden (9/22/2016)

    I'd be in deep Kimchie if I deleted some of my empty tables because they're used to prop up some very necessary "Instead of" triggers on a View...

    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.

    September 27, 2016 at 4:59 am

    #1903285

  • RE: Looking to update old code

    I'll keep this all in mind. Thanks, everyone.

    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.

    September 27, 2016 at 4:55 am

    #1903284

  • RE: Are the posted questions getting worse?

    HELLO! This is my new "must have".

    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.

    September 26, 2016 at 7:17 am

    #1903076

  • RE: Are the posted questions getting worse?

    TomThomson (9/24/2016)

    Jeff Moden (9/23/2016)

    Luis Cazares (9/23/2016)

    Someone needs a course on how to write basic DML. Or maybe I'm just grumpy this week.

    No... you're not grumpy. As a matter of...

    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.

    September 26, 2016 at 7:16 am

    #1903075

  • RE: Looking to update old code

    Eric M Russell (9/23/2016)

    Brandie Tarvin (9/22/2016)

    Eric M Russell (9/16/2016)

    If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other...

    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.

    September 23, 2016 at 12:28 pm

    #1902895

  • RE: Looking to update old code

    The Dixie Flatline (9/22/2016)

    Brandie Tarvin (9/22/2016)

    The Dixie Flatline (9/15/2016)

    If some of your joins are to tables that simply provide descriptions, I'm a big fan of converting those joins to inline...

    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.

    September 23, 2016 at 11:36 am

    #1902878

  • RE: Are the posted questions getting worse?

    YIKES! Not only is Microsoft changing the patching for Win 7 & 8.1, but hackers have gotten to the White House.

    And we're having mini-meltdowns at work where everyone is...

    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.

    September 23, 2016 at 10:40 am

    #1902857

  • RE: Cleaning up "rotten" tables - need help with code

    Phil Parkin (9/22/2016)

    Brandie Tarvin (9/22/2016)

    Thanks, guys. But you're all missing the point of my question.

    I withdraw it since no one understands what I'm asking for.

    Yep, I am totally puzzled...

    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.

    September 22, 2016 at 10:39 am

    #1902547

  • RE: Cleaning up "rotten" tables - need help with code

    mister.magoo (9/22/2016)

    I would:

    Change the process so it doesn't generate empty tables.

    Yeah, already doing that.

    Open Object Explorer Details, right click column headers and include "Row Count" in the display

    Sort list by...

    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.

    September 22, 2016 at 9:59 am

    #1902525

  • RE: Cleaning up "rotten" tables - need help with code

    Thanks, guys. But you're all missing the point of my question.

    I withdraw it since no one understands what I'm asking for.

    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.

    September 22, 2016 at 9:58 am

    #1902522

  • RE: Cleaning up "rotten" tables - need help with code

    Phil Parkin (9/22/2016)

    I'd write a query to identify (only) the empty tables. Add a column to the query which returns the 'DROP TABLE ...' statement, for the selected table.

    Execute the...

    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.

    September 22, 2016 at 7:32 am

    #1902458

  • RE: SQL Agent Job Shows Running for Days, but Not Really Running

    jerry-621596 (9/15/2016)

    I tried your script and get and error saying the request to stop the job was refused because the job is not currently running.

    Seems like the mystery runs deeper...

    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.

    September 22, 2016 at 6:35 am

    #1902437

  • RE: Looking to update old code

    Eric M Russell (9/16/2016)

    If this is something like a data warehouse, where you have very large tables that are sourced for reporting purposes from other transactional databases, then consider more...

    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.

    September 22, 2016 at 6:33 am

    #1902436

  • RE: Looking to update old code

    The Dixie Flatline (9/15/2016)

    Also, get rid of scalar functions in queries wherever possible. Inline table valued functions perform wayyy better.

    Hmmm. Not really using scalar functions. Using a...

    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.

    September 22, 2016 at 6:31 am

    #1902433

  • RE: Looking to update old code

    The Dixie Flatline (9/15/2016)

    If some of your joins are to tables that simply provide descriptions, I'm a big fan of converting those joins to inline table-valued functions. ...

    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.

    September 22, 2016 at 6:28 am

    #1902431

Viewing 15 posts - 1,441 through 1,455 (of 9,720 total)