Forum Replies Created

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

  • 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

  • RE: Are the posted questions getting worse?

    And in other tech news, the European Union is thinking about free wifi. Sorry UK Threadzians. You have been Brexited out of the plan.

    Plus, has Apple ruined the emoji?

    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 21, 2016 at 11:43 am

    #1902255

  • RE: Are the posted questions getting worse?

    jasona.work (9/21/2016)

    So a book I'm currently reading (highly recommend, I've actually laughed out loud because of what I'm about to tell you) has possibly the BEST explanation for why computer...

    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 21, 2016 at 11:42 am

    #1902254

  • RE: Are the posted questions getting worse?

    GilaMonster (9/20/2016)

    BrainDonor (9/20/2016)

    New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

    My favourite Friday shirt (not casual fridays, because every day is casual dress) is one that I got from the MS company...

    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 21, 2016 at 4:27 am

    #1902109

  • RE: Are the posted questions getting worse?

    TomThomson (9/20/2016)

    Phil Parkin (9/20/2016)

    BrainDonor (9/20/2016)

    New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

    But I don't know if I can - shouldn't the first full-stop be a comma? I think it would read...

    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 20, 2016 at 12:19 pm

    #1901986

  • RE: Are the posted questions getting worse?

    And here's your ranch error of the day for those who like farming, being a rancher, or cows.

    Beware the cows, for they are clever and will get even for all...

    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 20, 2016 at 5:47 am

    #1901826

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