Forum Replies Created

Viewing 15 posts - 40,546 through 40,560 (of 49,552 total)

  • RE: Triggers

    sam.marsden (3/5/2009)

    is there a way that i can check?

    I'm asking if it's permitted by company/department policies. That's not something that a script can check.

    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 5, 2009 at 8:07 am

    #954061

  • RE: Up Your Value

    mhaskins (3/5/2009)

    The point just was - that you can try to create your own brand, and list your accomplishments for the company, but you need to have a decent boss...

    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 5, 2009 at 8:07 am

    #954060

  • RE: Create Clustered index on composite Key- script difference

    50% fill factor is low. It means that half of each page is empty which means your table will take twice the space it needs and queries will do twice...

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

    #954055

  • RE: Triggers

    DBMail's probably the easiest. I think Jack knows more about it than I do, so I'll defer to him.

    Are you the DBA? If not, can you ask the DBA...

    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 5, 2009 at 7:38 am

    #954025

  • RE: Triggers

    Great. One last thing. How is the email going to be sent? Are you suing DBMail? Do you have a mailing program? Or is there nothing set up at 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

    March 5, 2009 at 7:28 am

    #954014

  • RE: Urgent : Sql server db tuning

    musheik (3/5/2009)

    I checked with java developers, its difficult for them to modify the code in short time. as we are at the verge of release.

    Any thing need to 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

    March 5, 2009 at 7:07 am

    #953996

  • RE: Create Clustered index on composite Key- script difference

    Edit: Misread the question. Nevermind......

    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 5, 2009 at 6:49 am

    #953986

  • RE: prevent compressing of DB files

    Can you move the data and log files elsewhere? Detach the DB, move the files, reattach from a new location.

    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 5, 2009 at 6:48 am

    #953985

  • RE: Urgent : Sql server db tuning

    musheik (3/5/2009)

    I need to insert 200000 records into a table .

    When I insert 200000 records at a time it is taking 13 seconds to insert.

    The same 200000 records if I...

    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 5, 2009 at 6:47 am

    #953983

  • RE: Database recovery

    Can you post the SQL error log from the beginning until that database is online and available?

    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 5, 2009 at 6:24 am

    #953970

  • RE: Profiler states insert has long duration

    I've never seen profiler reporting false durations. You sure there's no blocking in the prod database that could be making the insert wait?

    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 5, 2009 at 6:19 am

    #953965

  • RE: Triggers

    sam.marsden (3/5/2009)

    i am very new at this and im not quite sure i can do what you're saying.

    i didn't create the database, it was created by an external source.

    Sure...

    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 5, 2009 at 6:18 am

    #953964

  • RE: Clustered Indexes on which columns

    Please post the full table definition (as a create table's best) and the most common queries that will run against the table

    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 5, 2009 at 4:35 am

    #953908

  • RE: Decrypt a stored procedure

    Yup. That's correct.

    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 5, 2009 at 2:23 am

    #953856

  • RE: Decrypt a stored procedure

    Search google. You should find some links to products that do that (I don't think any are free)

    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 5, 2009 at 2:05 am

    #953844

Viewing 15 posts - 40,546 through 40,560 (of 49,552 total)