Forum Replies Created

Viewing 15 posts - 41,866 through 41,880 (of 49,552 total)

  • RE: highest unused ID

    Can you be more specific? Primary keys don't have to be sequential, so the concept of 'highest unused' isn't something that applies to all primary keys.

    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 8, 2009 at 3:06 pm

    #923754

  • RE: Restore with Recovery option

    kwoznica (1/8/2009)

    WITH MOVE 'NAV5LIVE_DATA.MDF' TO 'E:\COPYDB\NAV5LIVE08_DATA.MDF',

    MOVE 'NAV5LIVE_1_DATA.NDF' TO 'E:\COPYDB\NAV5LIVE08_1_DATA.NDF',

    MOVE 'NAV5LIVE_LOG.LDF' TO 'E:\COPYDB\NAV5LIVE08_LOG.LDF',

    RECOVERY,

    STATS = 5;

    I believe the highlighted name should be the logical file names, not 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 8, 2009 at 2:57 pm

    #923744

  • RE: Missing data rows?

    Ron Kunce (1/8/2009)

    My options are to increase the .net timeout values or best to get the server upgrade made a top priority.

    How about optimising the database query? That will...

    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 8, 2009 at 2:49 pm

    #923738

  • RE: Post Full Backup Transacation Log Backup Huge

    murrayd (1/8/2009)

    Reorganize Indexes,

    That'll do it.

    If you're rebuilding all indexes on all tables than you are 'changing' every row in the database. Index rebuilds are fully logged in full...

    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 8, 2009 at 2:28 pm

    #923722

  • RE: Missing data rows?

    Ron Kunce (1/8/2009)

    This leads me think that option may have deprecated some time ago as the user guide is from manuals.sybase.com/onlinebooks/. . ..

    Sybase and SQL split...

    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 8, 2009 at 11:56 am

    #923605

  • RE: cannot understand why query analyzer is picking a specific index.

    winston Smith (1/8/2009)

    im thinking the optimizer will pick the (string, dt, id) index as it has less rows to return with the string, max of 100, rather than 5000 or...

    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 8, 2009 at 11:30 am

    #923581

  • RE: Update small parts of XML in DB

    Why are you storing and modifying large pieces of xml in a database? Why are these claims not in their own 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

    January 8, 2009 at 11:22 am

    #923576

  • RE: Post Full Backup Transacation Log Backup Huge

    When's the last log backup from before the full? Full backups don't truncate the log, so you have to look at the activity from the last tran log.

    Full recovery? Bulk...

    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 8, 2009 at 11:15 am

    #923573

  • RE: urgent query

    pcreddy9 (1/7/2009)

    ok

    Please don't edit your questions away. It just makes it confusing for everyone who reads it afterwards.

    It's also polite to let us know if the solutions worked or 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

    January 8, 2009 at 11:06 am

    #923569

  • RE: How to manage errors efficiently?

    crfenix (1/8/2009)

    but unfortunetly this approach isn't handle ALL error types and some times somethig wrong happens in the middle of the execution and there is no rollback with 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 8, 2009 at 10:48 am

    #923556

  • RE: cannot understand why query analyzer is picking a specific index.

    winston Smith (1/8/2009)

    I was told, in an sql course that when indexing for AND queries, always try to use an index on the most selective column.

    I hate 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

    January 8, 2009 at 10:12 am

    #923498

  • RE: Missing data rows?

    There is no config switch that treats a real table as if it were a temp. If you're doing a select into a permanent table, it's a permanent table.

    Are there...

    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 8, 2009 at 10:04 am

    #923486

  • RE: LOCK problem

    sampathsoft (1/8/2009)

    There are no any sql mechanism for it.

    Excuse me?

    SQL absolutely has the ability to lock rows been modified. It's an essential part of a relational database, isolation, the requirement...

    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 8, 2009 at 9:41 am

    #923467

  • RE: Problem with temp tables not being dropped

    T D McCallie (1/7/2009)

    This bug ( http://support.microsoft.com/kb/947204/ ) is resolved in SQL/Server 2005 CU6 ( http://support.microsoft.com/kb/946608/ ).

    That's internal objects (worktables, table spools, index spools, etc), not temp tables

    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 8, 2009 at 4:56 am

    #923203

  • RE: Problem with temp tables not being dropped

    Jack Corbett (1/7/2009)

    GilaMonster (1/7/2009)

    SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may...

    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 8, 2009 at 4:54 am

    #923202

Viewing 15 posts - 41,866 through 41,880 (of 49,552 total)