Forum Replies Created

Viewing 15 posts - 36,421 through 36,435 (of 49,552 total)

  • RE: delete records in sql without entry in transaction log

    wodom (10/7/2009)

    In practice, even with a power fail in the middle, you're not going to end up with pages that are marked as allocated but are not allocated, etc....

    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

    October 7, 2009 at 3:23 pm

    #1063111

  • RE: unable to create database

    Does the directory F:\SQLData exist?

    Does the SQL Service account have full rights to it?

    Is this a clustered SQL Server?

    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

    October 7, 2009 at 10:02 am

    #1062913

  • RE: Are my indexes wrong??

    jflzc (10/7/2009)

    jflzc (10/7/2009)

    And what about the oposite, when you have high scans and look seeks like in this:

    Then either the indexes aren't appropriate for the queries been run against 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

    October 7, 2009 at 9:56 am

    #1062906

  • RE: Database Mirroring Transport is disabled when setting up Database Mirroring

    tallapaneni_rao (10/7/2009)

    hi i am using sql server rtm what patches i need to apply

    Apply SP3

    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

    October 7, 2009 at 9:47 am

    #1062890

  • RE: delete records in sql without entry in transaction log

    wodom (10/7/2009)

    OK, so from that aspect it looks like DROP is safer (and faster) than TRUNCATE, especially for very large tables. (And being faster makes it safer still.)

    They do pretty...

    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

    October 7, 2009 at 9:46 am

    #1062888

  • RE: DBCC Errors

    COOL_ICE (10/6/2009)

    If data lost is very negligible and your management can afford the data loss, you are good to go.

    Run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS on Live DB

    If data loss id...

    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

    October 7, 2009 at 1:36 am

    #1062618

  • RE: Database cannot be opened - Error

    Can you have a look at the SQL error log. Please post all of the error messages relating to this database

    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

    October 7, 2009 at 1:33 am

    #1062616

  • RE: Database Mirroring Transport is disabled when setting up Database Mirroring

    tallapaneni_rao (10/7/2009)

    i added ;-T1400 but still i am getting same error

    Traceflag 1400 is only needed if you're running SQL 2005 RTM. If you're running SP1 or above, it's not needed,...

    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

    October 7, 2009 at 1:29 am

    #1062614

  • RE: Seperate Indexes from Data

    repent_kog_is_near (10/6/2009)

    Guru

    All your points are well taken. Yes, the DB is heavily hit for I/O bottleneck (we use perfmon-Avg. Disk Queue Length is 27; % disk time 2100; Current Disk...

    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

    October 6, 2009 at 8:58 am

    #1062318

  • RE: Seperate Indexes from Data

    repent_kog_is_near (10/5/2009)

    Steve

    I have read some emphasis to take out all clustered index into .ndf; some take all non-clustered into ndf. I guess what you saying is regardless of C or...

    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

    October 6, 2009 at 8:07 am

    #1062263

  • RE: Any benefit to shrink after Trans Log Backup (FULL recovery model)

    repent_kog_is_near (10/6/2009)

    Do you know what is the default recovery interval, in minutes, for FULL Recovery model? If this is short enough, our worry is not worth it.

    Offhand I don't, but...

    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

    October 6, 2009 at 8:02 am

    #1062259

  • RE: Help with a Long running stored procedure

    newbie2009 (10/6/2009)

    Pls see sql plan attached.

    Did you read the article?

    Table definitions and index definitions please.

    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

    October 6, 2009 at 7:57 am

    #1062256

  • RE: Help with a Long running stored procedure

    See if you can narrow down which query is the problem. It may just be one of them, or it may be that proc that's called at the bottom. 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

    October 6, 2009 at 5:23 am

    #1062167

  • RE: need 70-443 certification guide lines

    Here's the breakdown of the exam - http://www.microsoft.com/learning/en/us/Exam.aspx?ID=70-443&Locale=en-us#tab2

    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

    October 6, 2009 at 1:03 am

    #1062108

  • RE: delete records in sql without entry in transaction log

    wodom (10/5/2009)

    Steve Jones - Editor (10/5/2009)

    It's easy to say I want to do this, but think about the times where you have an issue. What if you get halfway through...

    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

    October 5, 2009 at 11:31 pm

    #1062102

Viewing 15 posts - 36,421 through 36,435 (of 49,552 total)