Forum Replies Created

Viewing 15 posts - 37,141 through 37,155 (of 49,552 total)

  • RE: Twenty tips to write a good stored procedure

    Lynn Pettis (8/10/2009)

    mtassin (8/10/2009)

    I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as she wrote this...

    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

    August 11, 2009 at 8:21 am

    #1037460

  • RE: RTM version

    TECHBABU (8/11/2009)

    From the above understood it is Enterprise Edition not evaluation edition.

    Yup.

    I'd still suggest applying SP3 to it when you have a maintenance window.

    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

    August 11, 2009 at 5:43 am

    #1037331

  • RE: dbcc showcontig shows an unexisting index

    Index 255 is the table's LOB data (text, ntext, image, varchar(max), nvarchar(max), varbinary(max)). It's not a real index.

    p.s. since you're on 2005, perhaps start using sys.dm_db_index_physical_stats, ALTER INDEX ... REBUILD...

    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

    August 11, 2009 at 5:30 am

    #1037326

  • RE: SQL data recovery

    akm_1k (8/11/2009)

    can i recover data which is deleted.

    Restore a backup taken before the data was deleted.

    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

    August 11, 2009 at 5:23 am

    #1037324

  • RE: RTM version

    RTM means 'Release to Manufacturing' (or 'release to market'). It's the first release of a product pre service pack or patch.

    One of our clients is in Microsoft SQL Server 2005...

    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

    August 11, 2009 at 5:22 am

    #1037323

  • RE: just for knowledge pupose

    They'll be the same. As part of the parsing/algebratisation that SQL does, IN with a list of values is converted to OR. Easy to test for yourself, write a query...

    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

    August 11, 2009 at 2:17 am

    #1037278

  • RE: stop increasing Log file db_log.ldf

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic768408-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

    August 11, 2009 at 2:14 am

    #1037277

  • RE: stop increasing Log file db_log.ldf

    What recovery model is the database in? Are log backups been done? What's the recovery requirements for this database should something fail (lose a day's daya, lost 5 minutes data,...

    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

    August 11, 2009 at 1:55 am

    #1037276

  • RE: Twenty tips to write a good stored procedure

    Grant Fritchey (8/10/2009)

    Where is the author to address the information? Please. This isn't, nor should it be, a public lynching. Your peers have raised serious questions about the work...

    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

    August 11, 2009 at 1:41 am

    #1037275

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (8/11/2009)

    Barry is leading a new wave...

    A boring one.... 😉

    Now where's that pic of Qui-gon I had lying around.....

    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

    August 11, 2009 at 1:15 am

    #1037262

  • RE: Twenty tips to write a good stored procedure

    Paul White (8/10/2009)

    ...unless a RECOMPILE hint is added, in which case the number of rows is available to the optimizer. The deficiency is in the lack of distribution statistics....

    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

    August 11, 2009 at 1:12 am

    #1037259

  • RE: how to tuning procedures in database tuning advisor

    Tuning advisor is used to get recommendations for indexes. It doesn't offer suggestions on rewriting code.

    You can either submit a single query to DTA, or take a trace (a representative...

    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

    August 11, 2009 at 1:05 am

    #1037254

  • RE: A Story of the Deleted Transaction Log

    Hemantjemmy (8/11/2009)

    good story.

    One more lesson to be learned from above story to add the Maintenance Job of Truncating Transactional log files regularly so that you dont run out 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

    August 11, 2009 at 1:01 am

    #1037251

  • RE: error 'An inconsistency was detected during an internal operation in database '

    You've got SQL 2005 RTM there (unpatched). I would suggest that you apply service pack 3 as soon as you can. Once that's applied you shouldn't see these errors any...

    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

    August 11, 2009 at 12:45 am

    #1037247

  • RE: Twenty tips to write a good stored procedure

    mtassin (8/10/2009)

    But who watches the watchers? Then we have a cabal where if they like each other's articles then nobody can stop them.

    And who determines who should be in...

    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

    August 10, 2009 at 3:30 pm

    #1037099

Viewing 15 posts - 37,141 through 37,155 (of 49,552 total)