Forum Replies Created

Viewing 15 posts - 38,641 through 38,655 (of 49,552 total)

  • RE: Category Groups in Charts(Reporting services 2005)

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic730180-150-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 5:30 am

    #1005674

  • RE: update table variable

    Does this work?

    update t

    set number = test.number

    FROM @t AS t INNER JOIN test on t.foo=test.foo

    p.s. please in future test the sample code that you give us. There were several syntax...

    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:28 am

    #1005673

  • RE: see this is my view , i want to apply the non clustered index, why because i cant apply the clustered index because there is an aggrigate functions , so i want to minimize this by applying the non clustered index on tables columns , please check the below view and revert back

    What does the view's definition currently look like?

    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:03 am

    #1005667

  • RE: Are the posted questions getting worse?

    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 this is 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

    June 5, 2009 at 3:17 pm

    #1005560

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/5/2009)

    GilaMonster (6/5/2009)

    Lynn Pettis (6/5/2009)

    Here is another OMG moment.

    He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was...

    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 5, 2009 at 3:09 pm

    #1005556

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/5/2009)

    Here is another OMG moment.

    He may have just misunderstood what BoL was. I'd be a little unhappy if I asked a simple question and was told to go...

    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 5, 2009 at 2:58 pm

    #1005550

  • RE: Index fragmentation

    Loner (6/5/2009)

    So if the page count is less than 100, even the fragment in percent is high, I don't have to worry about it?

    1000 pages. Not 100.

    1000 pages is about...

    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 5, 2009 at 2:53 pm

    #1005546

  • RE: Transaction Handling

    ganci.mark (6/5/2009)

    Assuming Full Recovery Mode

    All recovery modes behave the same. Recovery mode affects how long a transaction remains in the log and, in the case of bulk operations, how much...

    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 5, 2009 at 2:51 pm

    #1005544

  • RE: Circular logging a T-Log

    Maint plans are covered in quite a bit of detail in Books Online. Far more than Lynn or I could go into in a reasonable amount of time. If 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

    June 5, 2009 at 2:43 pm

    #1005535

  • RE: SQL Server 2008 Backup

    What specifically do you want to know?

    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 5, 2009 at 2:29 pm

    #1005525

  • RE: Index fragmentation

    Those indexes are tiny. Fragmentation only really becomes a noticable problem on indexes that have more than 1000 pages. On very, very small indexes, the way the first few pages...

    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 5, 2009 at 2:25 pm

    #1005523

  • RE: PAGE_VERIFY CHECKSUM

    btb1977 (6/5/2009)

    but then I read the dreaded Microsoft lie " this may incur a slight performance penalty " Seeing as how i just recently crashed a prod server while...

    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 5, 2009 at 2:22 pm

    #1005522

  • RE: Why does DBREINDEX solve update query hang with high CPU and little or no I/O?

    randall.c.newcomb (6/5/2009)

    Do you recall if DBCC INDEXDEFRAG also updates statistics?

    It does 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

    June 5, 2009 at 12:11 pm

    #1005480

  • RE: error in attaching the databse

    Do you have a backup?

    Try using sp_attach_single_file_db

    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 5, 2009 at 9:24 am

    #1005377

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

    FreeHansje (6/5/2009)

    We have a table with 200+ million rows and growing. This table is so heavily updated that there are no indices placed on it:

    Have you tested and proven...

    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 5, 2009 at 9:23 am

    #1005374

Viewing 15 posts - 38,641 through 38,655 (of 49,552 total)