Forum Replies Created

Viewing 15 posts - 35,521 through 35,535 (of 49,552 total)

  • RE: Rebuild Index

    Ok, looked around and seems there's both definitions of internal and external fragmentation. I usually use them to mean fragmentation internal to SQL (and fixable within SQL) and fragmentation external...

    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

    December 3, 2009 at 1:44 am

    #1086947

  • RE: Performance optimization on huge data

    Please post queries, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    One of the non-clustered index is having all the columns in that table.

    Why? Is that index used?...

    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

    December 3, 2009 at 1:36 am

    #1086945

  • RE: My san disk is about to full and I can't add other database on it.

    guptaajay1985 (12/2/2009)

    Thanks..Actually this is a critical scenario and to make changes in a running scenario is risky.

    It doesn't make the slightest difference how critical the situation is. You have 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

    December 3, 2009 at 1:30 am

    #1086942

  • RE: Call stored proc from stored proc

    tnocella (12/2/2009)

    Create Procedure p_myproc1

    Begin

    SELECT 1

    End

    --- Proc 1 just returns a value of 1 through a select

    Create Procedure p_myproc2

    Begin

    Declare @Result int...

    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

    December 3, 2009 at 1:22 am

    #1086937

  • RE: Call stored proc from stored proc

    tnocella (12/2/2009)

    I tried that code, its actually executing the procedure and returning it as a result from the

    calling stored procedure.

    Well, yes. That's what you want isn't it?

    I basically...

    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

    December 2, 2009 at 3:07 pm

    #1086800

  • RE: Searched Case execution

    Ok, don't know what the rest of the query looks like, but to be 100% sure that we're looking in the right place at the right rows, please complete 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

    December 2, 2009 at 2:46 pm

    #1086787

  • RE: Update statement fails ...

    J-F Bergeron (12/2/2009)

    SQL Server does not let you assign a value to a column when it COULD be returning more than 1 row.

    It does allow the scenario where returning...

    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

    December 2, 2009 at 2:37 pm

    #1086779

  • RE: Update statement fails ...

    You're not relating the subquery in any way to the table that you're updating, so, for each row of the table that you're updating, ALL of the rows in 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

    December 2, 2009 at 2:29 pm

    #1086772

  • RE: Call stored proc from stored proc

    Declare @Result int

    exec @Result = sp_myprocedure @Param1, @Param2, @Param3

    Aside, don't name stored procedures sp_<whatever>. sp_ means system procedure and, if a proc is named that, resolution is first to 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

    December 2, 2009 at 2:24 pm

    #1086768

  • RE: Dropping a cached plan?

    shannonjk (12/2/2009)

    I am sure after testing several thousand times it had generated quite a few plans that are no longer the best suited for what I have now.

    There will...

    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

    December 2, 2009 at 2:21 pm

    #1086766

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (12/2/2009)

    just came across this ad:

    http://www.sqlservercentral.com/Forums/Topic716821-360-3.aspx

    You missed what happened over Thanksgiving weekend. On the friday that guy had posted to over 20 threads with exactly the same message, even threads...

    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

    December 2, 2009 at 2:18 pm

    #1086765

  • RE: Searched Case execution

    'Private Insurance' is NOT one of the possible values for cval1.Control_Value1.

    Maybe not, but the 2nd branch of the case allows for 'Private Insurance' to be returned when Control_Value1 is NULL...

    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

    December 2, 2009 at 2:15 pm

    #1086764

  • RE: Searched Case execution

    Why are there quotes around the -1? Is that column a varchar? If so, check for leading spaces.

    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

    December 2, 2009 at 2:12 pm

    #1086761

  • RE: Log File runing.... Disk out of space

    atramard (12/2/2009)

    Are you sure this acctualy occur as my log file grew from ~500Mb to over 70Gb (in 3 h) and then another 4h later it had still 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

    December 2, 2009 at 12:21 pm

    #1086706

  • RE: Stored Procedures that converts a table's column data type from char to nchar and varchar to nvarchar

    rahulsony111 (12/2/2009)

    if i pass a table name like tablenew1 to the @tablename like 'EXECUTE usp_covertdatatype tablenew1'

    will the select statement selects the tablenew1?

    like 'select altertable tablenew1 alter column column'

    And will it...

    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

    December 2, 2009 at 12:12 pm

    #1086705

Viewing 15 posts - 35,521 through 35,535 (of 49,552 total)