Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    Tom.Thomson (2/1/2011)


    Trey Staker (2/1/2011)


    Brandie Tarvin (2/1/2011)


    Never fear, Threadzians. Apparently people are working to keep the internet from being blocked by politicos. See this Yahoo! News item for more details.

    That's cool...

    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?

    Never fear, Threadzians. Apparently people are working to keep the internet from being blocked by politicos. See this Yahoo! News item for more details.

    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: UPDATE using a self-join

    GSquared (2/1/2011)


    Stefan Krzywicki (2/1/2011)


    Brandie Tarvin (2/1/2011)


    CELKO (1/31/2011)


    Successful projects start on lesser SQLs (even ACCESS ) then have to move to DB2, Oracle, Teradata or whatever.

    Including Access? What other lesser SQLs...

    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: UPDATE using a self-join

    CELKO (1/31/2011)


    Actually, INSERT and UPDATE are single table operations, while MERGE requires a source and target.

    I haven't moved up to SQL 2k8 yet, so haven't had a chance 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.

  • RE: Today's Random Word!

    Tom.Thomson (2/1/2011)


    Peter Trast (1/31/2011)


    Brandie Tarvin (1/31/2011)


    WOTD: Tea

    "A drink with jam and bread"

    Dough

    "And that brings us back 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.

  • RE: Are you a "hunt and pecker" or a "typist"?

    Typist. 99 WPM. And yes, those touch screens drive me nuts. Can't feel the key boundaries and there's not enough space between virtual keys for me to hit the correct...

    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: I cannot understand these codes

    Craig, you've got me confused now. What part of that equation changes the days from the 1st to the 3rd?

    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?

    GilaMonster (1/31/2011)


    Brandie Tarvin (1/31/2011)


    If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were you?

    He was pretty diplomatic about it. Far more diplomatic...

    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?

    If the poster said that, I don't blame you for slapping down. The question is, how diplomatic were 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.

  • RE: reset sa password

    GilaMonster (1/31/2011)


    Brandie Tarvin (1/31/2011)


    Box Admin and SQL Server admin are not the same thing.

    They are if SQL is running in single user mode. Challenge appears to be to find what...

    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?

    Koen (da-zero) (1/31/2011)


    Brandie Tarvin (1/31/2011)


    Koen (da-zero) (1/31/2011)


    Does anyone else have problems surfing the site?

    I can browse through the forums, but if I want to go to the home page, 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.

  • RE: reset sa password

    sql2k8 (1/30/2011)


    I don't have any other sysadmin account, i am an administrator on the machine . i am not sysadmin. I don't have any other accounts with sysadmin priviliges.I 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.

  • RE: 'Pretty-up' the code

    Common table expressions (CTEs) are a bit of advanced coding. They work wonderfully well for recursive querying and sometimes for normal querying. Definitely play with them, but don't stress if...

    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: I cannot understand these codes

    npatel.bi (1/30/2011)


    StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))

    EndDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -3, +1))

    ReportDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date)-2, +1))

    This query gives the data 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.

  • RE: Permission to Kill Sleeping Job

    I find myself asking the same question as Craig. Why would you want to do this? What problem are you having that you needed to develop this job?

    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 - 6,646 through 6,660 (of 9,725 total)