Forum Replies Created

Viewing 15 posts - 40,306 through 40,320 (of 49,571 total)

  • RE: Code Formatting

    I think the string and comment handling needs a little more work

    http://www.sqlservercentral.com/Forums/FindPost678555.aspx

    --here's a single quote within a comment

    select 'String 1', 012

    select 'String 3', 789 -- that's not what I wanted...

    March 18, 2009 at 8:55 am

    #961972

  • RE: Code Formatting

    Steve Jones - Editor (3/17/2009)

    New code formatting has been released on SSC.

    Ooooohhhh..... Nice!

    Jack Corbett (3/17/2009)

    This has been a light day for me posting code. I've mainly added...

    March 18, 2009 at 8:30 am

    #961944

  • RE: EXEC sp_configure 'recovery interval', 90

    mrizabid (3/18/2009)

    Me facing this problem when i m executing particular critearea like date between '2007-08-01' and '2007-08-31'

    What does that have to do with setting the recovery interval?

    March 18, 2009 at 8:30 am

    #961943

  • RE: Best way to set 'READ UNCOMMITTED'

    krypto69 (3/18/2009)

    I have been tasked with making sure a group of stored procedures all have the transaction isolation level to 'READ UNCOMMITED'

    For what reason? Does the person who asked know...

    March 18, 2009 at 8:25 am

    #961933

  • RE: Slow performing select statement on large table

    Matt (3/18/2009)

    I wondered about that but wouldn't it affect access to all tables?

    No. If there's a lock on the messages table it will just affect queries on the messages table....

    March 18, 2009 at 8:16 am

    #961921

  • RE: Index not rebuilding

    shnex (3/18/2009)

    I have some heaps that have lots of pages(90 000) and 99% fragmentation. What should I do with them?

    There's nothing you can do with them. Heaps cannot be...

    March 18, 2009 at 8:14 am

    #961919

  • RE: Full Transaction log

    Your first suggestion for a full tran log is to shrink it. Maybe I'm missing something, but that's completely the opposite of what's needed.

    The log is full, ie, there is...

    March 18, 2009 at 8:14 am

    #961918

  • RE: Are the posted questions getting worse?

    Grant Fritchey (3/18/2009)

    I'm going to hell for this one, I just know it.

    Nah. The dev team need their daily laugh too.

    March 18, 2009 at 8:05 am

    #961906

  • RE: Index not rebuilding

    Double post. Never mind.

    March 18, 2009 at 5:05 am

    #961714

  • RE: Index not rebuilding

    Tim Walker (3/18/2009)

    I suppose you might say that I should check free space per page instead but I think I'd get pretty much the same result.

    Not necessarily. It's very possible...

    March 18, 2009 at 4:57 am

    #961709

  • RE: Slow performing select statement on large table

    There's an index that should be usable for that query. Without the second filter (page index and page size), now many rows are returned?

    Can you post the execution plan (saved...

    March 18, 2009 at 4:49 am

    #961708

  • RE: how can we create Index on view?

    Also note that there's a long list of limitations and restrictions on what may be in an indeed view (check Books Online) and that the first inde created on the...

    March 18, 2009 at 4:36 am

    #961697

  • RE: Slow performing select statement on large table

    Can you post the query?

    March 18, 2009 at 4:33 am

    #961696

  • RE: Index not rebuilding

    Tim Walker (3/18/2009)

    I think there is a good chance that contention for that 3GB will reduce lifetime pages spend in cache. So if working on a 30% limit as suggested,...

    March 18, 2009 at 4:26 am

    #961690

  • RE: Index not rebuilding

    Tim Walker (3/17/2009)

    GilaMonster (3/17/2009)

    The usual rule-of-thumb is 1000 pages to a table/index before you needs to worry about fragmentation.

    This is a common view but I don't agree, I think 64-ish...

    March 18, 2009 at 12:29 am

    #961605

Viewing 15 posts - 40,306 through 40,320 (of 49,571 total)