Forum Replies Created

Viewing 15 posts - 2,986 through 3,000 (of 9,703 total)

  • RE: Designing a "Web" dashboard to monitor SQL Server Jobs

    David Burrows (12/17/2014)


    Not sure if there is specific articles that would give you a complete solution but my answer for this would be

    A repeater control populated with a datasource containing...

  • RE: Are the posted questions getting worse?

    BTW, can anyone with Visual Studio coding experience take a look at my question here?

    I've been fighting this on and off for several months now and just can't seem to...

  • RE: Are the posted questions getting worse?

    That makes me feel somewhat better. Thanks, Koen.

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/16/2014)


    WHOO! #HappySnoopyDance

    I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

    Current execution...

  • RE: Are the posted questions getting worse?

    WHOO! #HappySnoopyDance

    I just spent 2 & 1/2 days reworking a package and its supporting tables / stored procedures. Previous time of execution between 8 - 12 hours.

    Current execution time ......

  • RE: Database connection permissions

    ramana3327 (12/13/2014)


    We created a seperate login. And gave db_owner permissions for the remaining databases. But my doubt is about the server level permission.

    We are assigned public server role to that...

  • RE: Database connection permissions

    ramana3327 (12/11/2014)


    SA account is already disabled. so I need to give public server role and map as dbowner for remaining databases right?

    Yes. That will prevent them from accessing server level...

  • RE: Drive Spaces - Database size

    ScottPletcher (12/11/2014)


    Don't forget the other side of the issue.

    Have you compressed large indexes when useful?

    Have you reviewed that you have the best clustered index on each table? After that,...

  • RE: Database connection permissions

    Brandie Tarvin (12/11/2014)


    ramana3327 (12/10/2014)


    Hi,

    We have a login with windows authentication. That login has sysadmin and public server roles. But We didn't map that login to some user databases.

    There is your...

  • RE: Drive Spaces - Database size

    If you are sure that your growth rate holds steady at 70 GB per month, then take that number multiplied by the number of months you're projecting. Add that to...

  • RE: Drive Spaces - Database size

    So again, what are you trying to accomplish?

    Without that context, your original question is rather meaningless to the rest of us.

  • RE: Prevent creating records if certain other records already exist

    As much as it pains me to say this (because it could cause performance issues), I think your best bet is to put in an AFTER trigger to rollback the...

  • RE: Database Specific Access

    I've never actually disabled any login except the sa and guest (old days) logins. And so far as I know, that's a server-level setting only. I'm pretty sure that once...

  • RE: Database Specific Access

    I think you are correct. I would advise creating a server level public login to go with that DB login, though, for ease of maintenance and to prevent it from...

  • RE: Drive Spaces - Database size

    GilaMonster (12/11/2014)


    Depends how often you want to add space to your drives.

    There's no need to have free space on the drive, as long as there's free space in the database...

Viewing 15 posts - 2,986 through 3,000 (of 9,703 total)