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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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