Forum Replies Created

Viewing 15 posts - 38,491 through 38,505 (of 49,552 total)

  • RE: Move table from one filegroup to another filegroup

    RPSql (6/11/2009)

    Can you please give detailed description or any article for this for moving table with clustered index, non clustered index and a table without any index...

    See my initial reply.

    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 11, 2009 at 2:13 pm

    #1008244

  • RE: deleting backup logs

    To restore to a point in time you need all of the transaction log backups from the full backup up to the point you're restoring to. They are not cumulative.

    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 11, 2009 at 2:11 pm

    #1008242

  • RE: Move table from one filegroup to another filegroup

    Alberto De Rossi (6/11/2009)

    This is the one, promise. Sorry for the inconvenience

    SET XACT_ABORT ON

    BEGIN TRY

    BEGIN TRAN

    CREATE CLUSTERED INDEX ix_TableA_Transfer ON tableA (id) ON [OtherFileGroup]

    COMMIT

    END TRY

    BEGIN CATCH

    ...

    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 11, 2009 at 2:01 pm

    #1008235

  • RE: Move table from one filegroup to another filegroup

    RPSql (6/11/2009)

    1. Move a table without any index or primary key or constraints

    Create a clustered index and specify ON with the new filegroup. Then drop the clustered index

    2. Move a...

    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 11, 2009 at 1:08 pm

    #1008206

  • RE: Who's At Fault

    bob.willsie (6/11/2009)

    So, my question to the group is: What, if any, is an acceptable error rate for data loss or corruption on SQL Server?

    Zero.

    Corruption is usually due to hardware problems,...

    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 11, 2009 at 11:01 am

    #1008156

  • RE: Restore Problem

    acapucion (6/11/2009)

    IWe tried backuping the XYZ database (compatibility mode is still set to 2000, no changes was made)

    on SQL Server 2008 environment. But we are trying to restore the 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

    June 11, 2009 at 10:59 am

    #1008155

  • RE: Comparing Table Variables with Temporary Tables

    That it is. I'm trying to get some clarification as to where that row estimate comes from. It's not from statistics, there's no auto stats events fired and no stats...

    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 11, 2009 at 10:33 am

    #1008144

  • RE: Backup detected log corruption in database

    The following should work, but take a backup first (as with all production-type fixes)

    Switch the database to simple recovery.

    Run a checkpoint

    Switch back to full recovery

    Take a full backup

    Test log backups...

    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 11, 2009 at 10:14 am

    #1008127

  • RE: Date string in WHERE causes table scan instead of index seek

    Joseph Fallon (6/11/2009)

    GilaMonster (6/11/2009)

    Joseph Fallon (6/11/2009)

    When I don't use "SELECT * FROM " the query always uses the covering index. Thanks for the tip Mr Stobbs.

    Is the index really covering...

    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 11, 2009 at 10:06 am

    #1008120

  • RE: Stored Procedure Code to "Up To Date"

    gmartin (6/11/2009)

    I want to "select" without locking things up. SNAPSHOT may be better option, but that's not turned on at the moment.

    If you use the default isolation, does that...

    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 11, 2009 at 10:00 am

    #1008116

  • RE: Comparing Table Variables with Temporary Tables

    sscddr (6/11/2009)

    The article should discuss the wonders of "option (recompile)". It forces SQL to recompile the query plan with knowledge of the number of rows currently in 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

    June 11, 2009 at 9:57 am

    #1008115

  • RE: Stored Procedure Code to "Up To Date"

    gmartin (6/11/2009)

    begin tran

    select @Tran_Date = Tran_Date from myTable

    where Tran_ID = 123456

    commit

    Absolutely no point in a transaction there. Transactions are so that changes happen as atomic...

    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 11, 2009 at 9:40 am

    #1008101

  • RE: Stored Procedure Code to "Up To Date"

    gmartin (6/11/2009)

    I have one server, but it has multiple databases. The main db is where this code originally lived. Yesterday, in addition to editing it, I had 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 11, 2009 at 9:22 am

    #1008079

  • RE: How to get matched record by keyword(s)

    Have you considered full text search?

    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 11, 2009 at 9:10 am

    #1008066

  • RE: Stored Procedure Code to "Up To Date"

    gmartin (6/11/2009)

    So, if I understand you correctly, you are saying that I am mistaken. That the version of the sp that I'm getting when I use sp_helptext is 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

    June 11, 2009 at 9:10 am

    #1008064

Viewing 15 posts - 38,491 through 38,505 (of 49,552 total)