Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    <headdesk>

    I don't know whether to cry about the problem or sing praise that someone finally got it.

    A dev has a ticket to improve a process he wrote. I got involved...

    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.

    October 26, 2016 at 4:23 am

    #1908832

  • RE: Are the posted questions getting worse?

    jasona.work (10/25/2016)

    So this ought to be fun...

    Dev asked me to take a look at a view that isn't performing as well as it did on the system it used 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.

    October 25, 2016 at 11:56 am

    #1908712

  • RE: Revenue Projections - View?

    This fits best in SSRS since you say it's an SSRS post.

    Everyone please respond to this link instead of here: http://www.sqlservercentral.com/Forums/Topic1828200-150-1.aspx

    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.

    October 25, 2016 at 11:11 am

    #1908697

  • RE: Are the posted questions getting worse?

    Luis Cazares (10/25/2016)

    Should I be concerned for this person's info?

    If by info you mean data, yes. But there's nothing any of us can do about 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.

    October 25, 2016 at 10:53 am

    #1908690

  • RE: Parameter on Powershell Script

    trangen1 (10/25/2016)

    what do you mean????? "The code below clears the Local Servers Group completely (be aware of this),"???

    can I run it without this clearing of the LSG????

    'dir -Recurse | Remove-Item...

    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.

    October 25, 2016 at 10:34 am

    #1908683

  • RE: sql backup

    EdVassie (10/25/2016)

    One thing I did not see explicitly mentioned is the number of backup files.

    I don't know if this is true of all dedup technology, but the stuff we use...

    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.

    October 25, 2016 at 6:05 am

    #1908570

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    My apologies Brandi - you're right - you did say that in your edit. However, you also just addressed constraining the columns entry when I asked a very...

    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.

    October 21, 2016 at 7:07 am

    #1907945

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    My thanks to all who responded, but please, in the future, read the question - I DID NOT say "Users are entering data", what I said was "We get...

    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.

    October 21, 2016 at 6:30 am

    #1907936

  • RE: Testing System DB backups

    Okay. Maybe it was the checks that screwed me up the last time I tried.

    Thanks for the verification. I appreciate 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.

    October 21, 2016 at 5:11 am

    #1907917

  • RE: Can I do this?

    HanShi (10/21/2016)

    Eric M Russell (10/20/2016)

    So, you're saying that the users are entering values that are considered invalid due to their excessive length? You can avoid this by implementing check constraints...

    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.

    October 21, 2016 at 4:23 am

    #1907898

  • RE: What is the right way to design a data flow between development and production dbs?

    lindsayscott23 (10/20/2016)

    That was actually part of my rationale for separating out into two databases. To reduce cross querying.

    Lins,

    I think you misunderstand what Grant meant by cross-database querying.

    If you separate out...

    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.

    October 20, 2016 at 9:03 am

    #1907686

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One 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.

    October 20, 2016 at 9:00 am

    #1907685

  • RE: Parameter on Powershell Script

    Luis Cazares (10/20/2016)

    mister.magoo (10/20/2016)

    I was wondering whether all this complexity is worth it...just to run a dtsx? But I'm not a DBA, so I assume this is a small part...

    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.

    October 20, 2016 at 8:57 am

    #1907683

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of 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.

    October 20, 2016 at 7:58 am

    #1907660

  • RE: Are the posted questions getting worse?

    jasona.work (10/20/2016)

    Brandie Tarvin (10/20/2016)

    On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused...

    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.

    October 20, 2016 at 6:55 am

    #1907629

Viewing 15 posts - 1,336 through 1,350 (of 9,720 total)