Forum Replies Created

Viewing 15 posts - 39,181 through 39,195 (of 49,552 total)

  • RE: How Do You Find a DBA?

    Samuel Vella (5/11/2009)

    Problem with the "point and click" interface of SQL Server is that a lot of DBA's can get through their day job without having to *think* about what...

    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

    May 11, 2009 at 10:08 am

    #992274

  • RE: Fatal error involving a specific table

    Run a full checkDB. It won't kick users out, but it is pretty intensive and may slow the system down.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, 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

    May 11, 2009 at 10:04 am

    #992268

  • RE: correct use of primary keys

    kevinH (5/11/2009)

    I've read that the primary key shouldnt be set on a "monotonic" col-- an identity column would qualify as that and I also get the impress that the correct...

    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

    May 11, 2009 at 9:51 am

    #992249

  • RE: Are the posted questions getting worse?

    Bob Hovious (5/11/2009)

    P.S. Did anybody else see the Star Trek movie over the weekend? I thought it was great.

    No. Saw Wolverine. Pretty good, way better than 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

    May 11, 2009 at 9:49 am

    #992245

  • RE: can we have any alternative to remove deadlock apart from killing the process???

    That's a huge topic and there's been a lot written about it. Start with google and see what you find.

    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

    May 11, 2009 at 9:46 am

    #992241

  • RE: Errors on SYSINDEXES

    Well, you can't script an encrypted stored proc so.....

    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

    May 11, 2009 at 7:57 am

    #992131

  • RE: Restore a SQL Server 2000 .bak to SQL Server 2005 using SQL Server Management Studio Express

    lleemon13 (5/11/2009)

    Guess my first question is if this is even possible to restore a .bak file and if so, how do I restore it using SQL Server Management Studio Express?

    Sure...

    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

    May 11, 2009 at 7:49 am

    #992125

  • RE: Errors on SYSINDEXES

    apinho (5/11/2009)

    Do you know some link where I can see that "script objects / bulkcopy data" trick, thoroughly explained, so I don't make things worse.

    A colleague of mine (Better DBA...

    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

    May 11, 2009 at 7:44 am

    #992120

  • RE: can we have any alternative to remove deadlock apart from killing the process???

    That's blocking, not deadlocks. Different problems.

    You can kill the connection causing the block, but before you do, find out what it is. If it's a critical process that must not...

    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

    May 11, 2009 at 7:24 am

    #992095

  • RE: Errors on SYSINDEXES

    I just want to be 100% sure that there are no other errors anywhere else in that database. If the results of checkDB are identical to the results of CheckTable...

    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

    May 11, 2009 at 7:22 am

    #992093

  • RE: catalog error while differntial backup restore

    What's the error message?

    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

    May 11, 2009 at 7:19 am

    #992090

  • RE: Errors on SYSINDEXES

    Index 255 is the Large Object data for a table. For sysindexes, it's going to be the data in the column statsblob, as that's the only LOB column in 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

    May 11, 2009 at 7:15 am

    #992083

  • RE: Errors on SYSINDEXES

    Please run the following and post the full results.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Take a look at this article. http://www.sqlservercentral.com/articles/65804/, specifically the section on 'irreparable corruption'

    How...

    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

    May 11, 2009 at 7:02 am

    #992068

  • RE: can we have any alternative to remove deadlock apart from killing the process???

    Are you talking about deadlocks or are you talking about blocking? With deadlocks, SQL will automatically find the involved processes, pick one and kill it. You don't have to do...

    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

    May 11, 2009 at 6:59 am

    #992062

  • RE: DB Availability

    Use MyDatabase

    GO

    SELECT 1

    If the DB isn't available, that will fail

    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

    May 11, 2009 at 3:19 am

    #991963

Viewing 15 posts - 39,181 through 39,195 (of 49,552 total)