Forum Replies Created

Viewing 15 posts - 40,666 through 40,680 (of 49,552 total)

  • RE: Suspect\emergency- could not open FCB for invalid file id 0 ....

    Do you have up-to-date backups of this database?

    Please look in the SQL error log on your production server and look for messages related to this database. There's a reason it's...

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

    #951926

  • RE: Forgot to do RECOVERY on restore of last transaction log.

    Restore Database < DB Name > WITH RECOVERY

    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 2, 2009 at 9:22 am

    #951921

  • RE: case alternative to if in sql

    RBarryYoung (3/2/2009)

    Hmm, I think it's this:

    Needs the else block as well

    CASE x

    When 'YEN' Then 'JPY'

    When 'EURO' Then 'EUR'

    ...

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

    #951908

  • RE: MDF & LDF

    MANU (3/2/2009)

    What do we need to search for in case we manage to open the .mdf file in any HEXEditor?

    Offhand I don't know. I know it's somewhere in the DB's...

    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 2, 2009 at 8:10 am

    #951887

  • RE: Are the posted questions getting worse?

    Alvin Ramard (3/2/2009)

    GilaMonster (3/2/2009)

    *snigger*

    http://www.sqlservercentral.com/Forums/Topic666430-146-1.aspx

    WOW, he got the hint!!!

    It wasn't exactly subtle.

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

    #951880

  • RE: Are the posted questions getting worse?

    *snigger*

    http://www.sqlservercentral.com/Forums/Topic666430-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

    March 2, 2009 at 7:30 am

    #951856

  • RE: Help Performance Tune this Code please

    GSquared (3/2/2009)

    Try dumping the data into a single table, in a test environment, with that index (with the first two reversed, as Gail suggested). See how that performs.

    I'd like...

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

    #951849

  • RE: QA and SP - different resutls

    alstar (3/2/2009)

    so my question is, QA did correct job when was comparing NULL = NULL, and didnt set BasketCost to 0, but SP did as it executed NULL = NULL...

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

    #951843

  • RE: How to pass sql statment to stored procedure?

    ammarghanem921 (3/2/2009)

    More than 300!!

    That's nothing. Last system I worked on (which did use dynamic SQL to reduce procedure count) had over 3000.

    Rather write the procedures. The downsides of dynamic SQL...

    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 2, 2009 at 6:57 am

    #951833

  • RE: QA and SP - different resutls

    alstar (3/2/2009)

    any general thoughts?

    Without seeing the code, no.

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

    #951826

  • RE: How to pass sql statment to stored procedure?

    ammarghanem921 (3/2/2009)

    A lot of them!!!

    How many?

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

    #951824

  • RE: Performance Tuning

    http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-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

    March 2, 2009 at 6:43 am

    #951822

  • RE: MDF & LDF

    Ratheesh.K.Nair (3/2/2009)

    I tried using a Hex editor but I am not able to figure it out.

    There probably aren't more than a handful of people who know the page structure well...

    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 2, 2009 at 6:42 am

    #951821

  • RE: Unable to drop a file with SHRINKFILE and EMPTYFILE option

    How many other files are in the same filegroup as the one you're trying to empty, how big are they and how much space is available in each?

    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 2, 2009 at 6:03 am

    #951795

  • RE: Resolving Deadlocking problems

    Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here if...

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

    #951791

Viewing 15 posts - 40,666 through 40,680 (of 49,552 total)