Forum Replies Created

Viewing 15 posts - 40,201 through 40,215 (of 49,552 total)

  • RE: Error

    Is the SQL Service running? That's 2005's generic 'can't connect' error.

    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

    March 23, 2009 at 6:00 am

    #964338

  • RE: Extremely slow View - can I 'preprocess' the data?

    Can you post the query, the table definitions and any indexes on them?

    A view has to be a single select statement, so no EXEC in it . Why does 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

    March 23, 2009 at 5:56 am

    #964335

  • RE: Corrupted page not repairable w/ DBCC - how to delete it?

    I'm not sure why that's not repairing. I'm sure Paul will drop by soon and explain in detail.

    In the meantime...

    You say you don't mind losing data. If that's the case,...

    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

    March 23, 2009 at 5:52 am

    #964334

  • RE: DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS

    You don't really have many options.

    If you have a clean backup and all the log backups since then, you can restore. There will be downtime though.

    You can take the DB...

    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

    March 23, 2009 at 5:47 am

    #964330

  • RE: DDL auditing in sql server2000

    Sathiya priya (3/23/2009)

    Server Side Trace in Sql server 2000 has not captured the objects which is created. Am i missing something 🙁 ?

    What events are you tracing, what filters...

    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

    March 23, 2009 at 5:39 am

    #964327

  • RE: Please help what are these errors means?

    yulichka (3/22/2009)

    It says that in order to run dbcc repair that my db needs to be in single mode,but my db in multi user mode, if I switch our web...

    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

    March 23, 2009 at 1:47 am

    #964270

  • RE: General question about transaction log backups.

    JamesNZ (3/22/2009)

    Mark it as reusable or clean the space completely? A log file for a db didn't shrink down to 0KB, and stayed at 3.2GB, any idea on why 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

    March 23, 2009 at 1:41 am

    #964268

  • RE: Corrupted page not repairable w/ DBCC - how to delete it?

    Can you post the full output of the following command please. I'd like to get a full picture of what's wrong before recommending anything.

    DBCC CHECKDB (< Database Name > )...

    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

    March 23, 2009 at 1:39 am

    #964267

  • RE: Database was change from full to simple,how can I check when was is done and who did

    On SQL 2000, unless you were running a SQL Trace already, there's no way to tell who did it or when.

    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

    March 23, 2009 at 1:37 am

    #964266

  • RE: DBCC CHECKDB WITH ALLOW_DATA_LOSS

    Before you run it (though looking at all your other posts, it may be a little late) note that REPAIR_ALLOW_DATA_LOSS should be a last resort for fixing corruption. 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

    March 23, 2009 at 1:30 am

    #964263

  • RE: DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS

    free_mascot (3/22/2009)

    Make sure blocking do not happen 🙂

    Since all of the CheckDB repairs require that the DB be in single user mode, there cannot be any blocking.

    yulichka: See my comments...

    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

    March 23, 2009 at 1:29 am

    #964262

  • RE: dates times and constraints

    keil.asta (3/22/2009)

    You now what Gail I think you have me convinced. I can just add a reminder message like you said at the interface end.

    I'm not suggesting...

    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

    March 22, 2009 at 12:07 pm

    #964163

  • RE: dates times and constraints

    keil.asta (3/22/2009)

    I see, I I want the constraint or other method to not allow the user to close the database not at least without warning message. so the 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

    March 22, 2009 at 11:43 am

    #964159

  • RE: dates times and constraints

    Then consider front-end validation. Honestly, that's where the 'you must enter a time' type validation belongs. By the time the data gets to SQL, there's no way to tell 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

    March 22, 2009 at 11:16 am

    #964153

  • RE: Saleability and performance, splitting tables and databases

    Andy Bod (3/21/2009)

    However my concern is that the database could become very focused on this vehicle table, with most queries accessing this table for their primary information. As such...

    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

    March 22, 2009 at 11:02 am

    #964147

Viewing 15 posts - 40,201 through 40,215 (of 49,552 total)