Forum Replies Created

Viewing 15 posts - 18,211 through 18,225 (of 49,552 total)

  • RE: can we get this guy banned from the forums?????

    mtassin (6/7/2012)

    GilaMonster (6/7/2012)

    mtassin (6/7/2012)

    Jeff Moden (6/5/2012)

    As a side bar, anyone who writes code as well formed as Cadavre did, even though it was a loop, has already caught my attention....

    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 7, 2012 at 7:55 am

    #1498179

  • RE: Transaction log backups ran during a full backup.

    If the log backup finished before the full, it's probably not necessary so you can start with the first log backup that finished after the full backup finished. If SQL...

    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 7, 2012 at 7:49 am

    #1498175

  • RE: can we get this guy banned from the forums?????

    mtassin (6/7/2012)

    Jeff Moden (6/5/2012)

    As a side bar, anyone who writes code as well formed as Cadavre did, even though it was a loop, has already caught my attention. I...

    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 7, 2012 at 7:40 am

    #1498166

  • RE: can we get this guy banned from the forums?????

    mtassin (6/7/2012)

    FizzBuzz was invented by IBM I believe to test your ability to develop.

    IBM?? Not quite.

    This is where it started as a programmer's interview question.

    http://imranontech.com/2007/01/24/using-fizzbuzz-to-find-developers-who-grok-coding/

    It's based on a UK...

    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 7, 2012 at 7:37 am

    #1498163

  • RE: Some one devloper update a column in a table, how to I find out who updated?

    Unless you had some form of auditing in place, you don'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

    June 7, 2012 at 7:30 am

    #1498154

  • RE: Issue reading Lob data in SQL Server 2008R2

    You're running in read uncommitted isolation level?

    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 7, 2012 at 6:53 am

    #1498124

  • RE: changing recovery model on production DB

    No considerations in changing it in use.

    So the business is quite happy with potentially losing up to 24 hours of data in the case of a disaster?

    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 7, 2012 at 6:36 am

    #1498106

  • RE: MDF and LDF locations

    jansub07 (6/7/2012)

    locations means different drives but same physical disk like c:\-MDF, D:\-LDF...How the performance exhibit difference..

    Different partitions of the same drive? No advantage (performance or recovery) whatsoever.

    That said, don't 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

    June 7, 2012 at 3:29 am

    #1498050

  • RE: SQL Process Utilization: 1%. System Idle: 96%

    Call Customer Support Services (CSS)

    No, disabled named pipes is not going to cause shared memory connection failures.

    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 7, 2012 at 2:14 am

    #1498033

  • RE: MDF and LDF locations

    Depends on what those different locations are.

    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 7, 2012 at 1:36 am

    #1498019

  • RE: Database Shrinking

    Yes and yes. Shrinking a DB is not recommended and should only be done if there's been some huge archive or delete or data.

    Shrinking causes massive fragmentation and will just...

    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 7, 2012 at 1:36 am

    #1498018

  • RE: "There is insufficient system memory in resource pool 'internal' to run this query" error message

    deep_kkumar (6/6/2012)

    GilaMonster (6/6/2012)

    Every single query you run fails with that message?

    YES.

    Even SELECT * FROM (VALUES (1)) sub(a) ?

    Select @@version?

    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, 2012 at 3:12 pm

    #1497926

  • RE: "There is insufficient system memory in resource pool 'internal' to run this query" error message

    Every single query you run fails with that message?

    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, 2012 at 2:50 pm

    #1497916

  • RE: "There is insufficient system memory in resource pool 'internal' to run this query" error message

    What's the query? (btw, this has to do with workspace memory grants, not necessarily the available buffer pool)

    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, 2012 at 2:42 pm

    #1497911

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (6/6/2012)

    I suspect bank charges in SA are more like those in the UK or Spain than those in the USA.

    Very much so. I can set automatic transfers...

    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, 2012 at 1:57 pm

    #1497885

Viewing 15 posts - 18,211 through 18,225 (of 49,552 total)