Forum Replies Created

Viewing 15 posts - 24,976 through 24,990 (of 49,552 total)

  • RE: Speed up Index Creation time

    kramaswamy (7/11/2011)

    Also doesn't really explain my followup question as to whether the other columns being included as included columns increases performance when doing JOIN operations with columns that have their...

    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

    July 11, 2011 at 9:06 am

    #1351146

  • RE: Speed up Index Creation time

    This may help answer that:

    http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

    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

    July 11, 2011 at 8:53 am

    #1351130

  • RE: Why Index Scan instead of Index Seek

    Edit: Nevermind

    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

    July 11, 2011 at 8:48 am

    #1351124

  • RE: Database Maint Question - ShrinkDatabase before or after Turncate Log

    kevinsql7 (7/11/2011)

    However, I noticed my log file is larger after the ShrinkDatabase Command. Should I rearrange the commands and put the ShrinkDatabase Command before the Truncate Log Command? Please...

    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

    July 11, 2011 at 8:26 am

    #1351106

  • RE: Why Index Scan instead of Index Seek

    Explained here: http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/

    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

    July 11, 2011 at 8:24 am

    #1351104

  • RE: Speed up Index Creation time

    kramaswamy (7/11/2011)

    Pretty broad question, but does anyone have any tips on how I can improve the speed of the creation of indexes?

    Faster disks, more memory. Can't think of much else.

    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

    July 11, 2011 at 8:23 am

    #1351103

  • RE: SQL Server Log Full From Index Rebuild Maintenance Job

    btw, why do both databases have 2 log files?

    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

    July 11, 2011 at 3:28 am

    #1350962

  • RE: SQL Server Log Full From Index Rebuild Maintenance Job

    As I said, it could simply have been that the autogrow wasn't fast enough. Grow the logs, see if that helps (and make sure you don't have autoshrink or manual...

    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

    July 11, 2011 at 3:13 am

    #1350950

  • RE: Members of BUILTIN\Administrators not automatically members sysadmin?

    mmcginty (7/11/2011)

    So am I to understand that SQL treats BUILTIN\Administrators as a special case, and doesn't allow its group members to inherit SQL roles of which the group is a...

    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

    July 11, 2011 at 3:00 am

    #1350938

  • RE: SQL Server Log Full From Index Rebuild Maintenance Job

    Rhox (7/11/2011)

    GilaMonster (7/11/2011)

    It can still happen. The autogrow can timeout (check the log) or it can take too long and the transaction still fail.

    Where can I see that the log...

    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

    July 11, 2011 at 2:34 am

    #1350928

  • RE: SQL Server Log Full From Index Rebuild Maintenance Job

    It can still happen. The autogrow can timeout (check the log) or it can take too long and the transaction still fail.

    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

    July 11, 2011 at 2:24 am

    #1350924

  • RE: SQL Server Log Full From Index Rebuild Maintenance Job

    In full recovery index rebuilds are fully logged and require easily 1.2x the size of the index being rebuilt in log space.

    If you can accept the minor risks associated, switch...

    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

    July 11, 2011 at 2:08 am

    #1350919

  • RE: Select statement help to speed it up

    Please post the execution plan from the larger resultset. Can't make any useful performance decisions on 10 rows.

    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

    July 11, 2011 at 2:03 am

    #1350918

  • RE: SQLServer licensing and replication

    That setup needs an Enterprise licence for the publisher and a Standard licence for the subscriber.

    Do double-check that with MS or your licence solution provider.

    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

    July 11, 2011 at 1:59 am

    #1350916

  • RE: backup timing out on log file

    I'm not a full text expert (never even used it), but it does look like a potential cause. Maybe start another thread about your full text problem with a title...

    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

    July 11, 2011 at 1:53 am

    #1350914

Viewing 15 posts - 24,976 through 24,990 (of 49,552 total)