Forum Replies Created

Viewing 15 posts - 16,831 through 16,845 (of 49,552 total)

  • RE: Is it possible to reduce the unwanted Scan count and Reads in Tsql when Query Toggling happens

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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

    August 31, 2012 at 5:04 am

    #1532305

  • RE: Restore DB - LOG file

    You're not trying to truncate it, you're trying to shrink it. Huge difference.

    Read up on DBCC ShrinkFile, you want to shrink the log only and shrink it to 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

    August 31, 2012 at 2:39 am

    #1532255

  • RE: Why Index?

    Shadab Shah (8/30/2012)

    Basically indexes increases the performance will searching which is nullified while inserting . Now when the time required for inserting is large it means that the total turnaround...

    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

    August 31, 2012 at 12:17 am

    #1532226

  • RE: Restore DB - LOG file

    whizkidgps (8/30/2012)

    If I truncate the LOG file, will it cause delete data from any of the table?

    No

    What would be the problem if I truncate the LOG file?

    If you shrink...

    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

    August 31, 2012 at 12:13 am

    #1532225

  • RE: Restoring a filegroup of one database on to a different database on the same server

    muthyala_51 (8/30/2012)

    Can we restore the backup and change the db names??

    Sure, but to avoid losing data you'll need to take the backup WITH NORECOVERY so that the DB goes offline...

    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

    August 31, 2012 at 12:07 am

    #1532223

  • RE: REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

    RBarryYoung (8/30/2012)

    Didn't the OP say that this was Sql Server 2005? Can you still do something like that on 2005? (Yikes!!!)

    Yes, it is actually still possible, though I'm...

    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

    August 31, 2012 at 12:06 am

    #1532222

  • RE: SQL Server 2005 64-bit 100% CPU

    Next time try just updating statistics.

    You've given just about nothing to go on there, so it's impossible to say a cause. Fragmentation won't cause that kind of performance degradation, 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

    August 30, 2012 at 3:06 pm

    #1532143

  • RE: Restoring a filegroup of one database on to a different database on the same server

    Without any downtime at all, exceedingly difficult. Add new files to each filegroup on the new location, shrinkfile with the emptyfile option the files that are in the wrong location,...

    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

    August 30, 2012 at 1:48 pm

    #1532108

  • RE: REPAIR_ALLOW_DATA_LOSS not resolving the allocation error

    To be honest, this looks more like it could have been caused by someone doing a DELETE FROM sysindexes WHERE... on SQL 2000 (if the DB was an upgrade)

    I've seen...

    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

    August 30, 2012 at 1:33 pm

    #1532100

  • RE: SQL Server detected a logical consistency-based I/O error : SQL 2005

    opc.three (8/30/2012)

    What kind of repair? You may have lost data that way. Can you post the exact command?

    It'll be CheckDB with REPAIR_ALLOW_DATA_LOSS as no other repair option is allowed 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

    August 30, 2012 at 1:31 pm

    #1532099

  • RE: SQL Server detected a logical consistency-based I/O error : SQL 2005

    sephrobbertse (8/30/2012)

    Hi, managed to put the DB in emergency mode and do a dbcc repair.

    So I assume you have no good backup, since emergency mode repair is the absolute last...

    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

    August 30, 2012 at 1:29 pm

    #1532095

  • RE: Partitioning : SPLIT seems to use the wrong filegroup ?

    Looks OK. How did you determine that the wrong data is on the filegroup?

    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

    August 30, 2012 at 11:40 am

    #1532045

  • RE: Help determining MAX Memory settings

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    What you also need to consider is what's going to happen when one fails over? Do you set max memory so that both instances could fit on 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

    August 30, 2012 at 11:33 am

    #1532042

  • RE: Question About Transactions

    david.holley (8/30/2012)

    Example 2:

    BEGIN TRANSACTION 1

    DELETE...

    BEGIN TRANSACTION 2

    UPDATE...

    BEGIN TRANSACTION 3

    INSERT

    COMIT TRANSACTION 3

    COMIT TRANSACTION 2

    COMIT TRANSACTION 1

    Nested transactions don't...

    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

    August 30, 2012 at 11:26 am

    #1532038

  • RE: SQL Server detected a logical consistency-based I/O error : SQL 2005

    Restore from backup. Don't know offhand if you can do a page restore when a DB is suspect, so may need to be a full restore. How big's 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

    August 30, 2012 at 11:25 am

    #1532037

Viewing 15 posts - 16,831 through 16,845 (of 49,552 total)