Forum Replies Created

Viewing 15 posts - 27,046 through 27,060 (of 49,552 total)

  • RE: SQL Server 2008 R2, what is the latest version of Service Pack for it

    onlo (3/28/2011)

    I have installed SQL Server 2008 R2 on my machine.

    (1) Do you know which Service Pack should I apply on it ?

    It hasn't had a service pack yet

    (2) Does...

    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

    March 28, 2011 at 2:29 am

    #1304206

  • RE: Is my Database consistent after running DBCC CHECKDB with ALLOW_DATA_LOSS

    Was that before or after you ran the repair?

    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

    March 28, 2011 at 12:29 am

    #1304182

  • RE: Can there be two sql servers on a single computer?

    Yes. SQL supports up to 50 instances on a single computer. In general you'd be insane to install anywhere close to that number, but it is allowed

    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

    March 27, 2011 at 11:52 pm

    #1304167

  • RE: shrink log file and do a transaction backup after transaction log is full

    Please read through this - Managing Transaction Logs[/url]

    Shrinking a log is for when there has been some unusual, once-off activity that has made the log far larger than usual. If...

    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

    March 27, 2011 at 11:49 pm

    #1304165

  • RE: Deadlock on a single resource ?

    Jimble McBrim (3/25/2011)

    Hi,

    Some more information below, including the schema. Yes, that is the whole of the output, spid 60 looks like it is missing details - but 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

    March 27, 2011 at 11:35 pm

    #1304162

  • RE: transaction log is full after run maitenance plan

    annasql (3/27/2011)

    Thank you, so you said to change to bulk copy recovery mode then do the rebuild index. Can I also change to simple mode recovery to do this? For...

    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

    March 27, 2011 at 11:34 pm

    #1304161

  • RE: Case statement and if not exists

    update STGtable

    Set processKey = CASE

    WHEN table1.DataValue is NULL or table1.DataValue = ' ' THEN 0

    WHEN NOT EXISTS (SELECT 1 FROM DimProcess m where...

    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

    March 27, 2011 at 3:08 pm

    #1304128

  • RE: No physical reads ?

    Edit: nevermind...

    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

    March 27, 2011 at 2:08 pm

    #1304115

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/27/2011)

    GilaMonster (3/27/2011)

    Jeff Moden (3/27/2011)

    Oh yes... I know it's partially correct. I just couldn't understand why anyone who knows of SQL would bring it up even as partial...

    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

    March 27, 2011 at 2:05 pm

    #1304113

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/27/2011)

    Oh yes... I know it's partially correct. I just couldn't understand why anyone who knows of SQL would bring it up even as partial justification for not...

    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

    March 27, 2011 at 1:27 pm

    #1304099

  • RE: Shrink Database in Simple Recovery Mode

    One minor addition to Wayne's notes.

    At the point that the commit or rollback completes, the log records for that transaction are guaranteed to be in the log file. They may...

    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

    March 27, 2011 at 1:22 pm

    #1304096

  • RE: Shrink Database in Simple Recovery Mode

    Sachin Nandanwar (3/27/2011)

    Does it hold true for a checkpoint occurring before the end of a transaction no matter what the outcome of that transaction is ?The checkpoint will still flush...

    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

    March 27, 2011 at 12:23 pm

    #1304084

  • RE: Shrink Database in Simple Recovery Mode

    Sachin Nandanwar (3/27/2011)

    The dirty pages now have been written to disk which is undesirable in the above scenario but log entries aren't made to the log files as the transaction...

    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

    March 27, 2011 at 11:37 am

    #1304079

  • RE: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. The statement has been terminated.

    Use convert to specify the format, SQL's probably assuming it's mm/dd/yyyy, or switch to a data format that can't be confused - yyyy/mm/dd

    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

    March 27, 2011 at 7:56 am

    #1304057

  • RE: Are the posted questions getting worse?

    Tom.Thomson (3/27/2011)

    Mainly a language problem I think, Muthukkumaran was pointing out that shrinking the log is not the same as truncating it and that shrinking it is usually a very...

    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

    March 27, 2011 at 7:53 am

    #1304056

Viewing 15 posts - 27,046 through 27,060 (of 49,552 total)