Forum Replies Created

Viewing 15 posts - 27,346 through 27,360 (of 49,552 total)

  • RE: What steps to follow, If there is an open transaction on Database server?

    Jeff Moden (3/15/2011)

    Ummm... they actually forgot to mention taking the offending user out for a nice pork chop dinner. 😛

    Maybe, maybe not.

    There's nothing intrinsically wrong with an open transaction. If...

    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 15, 2011 at 11:49 pm

    #1299219

  • RE: Are the posted questions getting worse?

    SQLkiwi (3/15/2011)

    GilaMonster (3/15/2011)

    Trying to figure if I managed to not insult anyone. Developers twice, DBAs once, Robert Davis once (why is an MCM asking questions in a presentation?), Microsoft once,...

    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 15, 2011 at 11:48 pm

    #1299218

  • RE: corrupted mdf file

    Irreparable, nothing that can be done. The file header is damaged, SQL cannot open that file. Since it's the primary file of the database, SQL can't open the DB at...

    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 15, 2011 at 4:32 pm

    #1299161

  • RE: Are the posted questions getting worse?

    WayneS (3/15/2011)

    So Gail - how did your presentation go? I'm sorry that I couldn't see it.

    Awesome. Great fun. Timing went perfectly too (for once)

    Trying to figure if I managed to...

    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 15, 2011 at 4:26 pm

    #1299160

  • RE: False errors causing problems

    Edit -> Intellisense -> Refresh Local Cache (or Ctrl-Shift-R)

    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 15, 2011 at 2:37 pm

    #1299123

  • RE: Splitting of data files

    What's your reason for spitting the 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

    March 15, 2011 at 2:34 pm

    #1299121

  • RE: If Exists () Update table column errors

    IF 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

    March 15, 2011 at 1:51 pm

    #1299092

  • RE: Updating column in a table with it's own column with Int to Datetime conversion

    What's the logic for the new date column? How does it relate to the other columns?

    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 15, 2011 at 1:44 pm

    #1299088

  • RE: Are the posted questions getting worse?

    jcrawf02 (3/15/2011)

    Offline? What's that?

    That which some of us in less developed parts of the world are a lot of the time... 😉

    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 15, 2011 at 1:42 pm

    #1299087

  • RE: Are the posted questions getting worse?

    Let me clarify. Streaming as in windows media player streaming of a video. It should work fine on any reasonable internet connection.

    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 15, 2011 at 12:02 pm

    #1299039

  • RE: Are the posted questions getting worse?

    WayneS (3/15/2011)

    GilaMonster (3/15/2011)

    WayneS (3/15/2011)

    Does anyone know if we'll be able to download them later on?

    Streaming, not download. Something an issue with but PASS doesn't seem to be willing to change

    Darn....

    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 15, 2011 at 11:34 am

    #1299023

  • RE: Hash Join Pegging CPU

    Smaller data volume?

    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 15, 2011 at 11:32 am

    #1299020

  • RE: Are the posted questions getting worse?

    WayneS (3/15/2011)

    Does anyone know if we'll be able to download them later on?

    Streaming, not download. Something an issue with but PASS doesn't seem to be willing to change

    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 15, 2011 at 11:20 am

    #1299007

  • RE: Hash Join Pegging CPU

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    If there are nulls around (or the column is nullable), consider not exists rather than not in.

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

    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 15, 2011 at 11:13 am

    #1299004

  • RE: Trace Flags Deadlocks - Am i missing something?

    Only until the next restart.

    If you want it permanent, it needs to be added as a traceflag

    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 15, 2011 at 11:02 am

    #1298995

Viewing 15 posts - 27,346 through 27,360 (of 49,552 total)