Forum Replies Created

Viewing 15 posts - 1,801 through 1,815 (of 9,715 total)

  • RE: Values not adding up correctly when rolling up

    mbraman (4/28/2016)


    I apologize - it's been very difficult to explain. No need to reply anymore.

    I hope you're not giving up because of what I said. The intent was not...

    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 (4/29/2016)


    GilaMonster (4/27/2016)


    BLOB_EATER (4/27/2016)


    GilaMonster (4/26/2016)


    BLOB_EATER (4/26/2016)


    GilaMonster (4/26/2016)


    SQLRNNR (4/26/2016)


    The sith lord is Supreme Leader Snoke and suspected to be Darth Plagueis (the one that can create life from death according 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: Values not adding up correctly when rolling up

    mbraman (4/28/2016)


    So the total is 700 not 1400.

    The data flow is - data in sql server goes to tabular model to tableau.

    The "Field..." are filters in table.

    So 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?

    MSDN article on scripting variables with SQLCMD: https://msdn.microsoft.com/en-us/library/ms188714.aspx

    Dave Pinal's thoughts[/url] on the subject.

    DBA Stack Exchange http://dba.stackexchange.com/questions/13860/how-to-pass-in-parameters-to-a-sql-server-script-called-with-sqlcmd

    So, if I understand this correctly, you can use the SQLCMD code to pull 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.

  • RE: Are the posted questions getting worse?

    Grant Fritchey (4/28/2016)


    Brandie Tarvin (4/28/2016)


    Grant Fritchey (4/28/2016)[/b]


    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need 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 the posted questions getting worse?

    Grant Fritchey (4/28/2016)[/b]


    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

    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?

    Grant Fritchey (4/28/2016)


    Brandie Tarvin (4/28/2016)


    Grant Fritchey (4/28/2016)


    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need 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 the posted questions getting worse?

    Grant Fritchey (4/28/2016)


    Technical question:

    I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able to script...

    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?

    TomThomson (4/26/2016)


    Steve Jones - SSC Editor (4/26/2016)


    See you there, and...

    you have a car? I thought everyone in the UK just used trains.

    Trains? UK rail fares are by far 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.

  • RE: db_backupoperator can't back up database

    Jacob Wilkins (4/26/2016)


    That DENY didn't show up in the results of the query I posted earlier?

    It should have, so I'm curious why it didn't.

    I just remembered. There was so...

    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: db_backupoperator can't back up database

    Steve Jones - SSC Editor (4/26/2016)


    wow, deny to public. That would have been low, low on my list.

    Good catch, Brandie.

    I hate anyone that adds any permissions to public. Please, please,...

    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: db_backupoperator can't back up database

    Jacob Wilkins (4/26/2016)


    That DENY didn't show up in the results of the query I posted earlier?

    It should have, so I'm curious why it didn't.

    Cheers!

    No, it did not, actually. Weird...

    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: db_backupoperator can't back up database

    Thank 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: Are the posted questions getting worse?

    yb751 (4/26/2016)


    Speaking of Kylo throwing a tantrum...

    https://youtu.be/s74breoNAKc

    Best Kylo Ren Twitter account ever.

    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: db_backupoperator can't back up database

    Lynn Pettis (4/26/2016)


    Brandie Tarvin (4/26/2016)


    [headdesk]

    Seriously. SERIOUSLY?

    Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this...

    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 - 1,801 through 1,815 (of 9,715 total)