Forum Replies Created

Viewing 15 posts - 1,321 through 1,335 (of 9,702 total)

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

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

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

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

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

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

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

  • 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,...

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

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

    lindsayscott23 (10/20/2016)


    ...our workflow goes like this:

    Build in Dev

    Unit Test in Dev (this is done by the developers)

    Add to appropriate folder in TFS (we have monthly releases and each release folder...

  • RE: sql backup

    Jeff Moden (10/19/2016)


    Steve Jones - SSC Editor (10/19/2016)


    Jeff Moden (10/18/2016)


    Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to...

  • RE: Parameter on Powershell Script

    Luis Cazares (10/19/2016)


    Brandie Tarvin (10/19/2016)


    Have you tried renaming the folders to use underlines instead of hyphens?

    I think the hyphens are the problem. That powershell might see them literally as a...

  • RE: Are the posted questions getting worse?

    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 the log files...

  • RE: Are the posted questions getting worse?

    Gazareth (10/19/2016)


    Gazareth (10/19/2016)


    Eirikur Eiriksson (10/18/2016)


    Just had a Blast from the past

    😎

    First line: "Version 4.2 also lets you nest triggers"

    I didn't get any further due to blacking out; came to 10...

  • RE: With recompile in the master stored proc

    river1 (10/18/2016)


    Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I...

Viewing 15 posts - 1,321 through 1,335 (of 9,702 total)