Forum Replies Created

Viewing 15 posts - 121 through 135 (of 175 total)

  • RE: 2005 and Memory Management

    Your comment about AWE not being pageable seems to be accurate. 

    Just one more thing... I noticed the same thing on my SQL Servers until we turned AWE on.  This...

  • RE: 2005 and Memory Management

    Ahh yes.  I've just been through all of this with Microsoft themselves...  The word we got back from them was that the pagefile has less and less of an impact...

  • RE: Error in script object in SSIS

    By the way, we're having this issue as well.  It appears it got to the Microsoft forums as well and no action has been taken as of yet.

    It seems if...

  • RE: Memory fragmentation?

    Well, let me put it this way.  Server and query performance was extremely slow before I came here.  When I read that article I posted, I enabled AWE on this...

  • RE: Memory fragmentation?

    I wonder if a combination of both AWE and the /PAE switch is whats needed.

    Its hard to determine, the documentation around this issue seems to be highly conflicting.  The SQL...

  • RE: Memory fragmentation?

    "If your running x64 there is no reason for AWE to be enabled. That's a 32 bit hack."

    Actually, thats not exactly true...  I used to think so myself, until...

  • RE: Memory fragmentation?

    Yes, I have enabled the local policy for "lock pages in memory" for the SQL service account and have selected AWE enabled for the instance.  I have minimum server memory...

  • RE: New Column Updates

    Ha!  Very nice.  I'm facing a similar situation here.  This article demonstrates a nice way of dealing with this situation.  Not to mention the issue of blocking / locking on...

  • RE: How often should I schedule a reboot of SQL Server 2005?

    Interesting question.  I'm dealing with the same issue here, but not with a cluster.

    I did find this interesting writeup on how CLR application authors are dealing with the issue...

    http://blogs.msdn.com/bclteam/archive/2006/10/17/clr-behavior-on-outofmemoryexceptions-brian-grunkemeyer.aspx

    Other...

  • RE: Automatic load of Reporting Services application pool on startup

    Well, I've partially solved this by simply writing an OS script that calls the reporting services web service on the restart of the box.  However there has to be some...

  • RE: Sic Semper NULL

    Thank you for addressing this issue Michael.

    Fundamentally, NULL values indicate a fundamental flaw in tuple (noun) definition.  SQL Server's treatment of NULL equality can be unexpected for those who work...

  • RE: SQL Server 2005 Build List

    Steve, thank you.  You can't believe how many times I've tried to find a complete list...

  • Not a new lesson, but  as I was working through a couple of the early chapters I remembered how much I hate portions of SSIS. Paths have to be...

  • RE: Views and Horizontal Portioning

    Not sure if a discussion about table partitioning versus partitioned views is relevant to the content of the article.  Having said that, I have recently been involved in a situation...

  • RE: DTS Problem

    It sounds like you may have a problem with some OLEDB libraries on the machine where you are executing the DTS package itself.

    Here's a few reccomendations. (Brian Knight, chime...

  • Viewing 15 posts - 121 through 135 (of 175 total)