Forum Replies Created

Viewing 15 posts - 316 through 330 (of 9,720 total)

  • Reply To: Finding specific file with dynamic date

    Well, I feel kind of silly. I have spent 2 weeks trying to figure this out before I finally posted here. Then after posting, went back to searching and finally...

    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.

    March 3, 2020 at 3:07 pm

    #3730581

  • Reply To: Calculating totals based on a column flag

    Why are you doing the ISNULL() check?  The SUM() will eliminate NULL values automatically.  Are you trying to eliminate the warning?

    SUM() has NEVER eliminated NULL values automatically for me. It...

    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.

    January 17, 2020 at 12:17 pm

    #3716267

  • Reply To: Calculating totals based on a column flag

    ScottPletcher wrote:

    I posted a simplified query if you don't need to list/modify the individual values.  To just subtract out the excluded values, you don't really need the CROSS APPLY:

    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.

    January 16, 2020 at 6:34 pm

    #3716080

  • Reply To: Calculating totals based on a column flag

    The ABS(CAST(BE.Buck1 AS tinyint) - 1) doesn't work for me. It is zeroing out the flag that tells me whether or not to include the bucket.

    Here's what I've come up...

    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.

    January 16, 2020 at 11:51 am

    #3715936

  • Reply To: Calculating totals based on a column flag

    Assumption #1, I do have a join table that I'm working off of and forgot to include.

    Assumption #2, I can't (and don't want to) zero out the individual buckets. 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.

    January 14, 2020 at 9:45 pm

    #3715435

  • Reply To: Uninstall SQL without uninstalling SSRS

    crow1969 wrote:

    Heh.  I think you trust me more than my boss does 😉

    Well the more I thought about it after I posted, the more I realized that if SSRS can...

    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.

    December 11, 2019 at 3:09 pm

    #3707001

  • Reply To: Migrating DB encrypted by master key

    I did not know about the encryption algorithm changing.

    This might mean the need to unencrypt the database before moving it and then re-encrypting it after the move.

    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.

    December 11, 2019 at 1:25 pm

    #3706913

  • Reply To: Uninstall SQL without uninstalling SSRS

    You don't have to test. I trust that two people telling me this is possible means it's probably possible.

    Thank you both for your answers.

    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.

    December 11, 2019 at 10:57 am

    #3706852

  • Reply To: Uninstall SQL without uninstalling SSRS

    Those databases actually live on one of our database servers. When we initially did the install (this was one of the first 2012 servers we stood up), we thought they...

    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.

    December 10, 2019 at 5:40 pm

    #3706599

  • Reply To: Are the posted questions getting worse?

    Thom A wrote:

    Not sure how well I'd get along with home working, and not sure how well it would do with my whooping 10Mbps down and 1 Mbps up internet.

    As 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.

    December 10, 2019 at 3:55 pm

    #3706556

  • Reply To: Migrating DB encrypted by master key

    So this is a side-by-side upgrade instead of an in-place (direct upgrade of current instance)?

    Just verifying before I try to answer the question.

    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.

    December 10, 2019 at 11:21 am

    #3706422

  • Reply To: Are the posted questions getting worse?

    Because we are always looking and Allstate does let tech employees work from home (subject to certain caveats, depending on the division)… Careers @ Allstate.

     

    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.

    December 10, 2019 at 10:31 am

    #3706407

  • Reply To: SQL Server Native Auditing question

    Thanks, Grant.

    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.

    November 27, 2019 at 3:09 pm

    #3701570

  • Reply To: Oops, I deleted that data

    MVDBA (Mike Vessey) wrote:

    Brandie Tarvin wrote:

    We don't ever allow our Devs access to Production. What we do for them, however, is create a "production copy" database on a daily basis down to 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.

    November 4, 2019 at 11:42 am

    #3694274

  • Reply To: Oops, I deleted that data

    jermitts 57867 wrote:

    Developers could certainly have read access to production data. If a production change needs to occur to data for whatever reason, the production change should be done by an...

    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.

    November 4, 2019 at 10:35 am

    #3694229

    • Viewing 15 posts - 316 through 330 (of 9,720 total)