Forum Replies Created

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

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

    Jeff Moden (12/17/2014)

    Brandie Tarvin (12/17/2014)

    So I have it in my head to design a webpage that my team can pull up at month end and, at a glance, tell what...

    December 17, 2014 at 7:42 am

    #1765187

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

    David Burrows (12/17/2014)

    p.s. sorry if this seems to be teaching the obvious but I do not know what level you want the answer to be.

    My major issue is that I'm...

    December 17, 2014 at 7:42 am

    #1765186

  • RE: Are the posted questions getting worse?

    WayneS (12/17/2014)

    Jeff Moden (12/17/2014)

    Koen Verbeeck (12/17/2014)

    Brandie Tarvin (12/17/2014)

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

    December 17, 2014 at 7:21 am

    #1765176

  • RE: Are the posted questions getting worse?

    Divine Flame (12/17/2014)

    Lynn Pettis (12/17/2014)

    ... Mark one off, 73 days on the calendar to go. 73 days on the calendar to go, 73 days to go, ...

    What is the big...

    December 17, 2014 at 6:37 am

    #1765158

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

    December 17, 2014 at 5:34 am

    #1765138

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

    December 17, 2014 at 4:55 am

    #1765128

  • RE: Are the posted questions getting worse?

    That makes me feel somewhat better. Thanks, Koen.

    December 17, 2014 at 4:47 am

    #1765126

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

    December 17, 2014 at 4:42 am

    #1765122

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

    December 16, 2014 at 12:13 pm

    #1765005

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

    December 15, 2014 at 6:02 am

    #1764702

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

    December 12, 2014 at 5:20 am

    #1764361

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

    December 12, 2014 at 5:19 am

    #1764360

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

    December 11, 2014 at 1:02 pm

    #1764203

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

    December 11, 2014 at 11:37 am

    #1764178

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

    December 11, 2014 at 10:40 am

    #1764160

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