Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    rodjkidd (12/17/2014)

    So with only 4 1/2 days of current contract I'm finally have fun trying to solve a problem.

    So nice little deadline there. Was a straightforward request but now that...

    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 17, 2014 at 9:23 am

    #1765218

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

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

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

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

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

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

    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 17, 2014 at 4:55 am

    #1765128

  • RE: Are the posted questions getting worse?

    That makes me feel somewhat better. Thanks, Koen.

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

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

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

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

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

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

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

    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, 2014 at 11:37 am

    #1764178

Viewing 15 posts - 3,001 through 3,015 (of 9,720 total)