Forum Replies Created

Viewing 15 posts - 41,371 through 41,385 (of 49,552 total)

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/27/2009)

    I believe it is. There's a company that lets you donate for purchases. I'll get the URL and put it up here

    So you're buying from 2...

    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 27, 2009 at 12:48 pm

    #933462

  • RE: Adding non-c index to large table

    noeld (1/27/2009)

    So you advice still holds, do it at "off-peak" hours.

    Absolutely. A former colleague of mine recently took down a business-critical system by deciding to create an index during peak...

    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 27, 2009 at 12:46 pm

    #933459

  • RE: What are the Party Plans?

    Steve Jones - Editor (1/27/2009)

    We're donating some rainforest, purchasing 1mm sq ft of rainforest as a celebration. That's a nice charitable act I agree with.

    We'll also give away 100 or...

    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 27, 2009 at 10:46 am

    #933377

  • RE: Backup Database and Log options "question"

    Something like that.

    One folder per database, and both database and log backups get time stamps. So, for 2 databases, I'd have something like this:

    DB1\DB1_Full_20090101.bak

    DB1\DB1_200901010800.trn

    DB1\DB1_200901010815.trn

    DB1\DB1_200901010830.trn

    DB1\DB1_200901010845.trn

    DB1\DB1_200901010900.trn

    DB1\DB1_200901010915.trn

    DB1\DB1_200901010930.trn

    DB2\DB2_Full_20080101.bak

    DB2\DB2_200901010800.trn

    DB2\DB2_200901010815.trn

    DB2\DB2_200901010830.trn

    DB2\DB2_200901010845.trn

    DB2\DB2_200901010900.trn

    DB2\DB2_200901010915.trn

    DB2\DB2_200901010930.trn

    Now the maintenance plan can do 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

    January 27, 2009 at 10:34 am

    #933367

  • RE: Adding non-c index to large table

    noeld (1/27/2009)

    It is not the same to try on a desktop without user interaction than on an actively used server 😉

    True, but I'd hope most servers are more powerful than...

    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 27, 2009 at 10:30 am

    #933363

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (1/27/2009)

    I don't mind cut and paste, but if you have me create a table(s), include a drop table(s) at the bottom.

    That's why I use tempDB 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 27, 2009 at 10:20 am

    #933349

  • RE: Urgent HELP ME¡¡¡¡¡¡ Some one

    clperez271172 (1/27/2009)

    , I have a hardship because now I need to know where is the last functional execution of my DTS in my system, but, this I execute myself via...

    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 27, 2009 at 10:14 am

    #933339

  • RE: How to manage mdf and lfd files 4 performance

    John Reid (1/27/2009)

    Nevertheless, just looking at the issue of how to split an existing database into several data files, am I right in thinking that this can only be done...

    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 27, 2009 at 9:59 am

    #933325

  • RE: Are the posted questions getting worse?

    Bob Hovious (1/27/2009)

    One more post towards 1000.... and close to the original topic here. How many people get annoyed by people who cut and paste data rather than...

    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 27, 2009 at 9:50 am

    #933317

  • RE: Backup Database and Log options "question"

    Lee Hart (1/27/2009)

    The way things are generally done here at my work, is the backup file is just manually deleted and a backup is re-run. No biggy...I guess.

    No biggie?

    By...

    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 27, 2009 at 9:48 am

    #933315

  • RE: Urgent HELP ME¡¡¡¡¡¡ Some one

    Steve Jones - Editor (1/27/2009)

    I thought you could configure flat file logs, but I'm not sure how "queryable" they would be with OPENQUERY.

    I'm pretty sure that logs can be configured,...

    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 27, 2009 at 9:47 am

    #933311

  • RE: Adding non-c index to large table

    FNS (1/27/2009)

    :ermm: Any suggestions how long this might take (in hours) so I can prepare for the phonecall of doom (at 3am when the server throws in the towel)

    Unless your...

    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 27, 2009 at 9:40 am

    #933303

  • RE: Adding non-c index to large table

    I believe it will take a shared table lock.

    A noncluster on 50 million shouldn't take too long. It's creating clusters on big tables that slows things down a lot. Do...

    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 27, 2009 at 9:28 am

    #933285

  • RE: Finding out Missing Indexes on tables by srihari nandamuri

    srihari nandamuri (1/27/2009)

    This will generate the Create Index script based on the queries that are executed on the server by checking the columns

    used in equal/inequal /where clause.

    Not a 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

    January 27, 2009 at 9:27 am

    #933282

  • RE: Script all Indexes on all table by srihari nandamuri

    srihari nandamuri (1/27/2009)

    Comments please....

    If you want to submit articles or scripts, please see the "Write for us" link in the menu on the left. That way anything you submit goes...

    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 27, 2009 at 9:10 am

    #933266

Viewing 15 posts - 41,371 through 41,385 (of 49,552 total)