Forum Replies Created

Viewing 15 posts - 28,096 through 28,110 (of 39,769 total)

  • RE: Best file compression software?

    Hyperbac are the same guys that originally built Litespeed (from DBAssociates way back when). They've got a lot of experience and since you have lots of choices now (MS, Red...

  • RE: The Back Door DBA

    And if you don't group emails by sender (I don't), be sure that you read from the newest to oldest. I've often found a note that something critical needed a...

  • RE: SQL 2005 Server Performance on Multicore CPU

    There are a few things to check.

    First, not sure which version of Windows you have, but in some versions there is a different kernel for 1 CPU or multiples. I'd...

  • RE: SQL Server 2005 Build List

    Apologies for the delay. the XLS is updated.

  • RE: The Core

    I think you can survive without knowing the business. Window setup, exchange, basic SQL admin, etc. don't need business knowledge. However they're then tactical, utility services.

    If you want to be...

  • RE: Date Parameter

    And show some work in what you think or have attempted.

  • RE: ANY

    Upper case before lower case (http://www.asciitable.com/), remember that we only had upper case way back when.

    But do the QOD however you want. Some people want the points, maybe it's a...

  • RE: ANY

    The query shows "value1", not "Value1", which definitely depends on case sensitivity.

    however, in any case, "value1" is less than "value2" and the others. Your example bends the rows into columns....

  • RE: Log and DB placement.

    Actually if it's just 2 or 3 drives, implement RAID first. If a drive fails, you're in trouble. That's more important than moving stuff around.

  • RE: What would be the best set up for me???

    2 RAID 1, keep a spare spinning in there. OS, data on one, Logs on the other.

    Be nice to get 2 smaller drives for a small log array and go...

  • RE: Update a text field in SQLServer 2000

    Look up UPDATETEXT. It is needed once you get above a certain size.

  • RE: Delete SQL Logins (Question)

    Mani is correct and you can sync them back up. Remember the USERS are in the database and this is completely separate from LOGINs, which are on the server....

  • RE: Restrict log file growth

    I agree with Matt. Set the logs at their peak + pad, and leave them. There's no reason to shrink them. As you back them up (or checkpoint in simple...

  • RE: sql 2005 cluster SAN issues?

    Is performance worse than the old system?

    I tend to agree with GSquared on the setup, though I'd check the cache on the SAN as well. For SQL you really want...

  • RE: The Vacation Dilemma

    Ian, all you can do is document as best you can. If no one will pick up the slack to learn the older system, at least you've done something.

    I'm trying...

Viewing 15 posts - 28,096 through 28,110 (of 39,769 total)