Forum Replies Created

Viewing 15 posts - 28,126 through 28,140 (of 39,804 total)

  • RE: If I m taking the restoration from 64 bit CPU to 32 bit CPU then restoration is giving error.

    How are you doing the restore and exactly what happened? Also, have you run a checkdb or restore verifyonly on the files?

  • RE: odbc sql-state 42000

    Are you restoring to the same external disk or the internal disk you had issues with?

    Can you restore the file on another machine?

    The error message and exact steps would...

  • RE: Rules, Defaults and the SQL Standard

    SQL Apprentice Jeff...has a nice ring to it. Maybe we can chip in for a pointy hat for you to wear to the meetings 😉

  • RE: Cursors

    Everyone is right, not sure how sp_describe_cursor_columns got chosen as an answer. Must have been a bad day 🙁

    Busy this week, so I've missed this thread until now. The QOD...

  • RE: ANY

    The values are in rows, not columns.

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

Viewing 15 posts - 28,126 through 28,140 (of 39,804 total)