Forum Replies Created

Viewing 15 posts - 4,801 through 4,815 (of 9,726 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (1/26/2012)


    Brandie Tarvin (1/26/2012)


    Dealer: Umm, about that tiny oil leak....

    I hate days like this.

    I've had that. It was followed by almost R10 000 repair bill for replacing the gaskets in...

    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.

  • RE: Are the posted questions getting worse?

    Well, that explains a few things.

    Humor for the day. I just gave a speech at our workplace communications club based on a blog post I did 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.

  • RE: Today's Random Word!

    Daniel Bowlin (1/26/2012)


    I am declaring a lyric day.

    "The cat's in the cradle and the silver spoon..."

    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.

  • RE: Stored proc help

    SQLKnowItAll (1/26/2012)


    Brandie Tarvin (1/26/2012)


    But there is no RETURN(@retval) after the SET statement, which means @retval will never OUTPUT a value (which is 0 if the backup was done correctly.)

    Maybe...

    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.

  • RE: Combining Simple Count Queries

    The UNION ALL won't help because it will take the name from the first SELECT as the column names.

    Jenni, please post Create Table scripts with INSERTS that contain dummy data....

    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.

  • RE: database design for fee registration system

    Can I just add a note. Never, ever, design a database based off what the queries will be. Queries change. They get added, they get removed, they get entirely redesigned....

    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.

  • RE: Notify Operator Task - Unable to set "Notification Message Subject"

    Surely you can charge it to another department's cost center? @=)

    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.

  • RE: Stored proc help

    gmamata7 (1/25/2012)


    Hi Tarvin,

    Ah, good ol' Litespeed. Was this is a script generated by the Litespeed console?

    What exactly are you trying to accomplish with the OUTPUT variable?

    I have an existing...

    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.

  • RE: query database for different packages for same employee

    Please be more specific about what you've tried. Show us the code where you added another column and it didn't work. Post the error that occurred. Give us an INSERT...

    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.

  • RE: Are the posted questions getting worse?

    SQL Kiwi (1/25/2012)


    Brandie Tarvin (1/25/2012)


    Anyone can fly. You just throw yourself at the ground and miss.

    Been reading Douglas Adams recently, Brandie?

    Hee. I was wondering how long it would take 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.

  • RE: Are the posted questions getting worse?

    Roy Ernest (1/25/2012)


    Brandie Tarvin (1/25/2012)


    I wish I could attend all the international SQL Saturdays. That would be so much fun.

    I have been thinking about testing remote presentation at some U.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.

  • RE: Are the posted questions getting worse?

    I wish I could attend all the international SQL Saturdays. That would be so much fun.

    I have been thinking about testing remote presentation at some U.S. Saturday's though, and expanding...

    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.

  • RE: Table design bias to rows or columns

    I have to agree with Sean. Use # 1. First of all, it adheres to the rules of normalization, plus it takes advantage of the fact that you have access...

    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.

  • RE: How to output results from a "Execute T-SQL Statement Task" in a Maintenance Plan in SQL 2008

    Try putting the results into a table then reporting off the 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.

  • RE: query database for different packages for same employee

    Whenever you have an aggregate of any type in a UNION statement, verify that the datatype for that aggregate is the same in all sections of the UNION.

    0 AS [ADV_EFT]...

    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.

Viewing 15 posts - 4,801 through 4,815 (of 9,726 total)