Forum Replies Created

Viewing 15 posts - 29,986 through 30,000 (of 49,552 total)

  • RE: DBCC issue

    WayneS (10/13/2010)

    If so, you might want to check out these links (NOTE: the methods described are NOT supported by Microsoft!!!):

    TechEd Demo: Using the SQL 2005 Dedicated Admin Connection to fix...

    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 14, 2010 at 2:34 am

    #1236677

  • RE: DBCC issue

    ps. (10/13/2010)

    Are these non-repariable issues? i have backups but i wanted to be sure if this can be resolved without restore. this is production box.

    They're repairable, but not 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

    October 14, 2010 at 2:32 am

    #1236675

  • RE: backup restore full recovery model sql 2005

    Please read through this - Managing Transaction Logs[/url]

    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 14, 2010 at 2:32 am

    #1236674

  • RE: Fibre Channel vs NFS for Data and Log files

    If that's the scenario (I suspected that's what the OP meant, but wanted confirmation from him) it's not a case of which is best, it's a case of which 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 14, 2010 at 2:23 am

    #1236672

  • RE: better than not in

    As .sqlplan files please. Most of the information I'm interests in is not in that text.

    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    Edit: From a glance at what you did post, your indexes may need work....

    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 13, 2010 at 1:20 pm

    #1236472

  • RE: Fibre Channel vs NFS for Data and Log files

    NFS?

    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 13, 2010 at 1:16 pm

    #1236469

  • RE: better than not in

    Generally it's the other way around.

    http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

    Can you post exec plans of the join and the not exists? Am curious.

    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 13, 2010 at 1:14 pm

    #1236467

  • RE: better than not in

    timscronin (10/13/2010)

    I went from not in to left outer join, went from 87 seconds to 2 seconds

    WEEEEEEEEHHHHHHHHHHHHHHHHHHHHHEEEEEEEEEEEEEEE

    Great, now switch it to the Not Exists that Ninja showed you as 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

    October 13, 2010 at 12:44 pm

    #1236437

  • RE: Are the posted questions getting worse?

    Alvin Ramard (10/13/2010)

    GilaMonster (10/13/2010)

    Not from here, but how's this one:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151492

    Background is that he mailed me twice within 10 min, subject line 'Answer this' and just a link to that thread.

    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

    October 13, 2010 at 12:20 pm

    #1236417

  • RE: Are the posted questions getting worse?

    Not from here, but how's this one:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=151492

    Background is that he mailed me twice within 10 min, subject line 'Answer this' and just a link to that 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 13, 2010 at 11:49 am

    #1236396

  • RE: Memory Usage of SQL Server

    NSzczepanski-234589 (10/13/2010)

    I'm not using any tool as I am assuming that SQL is allocating all the memory.

    Don't assume. Measure.

    Perfmon is the tool of choice here, don't use Task Manager.

    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 13, 2010 at 11:43 am

    #1236392

  • RE: better than not in

    Might be worth a read: http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

    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 13, 2010 at 11:22 am

    #1236379

  • RE: Are the posted questions getting worse?

    WayneS (10/13/2010)

    I got all of them on sqlblogs.com, and a few others, but I know I'm still missing a lot.

    http://sankarreddy.com/2010/10/invitation-to-participate-in-t-sql-tuesday-11-misconceptions-in-sql-server/

    Start reading....

    They're all linked in the comments of that blog...

    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 13, 2010 at 7:26 am

    #1236181

  • RE: Doing a FULL backup causes my Transaction Log to grow to 10GB!

    SwayneBell (10/13/2010)

    I'm glad to hear that. I was thinking specifically about the number of times you've asked if they had a backup and been told no. I've often thought 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

    October 13, 2010 at 7:21 am

    #1236178

  • RE: large query shows 54M read on 200M table with only 568 results returned

    Oh, and on that nolock....

    http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.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

    October 13, 2010 at 7:02 am

    #1236160

Viewing 15 posts - 29,986 through 30,000 (of 49,552 total)