Forum Replies Created

Viewing 15 posts - 39,661 through 39,675 (of 49,552 total)

  • RE: Operating system Error 112

    magarity kerns (4/18/2009)

    Look. the straight copy all from the script doesn't have any kind of sorting or anything to make a lot of overhead - do you really have production...

    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

    April 18, 2009 at 4:47 am

    #980151

  • RE: Compatibility level

    Works fine for me.

    Exactly what command are you typing? (note that the <Database name> is just a placeholder for the name of the DB that you're changing.)

    What does 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

    April 18, 2009 at 4:08 am

    #980146

  • RE: VBScript help

    SQL Server doesn't use VBScript.

    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

    April 18, 2009 at 4:00 am

    #980144

  • RE: use of VBScript in sqlserver

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic699960-146-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

    April 18, 2009 at 4:00 am

    #980142

  • RE: Compatibility level

    Sorry, left out an =

    ALTER DATABASE <database_name >

    SET COMPATIBILITY_LEVEL = 90

    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

    April 18, 2009 at 3:52 am

    #980141

  • RE: Operating system Error 112

    magarity (4/18/2009)

    1. Detach and copy the original mdf and lfd files. This works on my SQL Express between NTFS HDD and FAT32 USB. Is there something that prevents...

    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

    April 18, 2009 at 3:51 am

    #980140

  • RE: interview questions

    paul.starr (4/17/2009)

    any info on really good interview questions for a sql server dba?

    Memorising questions and answers is not going to help you pass an interview. You need to be familiar...

    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

    April 18, 2009 at 2:34 am

    #980136

  • RE: Who deleted the rows?

    From Books Online:

    sys.dm_exec_plan_attributes

    User_ID

    Value of -2 indicates that the batch submitted does not depend on implicit name resolution and can be shared among different users. This is the preferred method....

    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

    April 18, 2009 at 2:33 am

    #980135

  • RE: Compatibility level

    ALTER DATABASE <database_name >

    SET COMPATIBILITY_LEVEL 90

    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

    April 18, 2009 at 2:29 am

    #980134

  • RE: interview questions

    Alvin Ramard (4/17/2009)

    Lynn Pettis (4/17/2009)

    Actually Alvin, your answer is perfect. It's what you are doing behind the locked doors with the phone off the hook that is important. ...

    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

    April 18, 2009 at 2:29 am

    #980133

  • RE: About 70-431 preparation

    naimish_2005 (4/17/2009)

    I have only downloaded ebook only from a ebook sharing website. It doesnt include the simulator.

    So go any buy it. It's well worth the small amount of...

    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

    April 18, 2009 at 2:28 am

    #980132

  • RE: Truncate Log On Checkpoint versus SIMPLE recovery model

    Set them all to whatever the default is (Books online should tell you that)

    From SQL 2000 onwards you should just be using the recovery models (full, bulk logged and simple)...

    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

    April 18, 2009 at 2:23 am

    #980131

  • RE: query special for totals

    SQL 2000, SQL 2005 or SQL 2008?

    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

    April 18, 2009 at 2:19 am

    #980130

  • RE: Truncate Log On Checkpoint versus SIMPLE recovery model

    Ignore that setting and don't mess with it. It's there only for backward compatibility (SQL 7 and earlier I think), it is deprecated, it will be removed in future versions.

    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

    April 17, 2009 at 2:36 pm

    #979978

  • RE: Need prepartion guide for certification 70-341

    I would suggest that you buy the Self-paced training kit from MS Press. It's quite a good coverage of the exam topics.

    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

    April 17, 2009 at 2:28 pm

    #979972

Viewing 15 posts - 39,661 through 39,675 (of 49,552 total)