Forum Replies Created

Viewing 15 posts - 421 through 435 (of 824 total)

  • RE: Optimizing Cursor Performance

    I think that I'll check it out then.  Do you have a page number that I can reference so I don't have to search around?  If this is the case...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Optimizing Cursor Performance

    I have several of Henderson's books but I don't have the one you refer to so I can't verify your statement myself.  Just a few thoughts though...

    As a sometime autor...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Worst Practices - Making Databases Case Sensitive (Or Anything Else)

    Case is primarily a formatting function and seldom, if ever, affects meaning in real life, thus my database objects are almost always case insensitive.  Formatting is the job of the...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Changing dbo from sa to another user

    In cases like this I love to tell the vendor exactly where they can shove it!  For crying out loud, who is the customer here?  Vendors either work within my...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: What happens during a backup?

    Not only can checkpoints occur, logic would dictate that they would HAVE to.  The full backup has to be consistent when it finishes and it couldn't be consistent if there...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: What happens during a backup?

    I don't know if there is a specific order in which the data or transaction log pages are written by default.  However, since the backup is an online operation if...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Changing dbo from sa to another user

    Are they really saying that the user needs to own the database or are they saying that the user needs to be dbo, or are they saying that the user...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: t-sql help

    Believe it or not, we're not trying to pile on here...  But it would also be very helpful if you would provide an example of what you want the results...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Changing dbo from sa to another user

    First off I would ask why it is important that a particular user owns the database?  Usually it's the case that you don't want a particular user to own the...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: negetive working set size value ????

    What are your min and max server memory settings, and how much RAM does your server have?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Extra processors...

    Yeah, I wondered about HT's potential negative effects.  The main one being additional parallelism without the benefit of actually having seperate CPU's.  I have run our servers both ways and...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Latches and Access Violations

    Unfortunately, aside from applying the latest SP those access violations generally indicate that you need to get out your credit card and call PSS.

    In all fairness, I have always had...

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: SQL 7.0 Upgrade to 2000 on Clients

    Generally speaking, in the absence of a software management server of some sort, you don't. 

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Latches and Access Violations

    I can't say that I've seen this particular issue, but anytime I see Latch warnings like this I immediately suspect the IO subsystem. 

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • RE: Extra processors...

    Let me guess... you are using P4 or P4 Xeon chips.  This is the hyperthreading, but even though SQL "sees" 8 CPU's you only need to license 4.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

Viewing 15 posts - 421 through 435 (of 824 total)