Forum Replies Created

Viewing 15 posts - 9,481 through 9,495 (of 49,552 total)

  • RE: IT Skills Shortage? No, Just Looking in the wrong place

    jtallent-840140 (3/31/2014)

    So yes, Phil's statement in the article reveals a degree of disrespect for the developer profession in general and could have been left out or worded more tactfully and...

    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

    March 31, 2014 at 2:19 pm

    #1701792

  • RE: X in Technology

    Steve Jones - SSC Editor (3/31/2014)

    There are entirely too many jerks in this business that still think women aren't as competent, and don't deserve the same opportunities, regardless of 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

    March 31, 2014 at 10:18 am

    #1701683

  • RE: TEMPDB issue

    What do you mean by 'not clearing space'?

    If you mean the file isn't getting smaller, not it won't and it shouldn't. It sounds like you don't have enough space 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

    March 31, 2014 at 9:53 am

    #1701668

  • RE: TEMPDB issue

    Then I suspect that the resolution to this problem will involve locating another drive for TempDB or expanding the current one.

    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

    March 31, 2014 at 9:42 am

    #1701661

  • RE: Escaping a close bracket ')' in an EXEC string.

    That script runs without error for me. Are you sure that's the exact statement which is throwing the error?

    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

    March 31, 2014 at 8:27 am

    #1701607

  • RE: Escaping a close bracket ')' in an EXEC string.

    The arguments to CharIndex need to be in '', so there's no need to escape them. Anything inside '' is treated as a string literal. Can you post the code?...

    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

    March 31, 2014 at 7:54 am

    #1701585

  • RE: Lost tables - DBCC checkdb, allow_data_loss

    Corruption in the system tables is severe. Restoring that month old backup may be a better approach than repairing.

    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

    March 31, 2014 at 7:44 am

    #1701578

  • RE: Lost tables - DBCC checkdb, allow_data_loss

    You ran CheckDB with repair_allow_data_loss, and it lost data. That's what the command does.

    The only way to recover is if you had backups from before the corruption occurred.

    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

    March 31, 2014 at 7:19 am

    #1701571

  • RE: Shrinking databases, internals, trick and tips

    Yes, shrink is incredibly slow in some cases. There aren't really any tricks to it. You can shrink in chunks, you can stop the shrink at any time, it doesn'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

    March 31, 2014 at 4:07 am

    #1701523

  • RE: Can you determine an estimated execute time of an SQL statement

    Short of running them in a similar environment and timing them, no.

    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

    March 31, 2014 at 3:45 am

    #1701518

  • RE: IT Skills Shortage? No, Just Looking in the wrong place

    Cody K (3/31/2014)

    Funnily enough I don't see it that way. And I feel that those people love their jobs.

    I would disagree. If you love your job (which involves supporting 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

    March 31, 2014 at 3:11 am

    #1701514

  • RE: IT Skills Shortage? No, Just Looking in the wrong place

    Cody K (3/31/2014)

    I do knows some DBAs that fall into your criteria of learning a lot of technical minutiae quickly and even retain it. That's a cool skill to have....

    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

    March 31, 2014 at 2:34 am

    #1701505

  • RE: Like operator - Query performance issue

    Partitioning is unlikely to help at all.

    Unless you can add some SARGable predicates (predicates where SQL can use indexes to reduce the rows it has to read), there's probably 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

    March 31, 2014 at 2:27 am

    #1701504

  • RE: DELETE FIRST 1000 ROWS

    Lynn Pettis (3/29/2014)

    DELETE TOP (1000) FROM MyTable ORDER BY yourOrderingColumn

    Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near the keyword 'ORDER'.

    Amusingly enough, while updates and deletes can take 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

    March 31, 2014 at 2:15 am

    #1701500

  • RE: SQl Server doe not use the INCLUDE columns of an index

    The missing indexes are suggestions, not directives. If you try one out and find that it doesn't help the query, remove the index.

    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

    March 31, 2014 at 2:10 am

    #1701499

Viewing 15 posts - 9,481 through 9,495 (of 49,552 total)