Forum Replies Created

Viewing 15 posts - 8,041 through 8,055 (of 9,715 total)

  • RE: sql server.exe

    Rectify it? Why? Is it actually causing you a problem?

    If so, please describe the problems it's causing. If you're just concerned because you've seen it increase memory utilization and you...

    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.

    April 29, 2010 at 6:17 am

    #1159595

  • RE: Server Services

    NJ-DBA (4/29/2010)

    The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.

    The Cluster Service should...

    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.

    April 29, 2010 at 6:17 am

    #1159594

  • RE: Server Services

    I'm not quite sure I understand the question, but I'll try.

    If you add SQL Services to the cluster administrator tool, you should absolutely make sure they are set to restart....

    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.

    April 29, 2010 at 6:07 am

    #1159587

  • RE: Encrypting the entire database.

    I agree with thoughts that this could be a misinterpretation of the situation. If an entire database needs encrypting, my thought is that NO ONE should have access to 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.

    April 29, 2010 at 5:52 am

    #1159577

  • RE: Please Solve This query

    My take on this post is (s)he wants us to build the actual database.

    Read Books Online. It has all sorts of useful information on how to do this task.

    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.

    April 29, 2010 at 5:48 am

    #1159574

  • RE: Drop and recreate vs alter stored procedure

    I'll have to check into that myself. I never bothered to look and we do need that info.

    Thanks, Lynn & Grant.

    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.

    April 28, 2010 at 8:35 am

    #1158986

  • RE: Tempdb GROWS

    Your best bet is to run a day long session of Profiler and PerfMon to identify your issues.

    Or have both run sample traces every X number of minutes. But that's...

    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.

    April 28, 2010 at 5:21 am

    #1158774

  • RE: Tempdb GROWS

    2cams (4/28/2010)

    MANU-J. your query gives me NULL in all the rows listed ...

    If you're getting NULLS, there's not a whole lot happening. But just an FYI, MANU-J is using an...

    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.

    April 28, 2010 at 4:19 am

    #1158752

  • RE: Job Failed

    The maintenance plans will always look in the system tables for backup file names when cleaning up old data. The only way to delete old backups without affecting the system...

    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.

    April 28, 2010 at 4:14 am

    #1158751

  • RE: Just a doubt

    I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response is "Why?...

    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.

    April 27, 2010 at 8:27 am

    #1158276

  • RE: Just a doubt

    Ahh. For some reason all the SANs I've come across use multiple disk controllers. I've never heard of one with only one controller, unless the SAN used logical drives only...

    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.

    April 27, 2010 at 8:19 am

    #1158266

  • RE: Shemas(DBO, UserDefined) Security Problem with Recovered Database

    Lynn Pettis (4/27/2010)

    Sounds like all you may have restored is the production database. Did you setup the logins/users as they were setup on the hosted system? It sounds...

    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.

    April 27, 2010 at 8:16 am

    #1158263

  • RE: Just a doubt

    Grant Fritchey (4/27/2010)

    Brandie Tarvin (4/27/2010)

    If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a...

    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.

    April 27, 2010 at 8:07 am

    #1158255

  • RE: Drop and recreate vs alter stored procedure

    homebrew01 (4/27/2010)

    Brandie Tarvin (4/27/2010)

    For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken....

    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.

    April 27, 2010 at 8:04 am

    #1158252

  • RE: Linked server connection issue.

    What is Data Provider "MSDASQL"?

    I've never heard of this one before.

    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.

    April 27, 2010 at 8:02 am

    #1158249

Viewing 15 posts - 8,041 through 8,055 (of 9,715 total)