Forum Replies Created

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

  • RE: orphaned tracsaction

    It's not your select that's the problem. You've got some orphaned DTC transactions that are holding locks.

    To get rid of the locks, query sys.dm_os_tran_locks for rows where the requesting session_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

    June 6, 2009 at 1:24 pm

    #1005753

  • RE: What is the use of Filegroups?

    Partial database availability (Enterprise edition only), read-only filegroups.

    You can put files onto different drives, but you cannot specify that a table or index must be created in a specific file,...

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

    #1005741

  • RE: Are the posted questions getting worse?

    Paul White (6/6/2009)

    Understood. Though there may be practical considerations (probably pork related) which mean that removing/changing certain widely-used undocumented features is unlikely in the extreme. No guarantees of...

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

    #1005739

  • RE: Are the posted questions getting worse?

    Jeff Moden (6/6/2009)

    Gail's BOL link doesn't work for me when I paste it into the help URL field. I'm still using 2k5 if that matters.

    It does matter. That link's...

    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 6, 2009 at 9:29 am

    #1005733

  • RE: Are the posted questions getting worse?

    Paul White (6/6/2009)

    Absolutely. I love it when someone brings up the 'if you use undocumented features your wife will leave you' type of argument, for exactly those reasons. ...

    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 6, 2009 at 9:27 am

    #1005732

  • RE: Fastest way to seacrh a non-indexed table?

    FreeHansje (6/6/2009)

    I have suggested indices on the c1-c4 columns, my collegue told me they have removed those indices 6 months ago and so achieved a big performance boost. Maybe...

    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 6, 2009 at 9:22 am

    #1005730

  • RE: Increase the memory of SQL Server Instance

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic730231-146-1.aspx

    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 6, 2009 at 8:22 am

    #1005703

  • RE: update table variable

    mjarsaniya (6/6/2009)

    Next time i will take care for same

    Much appreciated.

    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 6, 2009 at 8:20 am

    #1005702

  • RE: Are the posted questions getting worse?

    Paul White (6/6/2009)

    Having said all that, I do have some sympathy. And not just because of the (presumed) language barrier.

    The requirement to alias a table variable for UPDATE 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

    June 6, 2009 at 8:20 am

    #1005701

  • RE: Are the posted questions getting worse?

    WayneS (6/6/2009)

    You know, it's always those complex T-SQL concepts that trip up so many people.

    Good going Gail!

    I know. Those darned updates are just so hard to understand. :hehe:

    Correct link -...

    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 6, 2009 at 7:16 am

    #1005692

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/5/2009)

    GilaMonster (6/5/2009)

    Lynn Pettis (6/5/2009)

    What I am thinking of doing in the future when I suggest to OP's to read Books Online is to add an additional statement 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 6, 2009 at 7:12 am

    #1005691

  • RE: update table variable

    mjarsaniya (6/6/2009)

    yes but you have created table t not @t....

    I assume you didn't try my code.... If you had and had queried the table variable, you'd have seen it did...

    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 6, 2009 at 6:53 am

    #1005685

  • RE: sql2008: datetime, string "date" comparison......

    Do the values in Enterdate have any times associated? If so, that query won't work as it will only match dates that have midnight as their time. If that 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

    June 6, 2009 at 5:45 am

    #1005678

  • RE: dbcc checkdb command run as a sql agent job?

    Under the job step, go to the Options page and there's a option there to write the job step's output to a file, either overwrite or append.

    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 6, 2009 at 5:34 am

    #1005676

  • RE: What SQL Server Sites do you use?

    SSC and SQLTeam mostly, though far more here than there. Mostly I just watch the corruption-related forum there. On the non-SQL specific also SADeveloper.net (when it's up) and ServerFault.com

    Edit: I...

    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 6, 2009 at 5:33 am

    #1005675

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