Forum Replies Created

Viewing 15 posts - 14,656 through 14,670 (of 49,552 total)

  • RE: Killed clustered index creation, running out of space

    Marius.D (1/23/2013)

    For some reason, I thought you need the full space of the table only with ONLINE=ON. It didn't use that much on the test system.

    Smaller table on the test...

    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

    January 23, 2013 at 11:32 pm

    #1580358

  • RE: left join on a table - high executions

    sqldba_newbie (1/23/2013)

    I have a query which is doing a left join a table which shows 25K executions, i think it is executing for each record because the output is also...

    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

    January 23, 2013 at 4:07 pm

    #1580300

  • RE: Killed clustered index creation, running out of space

    Creating an index requires at least the size of the index as free space. Plus there's the sort space if you don't have sort in tempDB on. So to create...

    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

    January 23, 2013 at 4:03 pm

    #1580299

  • RE: How do i replace this left join with NOT IN

    sqldba_newbie (1/23/2013)

    Richard Warr (1/23/2013)

    A NOT EXISTS may be better than a NOT IN

    Something like

    SELECT CONVERT(VARCHAR(4), R.FCde) AS Flty

    FROM Rtns R

    WHERE NOT EXISTS ( ...

    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

    January 23, 2013 at 1:00 pm

    #1580246

  • RE: Production Trace Flags for a Standard Build

    None by default, traceflags are something I evaluate on a case-by-case scenario.

    I'm interested to see where MS recommends 1224, since that can be a little risky in terms of lock...

    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

    January 23, 2013 at 12:54 pm

    #1580243

  • RE: model database transaction log

    sqlfriends (1/23/2013)

    if transaction log backup is full for model, either do a transaction log backup or shrink it.

    Why do people want to shrink a full log?

    If I have a 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

    January 23, 2013 at 11:21 am

    #1580213

  • RE: How do i replace this left join with NOT IN

    These may help:

    http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/

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

    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

    January 23, 2013 at 11:15 am

    #1580210

  • RE: SQL Deadlocks

    Single column nonclustered indexes. Great for when all your queries filter on a single column only. Not great otherwise.

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

    Don't have time to look at the deadlock graph right now.

    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

    January 23, 2013 at 9:22 am

    #1580166

  • RE: sql doubut

    Look up the LEN function in Books Online.

    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

    January 23, 2013 at 9:21 am

    #1580163

  • RE: Can Somebody answer this simply and briefly please?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1410624-391-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

    January 23, 2013 at 9:04 am

    #1580153

  • RE: Can Somebody answer this simply and briefly please?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1410624-391-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

    January 23, 2013 at 9:04 am

    #1580152

  • RE: Can Somebody answer this simply and briefly please?

    Interview question? Exam question?

    So, how would you start?

    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

    January 23, 2013 at 9:03 am

    #1580151

  • RE: Rebuild Info

    Do not create then drop a clustered index. If you want a heap, live with the extent fragmentation. It's far less damaging than logical fragmentation. If you want to put...

    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

    January 23, 2013 at 9:00 am

    #1580147

  • RE: SQL Deadlocks

    That's a whole lot of fairly useless 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

    January 23, 2013 at 8:59 am

    #1580144

  • RE: Rebuild Info

    Is it a heap or an index? Is autoshrink 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

    January 23, 2013 at 7:23 am

    #1580077

Viewing 15 posts - 14,656 through 14,670 (of 49,552 total)