Forum Replies Created

Viewing 15 posts - 30,526 through 30,540 (of 49,552 total)

  • RE: Latch_ex high

    damon.ashman (9/20/2010)

    You may want to increase the number of files in each of your filegroups to match the number of physical CPUs on the server as well as insure the...

    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

    September 20, 2010 at 9:19 am

    #1224120

  • RE: Does SQL Server guarantee accurate data storage? If so, how?

    SQL's got what it calls a page checksum. If the page verify property of the database is set to Checksum, all data pages are protected by that checksum.

    When a modified...

    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

    September 20, 2010 at 9:16 am

    #1224116

  • RE: Shouldn't the trans log backup be truncating my log file?

    SkyBox (9/20/2010)

    GilaMonster

    Ok.... Is it still the same after doing a log backup? If so, what's the script you're using to do the log backups?

    So after backing up the trans...

    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

    September 20, 2010 at 9:15 am

    #1224114

  • RE: Changing the installed binary location of SQl Server 2008

    ashwin4all1 (9/20/2010)

    1)Is there any possibilities to change directory of binary from F: drive to E: drive ,Without uninstalling the sql server.

    Nope. None whatsoever.

    You can move data and log files,...

    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

    September 20, 2010 at 8:55 am

    #1224098

  • RE: Execution plan showing Table scan though Index is present

    Bhuvnesh (9/20/2010)

    Do we have covering index in sql 2000 ? :unsure:

    Covering index is not a feature that's available in some versions and not in others. It just means that the...

    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

    September 20, 2010 at 8:54 am

    #1224097

  • RE: Attach DB fails - Error 824 - torn page - SQL 2005

    ashish.kuriyal (9/20/2010)

    Also try to attach with original mdf and put new ldf file instead of using old ldf.

    That will not work. It'll give an error saying that the ldf...

    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

    September 20, 2010 at 8:52 am

    #1224094

  • RE: I want to attach *.mdf file of Sql server 2000 to Sql server 2008

    nuthan_kumar (9/20/2010)

    I have a abc.mdf file of sql server 2000 and now i am trying to attach it to sql server 2008.

    and getting this error.

    "Database 'ABC' cannot be upgraded because...

    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

    September 20, 2010 at 8:49 am

    #1224093

  • RE: Attach DB fails - Error 824 - torn page - SQL 2005

    Andrew van Zyl (9/20/2010)

    If I run SELECT state_desc FROM sys.databases WHERE name='Heat_Logistics' I get "Recovery_Pending"

    Try Emergency mode

    ALTER DATABASE Heat_Logistics SET EMERGENCY

    I don't guarantee it'll work. In fact, if the attach...

    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

    September 20, 2010 at 8:46 am

    #1224090

  • RE: Attach DB fails - Error 824 - torn page - SQL 2005

    ashish.kuriyal (9/20/2010)

    the new database have new definition and you mixed the definition with old mdf....and sql is totally not able to understand the definition from the replaced mdf file.

    That's 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

    September 20, 2010 at 8:44 am

    #1224088

  • RE: Are the posted questions getting worse?

    *drum roll*

    *trumpet crescendo*

    ... and I think I'll leave things here for a little while.

    Edit: And as soon as i decide not to post for a few hours, there's a corruption...

    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

    September 20, 2010 at 4:35 am

    #1223903

  • RE: GetDate() not working

    Post the table definition and the insert statement that you are using.

    Any trigger on the table?

    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

    September 20, 2010 at 4:09 am

    #1223887

  • RE: Error backup database: nonrecoverable I/O error occurred on file ...

    A quick google search reveals that Operating system error 112 means "There is not enough space on the disk.". Hence I would guess that there isn't enough space for the...

    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

    September 20, 2010 at 4:06 am

    #1223885

  • RE: SQl Query performace

    Actual execution plans please, not estimated. The estimated don't show the row count and that's critical for telling if this is indeed parameter sniffing.

    The use of TOP doesn't change the...

    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

    September 20, 2010 at 2:05 am

    #1223845

  • RE: Execution plan showing Table scan though Index is present

    Without seeing the table def, I can't say whether that's a good idea or not.

    Please read the article I referenced, it describes how to save the execution plan on...

    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

    September 20, 2010 at 2:04 am

    #1223844

  • RE: SQl Query performace

    Sounds like classic parameter sniffing. Let me guess, there's a massive difference in row counts between South Carolina and California?

    http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

    I'd like to see the execution plans for both please, plus...

    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

    September 19, 2010 at 11:51 pm

    #1223820

Viewing 15 posts - 30,526 through 30,540 (of 49,552 total)