Forum Replies Created

Viewing 15 posts - 4,606 through 4,620 (of 9,722 total)

  • RE: Are the posted questions getting worse?

    Kiara (3/26/2012)

    Happy Monday, folks!

    Just coming up for air after a couple of weeks of crazy. Figured I'd catch up on The Thread and say "Hi".

    Hi, back. Welcome to this week'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.

    March 26, 2012 at 4:40 pm

    #1464630

  • RE: Are the posted questions getting worse?

    Evil Kraig F (3/26/2012)

    In the US, our Social Security Numbers are assigned for life and are supposed to be unique. However, our volume of illegal immigrant labor makes for...

    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.

    March 26, 2012 at 2:04 pm

    #1464519

  • RE: Memory - Total/Target always using same value?

    george sibbald (3/26/2012)

    so if I read it right a preponderance of ad hoc SQL but they are getting some re-use?

    Not really. That last column tells me that the number...

    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.

    March 26, 2012 at 1:46 pm

    #1464503

  • RE: Memory - Total/Target always using same value?

    opc.three (3/26/2012)

    Brandie Tarvin (3/26/2012)

    opc.three (3/26/2012)

    Cool, thanks for posting back.

    ...

    I would explore enabling the adhoc workloads server configuration if it's not already on.

    Opc, you do realize I'm not the OP, right?...

    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.

    March 26, 2012 at 12:19 pm

    #1464468

  • RE: Memory - Total/Target always using same value?

    opc.three (3/26/2012)

    Cool, thanks for posting back.

    ...

    I would explore enabling the adhoc workloads server configuration if it's not already on.

    Opc, you do realize I'm not the OP, right? I only posted...

    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.

    March 26, 2012 at 12:11 pm

    #1464465

  • RE: Memory - Total/Target always using same value?

    I don't have Kimberly's contact information to email her the updated proc.

    As far as my results go, they're pretty nasty.

    CacheType Total Plans Total MBs Avg Use Count Total MBs...

    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.

    March 26, 2012 at 11:52 am

    #1464453

  • RE: Memory - Total/Target always using same value?

    If you run into the overflow error, like I did, try this:

    SELECT objtype AS [CacheType],

    COUNT_BIG(*) AS [Total Plans],

    ...

    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.

    March 26, 2012 at 11:28 am

    #1464446

  • RE: Memory - Total/Target always using same value?

    I'm not the OP, but I decided to try it anyway. I think I'm scared of my result.

    Msg 8115, Level 16, State 2, Line 1

    Arithmetic overflow error converting expression 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.

    March 26, 2012 at 11:08 am

    #1464437

  • RE: 2008 R2 32 bit upgrade to 64 bit - could it be that easy?

    Glad we could help.

    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.

    March 26, 2012 at 11:04 am

    #1464433

  • RE: Today's Random Word!

    yonder

    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.

    March 26, 2012 at 6:23 am

    #1464186

  • RE: Are the posted questions getting worse?

    Memory experts needed, please. All my advice is based off of stuff I found on the 'net and not on real experiencing managing the memory.

    http://www.sqlservercentral.com/Forums/Topic1271523-1550-1.aspx

    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.

    March 26, 2012 at 5:48 am

    #1464174

  • RE: Memory - Total/Target always using same value?

    Do you have a lot of ad hoc queries running in your system?

    Do you have a lot of procs that recompile each time they run?

    From what I understand, this could...

    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.

    March 26, 2012 at 5:47 am

    #1464173

  • RE: SSIS Database Transfer Task - Network Share Error

    noelle.stimely (3/23/2012)

    Now it is not working... I tinkered and it does not work... I have to configure network shares on both sides, right?

    What did you tinker with? 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.

    March 26, 2012 at 4:58 am

    #1464158

  • RE: Memory - Total/Target always using same value?

    ananda.murugesan (3/25/2012)

    1. Could you tell me, In Memory Object counter - Total & Target memory shows same values and same memory. Does these values are good or bad?

    2. Total 4GB...

    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.

    March 26, 2012 at 4:57 am

    #1464157

  • RE: 2008 R2 32 bit upgrade to 64 bit - could it be that easy?

    Mhlewis (3/23/2012)

    Brandie - this is an infrastructure upgrade. The only benefit is that once our server is upgraded to Windows Server 2008 it can be virtualized and then our...

    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.

    March 26, 2012 at 4:17 am

    #1464140

Viewing 15 posts - 4,606 through 4,620 (of 9,722 total)