Forum Replies Created

Viewing 15 posts - 37,921 through 37,935 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Florian Reischl (7/2/2009)

    Lynn Pettis (7/2/2009)

    I realize the OP didn't really provide everything that we really need to help, but this actually answers the OP's question?? :sick:

    Smells like a cross post:

    http://www.sqlservercentral.com/Forums/Topic746129-338-1.aspx

    Except...

    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

    July 2, 2009 at 12:10 pm

    #1019382

  • RE: select query

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    July 2, 2009 at 11:55 am

    #1019365

  • RE: How to bypass duplicate records ?

    All we're asking for is the definitions of all tables involved (as CREATE TABLE statements), sample data for those tables (as insert statements), an example of the results you want,...

    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

    July 2, 2009 at 11:23 am

    #1019346

  • RE: Insert Query

    WayneS (7/2/2009)

    The only time a new row will be placed in any kind of order is if you have a clustered index on the table. Then it will place 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

    July 2, 2009 at 11:05 am

    #1019338

  • RE: Need help on failed queries logging.

    SpyCraft (7/2/2009)

    We were displaying error message in such cases. But user ignored the error and continued using the application ..sounds very odd but true..

    Hardly unusual. Especially if the error was...

    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

    July 2, 2009 at 10:55 am

    #1019333

  • RE: How to bypass duplicate records ?

    ifila, we want to help, really. But the sample data doesn't match the table definition. The desired output doesn't match the table definition. Based on that, I cannot write a...

    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

    July 2, 2009 at 10:51 am

    #1019328

  • RE: Reindex works temporarily; need to do over and over

    Does this help? http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    Were the indexes actually fragmented? If not, if may be stale statistics. If that's the case then am update statistics should fix the problem next 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

    July 2, 2009 at 10:49 am

    #1019326

  • RE: Need help on failed queries logging.

    You should have some form of error handling (and logging) in either the procedure or in the front end app.

    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

    July 2, 2009 at 10:45 am

    #1019318

  • RE: How to bypass duplicate records ?

    ifila (7/2/2009)

    I will grab the first record - in this case 'livelink, java'

    The one with the lowest ID?

    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

    July 2, 2009 at 10:43 am

    #1019316

  • RE: SQL server 2000 to 2005 ? rebuild indexs?

    river (7/2/2009)

    The first question is :

    Do i realy need to update statistics in the script? my database as the option auto_update statistics ON.

    Yes. If it wasn't necessary I wouldn't...

    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

    July 2, 2009 at 10:40 am

    #1019311

  • RE: How to bypass duplicate records ?

    Your sample data doesn't fit in the table specified. Do you mean this as sample data, or should the table have more columns?

    Insert into resumein (OriginalResume, OriginalEmail)

    Values ('java',' jsmith@gmail.com')

    Insert...

    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

    July 2, 2009 at 10:13 am

    #1019291

  • RE: precautions to be taken

    Why are you restoring a development database to 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

    July 2, 2009 at 9:41 am

    #1019260

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/2/2009)

    Hey Jeff, you have a spare high-velocity pork chop launcher you can send me?? I think I'm going to lose my halo soon and I might as...

    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

    July 2, 2009 at 9:40 am

    #1019257

  • RE: /3GB Switch

    Enterprise edition refers to SQL, not to the OS, but I too think that's Server 2008. SQL Enterprise edition only runs on Server 2003 and Server 2008. The editions 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

    July 2, 2009 at 9:36 am

    #1019255

  • RE: How to bypass duplicate records ?

    From that I'd conclude you have more then one resume for some of the emails. In those cases, which resume do you want back?

    Please post table definitions, sample data and...

    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

    July 2, 2009 at 9:30 am

    #1019247

Viewing 15 posts - 37,921 through 37,935 (of 49,552 total)