Forum Replies Created

Viewing 15 posts - 32,551 through 32,565 (of 49,552 total)

  • RE: from 2008 to 2005

    It is not possible.

    A SQL 2008 database cannot be attached or restored to SQL 2005 or lower. Only upgrades of database versions are possible (2005->2008), never downgrades.

    The only way to...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 4:24 am

    #1177889

  • RE: Database file placement

    RAID arrays or single drives?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 3:42 am

    #1177875

  • RE: Retrive Data after Delete or Update Row of Table.

    Unless the delete/update in question was running within a transaction, no. Restore from backup.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 3:39 am

    #1177869

  • RE: Recovery State

    Providing no one minds losing the data since the last log backup, that is.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 3:30 am

    #1177862

  • RE: Advice for getting First SQL Job

    http://www.brentozar.com/sql/how-to-get-a-junior-dba-job/

    Most important - don't exaggerate your skills or experience.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 12:06 am

    #1177807

  • RE: SQl Server log displays Starting up the database as the message and source as SPID34s

    Is auto_close enabled?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 12:01 am

    #1177806

  • RE: Timeouts

    No.

    Are you seeing deadlocks? Are you having queries failing with the error "Transaction X was deadlocked and was chosen as the deadlock victim"? Deadlocks and blocking are two different (though...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 9, 2010 at 12:01 am

    #1177804

  • RE: Please help me with the Performance and Locking Issues....

    stewartc-708166 (6/8/2010)

    > use WITH(NOLOCK) on each table in the query

    No, no, no, no!

    Why are you offering advice without telling people the consequences? Nolock means 'get the data quickly, I don't...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 11:40 pm

    #1177801

  • RE: updating xml with special characters

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic934389-145-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 11:37 pm

    #1177800

  • RE: Please help me with the Performance and Locking Issues....

    There's not enough information here to say anything useful. You're going to have to give a lot more info if you want useful help. The queries and table structures would...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 11:36 pm

    #1177798

  • RE: DBCC Error.

    Run CheckDB with the repair option (DB must be in single user mode). Then restore that 3 week old backup as a new DB and use something like Redgate's SQLDataCompare...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 11:35 pm

    #1177796

  • RE: DBCC Error.

    Looks like a portion of the data file has been zeroed out, overwritten with 0s. Typically an IO subsystem problem.

    Your choices are to run CheckDB with the REPAIR_ALLOW_DATA_LOSS option and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 12:33 pm

    #1177641

  • RE: Differences between SQL Server 2008 and SQL Server 2008 R2

    Um, how about the first two links?

    The reason they don't say anything about changes (assuming you've read them), is because R2 is a whole set of add-ons. There are virtually...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 11:28 am

    #1177608

  • RE: Sub Query VS Left Outer Join

    only4mithunc (6/8/2010)

    Are you sure that all joins are possible if the Sub query comes in WHERE clause or in FROM clause as well..?

    Yes. Why don't you test it out and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 10:11 am

    #1177549

  • RE: Sub Query VS Left Outer Join

    Nope. All join types are possible.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    June 8, 2010 at 9:55 am

    #1177541

Viewing 15 posts - 32,551 through 32,565 (of 49,552 total)