Forum Replies Created

Viewing 15 posts - 42,391 through 42,405 (of 49,552 total)

  • RE: Killing a locked process

    There's often more than one entry in that view. Try the following and see if there's more than one entry and, if so, if one of them has a uow

    select...

    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

    December 12, 2008 at 4:22 am

    #911545

  • RE: Finished my MCITP on Friday

    shyam (12/12/2008)

    I'm preparing for the same and could you please help me by suggesting the book, topics etc.

    The self-paced training kit is quite good.

    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

    December 12, 2008 at 4:19 am

    #911540

  • RE: Problem Restoring 2000 DB to SQl Server 2005

    I'd suggest running an integrity check on the SQL 2000 database (on SQL 2000)

    Run CheckDB with No_infomsgs and all_errormsgs and also run CheckCatalog with no_infomsgs and all_errormsgs

    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

    December 12, 2008 at 1:09 am

    #911499

  • RE: An inconsistency was detected during an internal operation

    madhu.arda (12/11/2008)

    2008-12-09 17:54:14.72 spid204 Error: 5243, Severity: 22, State: 1.

    2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please...

    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

    December 12, 2008 at 1:06 am

    #911498

  • RE: Deadlock in SQL Server, not in DB2/Oracle

    Locking mechanisms are very, very different between Oracle, DB2 and SQL. It's not unexpected that something that works on 1 will give problems on another. Things that work well on...

    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

    December 12, 2008 at 1:03 am

    #911497

  • RE: sys.dm_db_missing_index_details

    SQL_Easy_btn? (12/11/2008)

    I found that I have 247 missing index on my server running this against the master database,

    Don't make any changes in the master database.

    3. Would it be 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

    December 12, 2008 at 12:50 am

    #911494

  • RE: SQL server not writing to Event log correctly

    Are you reading the event log directly from the server, or are you reading it from your client machine?

    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

    December 12, 2008 at 12:42 am

    #911493

  • RE: DB server has a vanilla install of SQL Ent 2005 and the reporting tools

    It's an english colloquial term to indicate that whatever the term applies to is plain, basic, no fancy stuff.

    So a vanilla install would be a straight install with no config...

    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

    December 12, 2008 at 12:38 am

    #911491

  • RE: DBCC Check Table shows Error

    Can't say much until the output of checkDB is posted. In the meantime, do you have a clean database backup?

    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

    December 12, 2008 at 12:31 am

    #911488

  • RE: Sub query optimization

    mohd.imtiaz (12/11/2008)

    Its a correlated sub query, and i have gone through may site which says corelated syb queries work very slow.

    is tht true??

    In most cases (including this one) no. 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

    December 12, 2008 at 12:27 am

    #911484

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/11/2008)

    I've been driving for over 33 years, 38 if you count the 5 years of dirt bike riding prior to getting my first license.

    Grant Fritchey (12/11/2008)

    Got me beat....

    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

    December 11, 2008 at 2:45 pm

    #911354

  • RE: Are the posted questions getting worse?

    I've had no serious accidents in 10 years of driving. One very minor bumper bashing and several close calls though.

    Closest call was a couple years back on a highway. There'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

    December 11, 2008 at 11:54 am

    #911271

  • RE: Backups and Transactions Log relationships

    Bristolred (12/11/2008)

    Basically your saying you have to be prepared for the complete worst i.e. disaster recovery if the whole server was to pack up/catch fire or the drive the log...

    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

    December 11, 2008 at 11:38 am

    #911261

  • RE: I restarted sql and now my database is "(in recovery)"

    Glad to hear 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

    December 11, 2008 at 11:33 am

    #911255

  • RE: os_file_name

    Bear in mind that, with the exception of TempDB, running that does not move the files. It just changes the metadata. Once you've run that you need to take 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

    December 11, 2008 at 11:10 am

    #911240

Viewing 15 posts - 42,391 through 42,405 (of 49,552 total)