Forum Replies Created

Viewing 15 posts - 36,871 through 36,885 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/22/2009)

    Lynn tries to work with everyone. 😉

    Aren't there a few that have made even your personal black-list?

    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

    August 22, 2009 at 12:38 pm

    #1043295

  • RE: Index on a View

    If there's no single unique column in any of the base tables, and full text requires that there is one, then you're going to have to find another way 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

    August 22, 2009 at 12:33 pm

    #1043294

  • RE: Index on a View

    Is there absolutely no column or set of columns in the underlying tables that are unique?

    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

    August 22, 2009 at 8:21 am

    #1043272

  • RE: 70-432 Study Materials

    I wrote 432 while it was in beta, just used Books Online to study and MS's exam outline to see what I needed to study. Worked for me, won't...

    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

    August 22, 2009 at 8:20 am

    #1043271

  • RE: Are the posted questions getting worse?

    Lynn answers people that I won't. I answer people that Jeff won't. Jeff answers ones that I won't, etc.

    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

    August 22, 2009 at 2:55 am

    #1043246

  • RE: Are the posted questions getting worse?

    Ian Scarlett (8/22/2009)

    How about posting a list of "stroppy" posters?

    http://www.sqlservercentral.com/Forums/Topic691132-61-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

    August 22, 2009 at 2:35 am

    #1043243

  • RE: 70-432 Study Materials

    kruti (8/22/2009)

    Can you have any dumps for 70-432? I have found one here.

    http://www.**************/70-432.htm

    Braindumps are cheating. They are actual questions from the exams, disclosed publically in violation of the NDA on...

    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

    August 22, 2009 at 2:28 am

    #1043242

  • RE: Is it possible that I can attach to a estranged .MDF?

    Maybe.

    See - http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

    Restoring from backup is the first prize if the mdf won't attach cleanly.

    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

    August 22, 2009 at 2:26 am

    #1043241

  • RE: Deleted table log - Need help.

    You may be able to find details in the default trace. It's a trace that's always running when SQL is running. Thing it, it's limited in what it stores, 5...

    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

    August 22, 2009 at 2:14 am

    #1043239

  • RE: Transaction log backup question

    ta.bu.shi.da.yu (8/21/2009)

    Turns out what I'm missing is that under the simple recovery model all you need to do is a checkpoint, then a shrink operation - which I just read...

    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

    August 22, 2009 at 2:08 am

    #1043238

  • RE: Transaction log backup question

    ta.bu.shi.da.yu (8/21/2009)

    Perhaps I'm missing something, but if I'm running the database under the simple recovery model, then why wouldn't I just be able to truncate away the inactive portions 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

    August 22, 2009 at 2:06 am

    #1043237

  • RE: Maintenance plan Updatestatistics

    Mani (8/10/2009)

    I'm running the UpdateStatistics job weekly and its taking 40 mins. Does this weekly update statistics enough?

    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

    August 22, 2009 at 1:45 am

    #1043236

  • RE: All the sudden, everything is recompiling.

    Ok, without AWE or /3GB SQL will never be able to reach that 3GB max memory. On 32 bit, without either AWE or /3GB, max memory per process is 2GB.

    Consider...

    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

    August 22, 2009 at 1:45 am

    #1043234

  • RE: Temp Table 'vs' Table Variable 'vs' CTE.

    TheSQLGuru (8/21/2009)

    If you join to a table on 1 (or a few) values and you hit 90% of the rows in the join table do you really want to do...

    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

    August 21, 2009 at 12:48 pm

    #1043073

  • RE: Optimization job

    SQL 2000 or SQL 2005? What edition?

    Go to the maintenance plan and have a look at what it does and then describe what the plan is doing. The command 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

    August 21, 2009 at 12:47 pm

    #1043071

Viewing 15 posts - 36,871 through 36,885 (of 49,552 total)