Forum Replies Created

Viewing 15 posts - 34,576 through 34,590 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/19/2010)

    Considering that updating the system table probably wouldn't change any settings on the actual database. There is probably something in the system data stored in the mdf...

    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

    January 19, 2010 at 1:06 pm

    #1105705

  • RE: adding to compatibility mode

    You're running SQL 2000 there, not SQL 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

    January 19, 2010 at 1:05 pm

    #1105704

  • RE: HELP me please ....

    Chad Crawford (1/19/2010)

    The drive came back ok when the network came up, but SQL Server didn't 'reconnect' to the file.

    It doesn't. Once SQL detects that a drive...

    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

    January 19, 2010 at 12:50 pm

    #1105689

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/19/2010)

    GilaMonster (1/19/2010)

    Well, there is a way, but that's not it. Besides, I really doubt that UPDATE sysdatabases has ever been the appropriate way to enable torn page protection.

    Oh,...

    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

    January 19, 2010 at 12:49 pm

    #1105687

  • RE: HELP me please ....

    Lynn Pettis (1/19/2010)

    My concern is the drive being powered off possibly causing data corruption.

    It may have. Or it may not have. Impossible to tell without running a checkDB, which 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

    January 19, 2010 at 12:48 pm

    #1105683

  • RE: Setting up AutoInsert

    You need to set a default on the column. Look up ALTER TABLE for the syntax to do 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

    January 19, 2010 at 12:31 pm

    #1105668

  • RE: Row locking and Table locking

    gregory.anderson (1/19/2010)

    GilaMonster (1/19/2010)

    Scans of the clustered index are table scans. They either indicate that a nonclustered index was not selective enough to be used, or there are nonclustered indexes missing.

    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

    January 19, 2010 at 12:29 pm

    #1105666

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/19/2010)

    Oh, there is a way to update the system tables in SQL Server 2005, here's how. Let us know if it works for you. No warning...

    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

    January 19, 2010 at 12:28 pm

    #1105665

  • RE: adding to compatibility mode

    Please run the following and post the results

    SELECT @@version

    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

    January 19, 2010 at 12:21 pm

    #1105662

  • RE: HELP me please ....

    I'd suggest a reboot. Once SQL's back online, run a checkDB on the original database, see if everything's OK.

    You probably didn't need to restore the database, very likely once 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

    January 19, 2010 at 12:20 pm

    #1105659

  • RE: SQL DBA

    Take a look at this series

    http://www.brentozar.com/becoming-a-dba/how-to-get-a-junior-dba-job/

    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

    January 19, 2010 at 12:18 pm

    #1105658

  • RE: Database Integrity Error

    That's not a compete output and I cannot see from that what's wrong. Where did that come from? Looks like just the job history.

    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

    January 19, 2010 at 12:08 pm

    #1105650

  • RE: Updates System Catalogs

    Ramji29 (1/19/2010)

    update master.sys.sysdatabases set status = 16 where name = 'db'

    Even ignoring that 'allow updates' is ignored on SQL 2005, sysdatabases isn't even a table any longer. It's a view...

    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

    January 19, 2010 at 12:06 pm

    #1105649

  • RE: Row locking and Table locking

    Scans of the clustered index are table scans. They either indicate that a nonclustered index was not selective enough to be used, or there are nonclustered indexes missing.

    How did 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

    January 19, 2010 at 7:08 am

    #1105393

  • RE: how to retrive row id from a table

    I'd start with google.

    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

    January 19, 2010 at 5:46 am

    #1105354

Viewing 15 posts - 34,576 through 34,590 (of 49,552 total)