Forum Replies Created

Viewing 15 posts - 42,106 through 42,120 (of 49,552 total)

  • RE: how to use deadlock graph in the sql server 2000 ?

    Alos you need to enable the traceflag globally. If you just do TRACEON(1204) then it's only active for that session, which means you'll never see a deadlock graph as 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

    December 29, 2008 at 7:56 am

    #918381

  • RE: Sql database restore

    prasad (12/29/2008)

    By mistake we replace the actual data with old data by using sql import / export. Unfortunately we dont have the backup also. Is there anyway we can recover...

    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 29, 2008 at 7:54 am

    #918380

  • RE: Stored procedures with output parameters

    Please don't cross post. It just wastes peoples time and fragments replies.

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

    December 29, 2008 at 7:53 am

    #918379

  • RE: Changing Taxonomy

    Kerry Tyler (12/29/2008)

    There's just too much general admin/development functions and wisdom that apply across versions that may get lost on someone who only reads, say the 2005 forum, because 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

    December 29, 2008 at 7:49 am

    #918378

  • RE: Optimization Job failed????

    The IO warnings are just saying that you're overloading the IO system and the latency is getting very, very high.

    Is the second sp_spaceused that you posted from the processcontrol 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

    December 29, 2008 at 1:43 am

    #918275

  • RE: view with constantly update base tables

    I can see one potential problem right away. Activity_id in the journal table is a varchar(50), but in the query you're joining that to a decimal. That's going to cause...

    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 29, 2008 at 1:37 am

    #918274

  • RE: Restore could not start DB.

    guptaajay1985 (12/28/2008)

    Thx sqlservercentral members for the replies:

    1.I have not a clean (uncorrupted) backup.

    2.Yes, If I lost a bunch of rows from that table,it would be a disaster.

    I hate...

    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 29, 2008 at 1:20 am

    #918272

  • RE: ERROR trying to backup from Dataprotector

    And read through this - http://www.sqlservercentral.com/articles/64582/

    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 29, 2008 at 1:09 am

    #918270

  • RE: query analyzer of microsoft access 2007

    Access doesn't have a query analyser. There's the query design too inside Access, but that's all I know of for it.

    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 29, 2008 at 1:05 am

    #918269

  • RE: Performance isssue

    fakru.y (12/26/2008)

    we are planning to tune the sp's and changing temp tables to permanent tables in the db. will it help?

    Maybe. But if all you're doing is changing the temp...

    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 28, 2008 at 2:09 pm

    #918200

  • RE: Restore could not start DB.

    ALZDBA (12/28/2008)

    GilaMonster (12/28/2008)

    Unfortunately, it's not the image/text pages that are damaged. The checkDB output points to 4 pages of index 0 (the heap) that are the ones with problems. 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

    December 28, 2008 at 1:59 pm

    #918197

  • RE: Changing Taxonomy

    Jeffrey Williams (12/28/2008)

    I would recommend that you don't get rid of the data corruption forum. It should be one that stands by itself for those cases where someone is...

    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 28, 2008 at 11:11 am

    #918169

  • RE: Restore could not start DB.

    ALZDBA (12/28/2008)

    Does this point to a table that contains text or image columns ?

    Try to export the data without these column, so you only lose the text/image stuff if these...

    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 28, 2008 at 10:27 am

    #918164

  • RE: DBCC is "old technology"???

    Dugi (12/28/2008)

    GilaMonster (12/28/2008)

    Does your copy of Books Online say that CheckIdent is deprecated?

    Simple ...NO!

    If it's not marked as a deprecated feature (which, if you check, DBCC DBReindex and DBCC...

    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 28, 2008 at 7:21 am

    #918138

  • RE: DBCC is "old technology"???

    Dugi (12/27/2008)

    ...do we have any other possibility such as DBCC checkident isn't it!?

    Does your copy of Books Online say that CheckIdent is deprecated?

    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 28, 2008 at 12:43 am

    #918119

Viewing 15 posts - 42,106 through 42,120 (of 49,552 total)