Forum Replies Created

Viewing 15 posts - 36,046 through 36,060 (of 49,552 total)

  • RE: DATABASE BAckup from 2005 exp to sqlserver 2000

    C Schaefer (11/2/2009)

    You CAN export tables from SQL2005 to SQL2000. I just had to do that last week. May or may not give you the results...

    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

    November 3, 2009 at 8:10 am

    #1074289

  • RE: Error after moving system databases

    Is "E:\DBLogs\modellog.ldf" the correct location of the model database log? If not, move the ldf file there.

    Again I ask, how did you move the system databases?

    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

    November 3, 2009 at 8:06 am

    #1074285

  • RE: Error after moving system databases

    Which dbs did you move? Exactly what did you do to move each one?

    Find the SQL error log (it's a text file called ERRORLOG) and post the entire contents.

    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

    November 2, 2009 at 11:35 am

    #1073935

  • RE: ssis and ssrs interview questions

    Once more with feeling....

    Memorising interview questions is not the way to prepare for an interview. A competent interviewer can tell someone who knows the material from someone who's memorised answers...

    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

    November 2, 2009 at 11:28 am

    #1073931

  • RE: Query performace issues and general optimization queries

    Can you post execution plans?

    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

    November 2, 2009 at 10:22 am

    #1073900

  • RE: Are the posted questions getting worse?

    There's about 1 coffee shop per block in this city, plus a couple in the convention center.

    coming to the SSC party tonight?

    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

    November 2, 2009 at 9:15 am

    #1073857

  • RE: How to calculate the 'Fill Factor'.

    There's no easy calculation for an 'optimal' fill factor. Depends on the clustered index key, depends on how fast the clustered index fragments, how much you want to reduce fragmentation,...

    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

    November 2, 2009 at 7:40 am

    #1073807

  • RE: Testing a BAK file

    You can try RESTORE VERIFYONLY. If the backup was done with the CheckSum option and all the database pages had checksums, then if this returns successful the backup will very...

    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

    November 2, 2009 at 7:37 am

    #1073806

  • RE: Filegroup backup assumes point-in-time restore

    You are correct. To do file/filegroup restores you have to have the log backups because, to bring the DB online, all the files/filegroups have to be rolled forward to 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

    November 2, 2009 at 7:35 am

    #1073805

  • RE: Stored Proc that joins based on parameters??

    stephenmbell (11/1/2009)

    So I figured I would write 1 stored procedure to take the place of all of these other stored procs and based on the parameters I send in, 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

    November 1, 2009 at 9:49 pm

    #1073656

  • RE: Are the posted questions getting worse?

    Jack Corbett (11/1/2009)

    I hate traveling!

    Likewise.

    15 min late leaving JHB because of bad weather (hail, rain, lightning and thunder), 30 min late into Paris (and turbulence entire flight).

    2 hours late out...

    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

    November 1, 2009 at 10:13 am

    #1073604

  • RE: DATABASE BAckup from 2005 exp to sqlserver 2000

    Databases can never be downgraded. The internal database version and changes to design of the system tables prevent that

    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

    November 1, 2009 at 7:19 am

    #1073579

  • RE: Looping through the rows of a result set

    Do you just want to check if there is any row that satisfies that condition and do the stuff in the if once, or do you want to do 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

    November 1, 2009 at 7:14 am

    #1073578

  • RE: Check Point

    http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/

    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

    November 1, 2009 at 7:08 am

    #1073577

  • RE: An INSERT EXEC statement cannot be nested.

    Not quite what I meant

    http://scarydba.wordpress.com/2008/08/13/view-vs-table-valued-function-vs-multi-statement-table-valued-function/

    http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/

    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

    October 30, 2009 at 3:17 am

    #1072986

Viewing 15 posts - 36,046 through 36,060 (of 49,552 total)