Forum Replies Created

Viewing 15 posts - 21,226 through 21,240 (of 49,552 total)

  • RE: Database crash

    chrisians2929 (1/9/2012)

    he just said its not working

    Then you would need to ask him for clarification. 'Not working' is useless as a description of a problem.

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

    #1430335

  • RE: IF Time out in the application what all this to check at sql server level and at database

    There's no magic options or settings. Tune the procedure or query that's causing the timeout (or change the application's timeout setting)

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

    #1430334

  • RE: SQL Clustering 2008 Features?

    http://www.google.com/search?q=new+features+in+SQL+2008+clustering

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

    #1430333

  • RE: Database crash

    chrisians2929 (1/9/2012)

    I got asked a question what happens if the code is correct in all the tables and the networks are up and the db is still not working what...

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

    #1430322

  • RE: Log File writing algorithm

    burtsev (1/9/2012)

    Thank you very much guys, all your advices are very informative, thanks again.

    Just bear in mind that the comment about minimally logged operations, while it applies to your example,...

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

    #1430321

  • RE: in sqlserver2008r2 i just want to create a admin database

    er.sivaganesh (1/8/2012)

    here i just want to create an web site for online discussion

    in that principal will play the role of admin

    in that website...

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

    #1430316

  • RE: Transaction Log full while running SQL Jobs?

    ananda.murugesan (1/8/2012)

    Database setting is recovery model 'SIMPLE', then executed this procedure that failed due to Tlog full.. after that I changed recovery model to 'FULL' then taken two times for...

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

    #1430312

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Jeff Moden (1/8/2012)

    Do you have a convenient link for the "recent changes"?

    Err, no, sorry. I got the rant from my boss and colleague and ran across a few more complaints...

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

    #1430235

  • RE: Microsoft Gold Certified Partner Companies - Horror Stories

    Jeff Moden (1/8/2012)

    Not all Microsoft Gold Certified Partner companies are bad but it seems that the ones that are are really bad and give the rest a terrible black eye.

    Well...

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

    #1430233

  • RE: Today's Random Word!

    SQLRNNR (1/8/2012)

    GilaMonster (1/8/2012)

    SQLRNNR (1/8/2012)

    Revenant (1/8/2012)

    MysteryJimbo (1/8/2012)

    Wireless

    Bluetooth

    Toothless

    Dragon!

    Night Fury

    Cute.

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

    #1430223

  • RE: Today's Random Word!

    SQLRNNR (1/8/2012)

    Revenant (1/8/2012)

    MysteryJimbo (1/8/2012)

    Wireless

    Bluetooth

    Toothless

    Dragon!

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

    #1430220

  • RE: Log File writing algorithm

    burtsev (1/8/2012)

    1. Why SQL Server writes so much data to log file (recovery model is SIMPLE)? How can I reduse volume of data that must be writtent to the log?

    It...

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

    #1430219

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (1/8/2012)

    SQL Kiwi (1/8/2012)

    GilaMonster (1/8/2012)

    Looks ok to me.

    Must be just me then. Perhaps it's a browser cache thing, but I see this:

    Doesn't work here. Select and from 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

    January 8, 2012 at 1:08 pm

    #1430209

  • RE: SQL Help

    You can do that (which will pretty much scan the table) or 5 separate updates (as I showed), but there's no real other alternatives

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

    #1430204

  • RE: Are the posted questions getting worse?

    Revenant (1/8/2012)

    GilaMonster (1/8/2012)

    . . . the same person who upon been told that a particular piece of work would take no less than 15 days, scheduled it for 3 calendar...

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

    #1430198

Viewing 15 posts - 21,226 through 21,240 (of 49,552 total)