Forum Replies Created

Viewing 15 posts - 29,626 through 29,640 (of 49,552 total)

  • RE: Backup error on network drive

    Please post new questions in a new thread. Thank you.

    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 31, 2010 at 11:45 pm

    #1244712

  • RE: UPDATE HELP

    That's identical to what you posted a bit earlier?

    GilaMonster (10/31/2010)

    Now, which columns are supposed to be equal for the join? you previously said 'A.snumber and B.snumber', but neither column 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

    October 31, 2010 at 3:59 pm

    #1244679

  • RE: UPDATE HELP

    So?

    If you want a query that will work give us the correct table structure and sample data that matches the problems in the real data. Leave out irrelevant columns 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

    October 31, 2010 at 3:31 pm

    #1244673

  • RE: Are the posted questions getting worse?

    Just noticed that I missed spotting a milestone. Better (a little) late than never

    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 31, 2010 at 3:12 pm

    #1244671

  • RE: Get the FieldName and specified record Value in Comma separated

    Andreas Goldman (10/31/2010)

    CREATE TRIGGER Employee_CaptureDelation

    ON Employee

    AFTER DELETE

    AS

    DECLARE @DeletedRecord VARCHAR(4000)

    SELECT @DeletedRecord = 'ID,' + CAST(ID AS VARCHAR(20)) + '|Name,' + Name + '|salary,' + CAST(salary AS VARCHAR(20))

    FROM DELETED

    INSERT DeletedRecords (TableName, DeletedRecord,...

    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 31, 2010 at 3:06 pm

    #1244669

  • RE: UPDATE HELP

    That doesn't match with queries or data examples that you've given previously in this thread.

    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 31, 2010 at 3:05 pm

    #1244668

  • RE: Get the FieldName and specified record Value in Comma separated

    If you want to stick the entire row into a single column, may I rather suggest XML? There is built in support for converting resultsets to XML and vis versa.

    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 31, 2010 at 2:41 pm

    #1244664

  • RE: UPDATE HELP

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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 31, 2010 at 2:39 pm

    #1244663

  • RE: maintenance plan and how to tell what it does

    Open up the maintenance plans themselves, not the jobs that execute them.

    You'll find them under Management-> Maintenance plans

    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 31, 2010 at 2:20 pm

    #1244660

  • RE: UPDATE HELP

    Is your database case-sensitive?

    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 31, 2010 at 2:18 pm

    #1244659

  • RE: working with multiple dataset withing a table in SSRS

    Please note that this thread is 2 years old.

    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 31, 2010 at 2:15 pm

    #1244658

  • RE: how we will use logshipping in real time email infrastrcture priject

    Have you tried a google search? Have you tried opening Books Online and looking up Log Shipping?

    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 31, 2010 at 3:02 am

    #1244600

  • RE: rebuild in logshipping

    Switch to bulk-logged recovery for the index rebuilds. Log won't grow as big, log backups will be same size

    and/or

    Rebuild only the indexes that need rebuilding. Don't use the maint plan...

    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 31, 2010 at 3:02 am

    #1244599

  • RE: [Microsoft][ODBC SQL Server Driver]Timeout expired

    Without details it's going to be very hard (read near impossible) to do anything other than guess. Really need lock/wait info to have much of a chance if it'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

    October 30, 2010 at 12:11 pm

    #1244559

  • RE: [Microsoft][ODBC SQL Server Driver]Timeout expired

    rob1988 (10/30/2010)

    -Increasing SQL priority

    Please go and set that back to default. It is not recommended that the priority be increased.

    -Increasing Remote query timeout value (its now set to 0,...

    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 30, 2010 at 11:36 am

    #1244556

Viewing 15 posts - 29,626 through 29,640 (of 49,552 total)