Forum Replies Created

Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)

  • RE: I think I already know the answer but... :unsure:

    The SQL Server binaries are on a disk that you intend to replace?

    Uninstall. Reinstall.

    Backup/restore all databases (don't forget the system ones), or detach/attach (and backup/restore the system ones that can'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

    January 15, 2013 at 10:25 am

    #1577421

  • RE: Index optimization failed for User databases

    Print the command (rather than executing it) and see what it returns.

    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 15, 2013 at 8:19 am

    #1577362

  • RE: Size of the ldf file increasing

    Abu Dina (1/15/2013)

    3) When you check the size of your files you find that the data file has grown to 1GB and the log file 2GB!

    4) A week later...

    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 15, 2013 at 6:55 am

    #1577330

  • RE: Does Change Data Capture require a table have a primary key

    drew.georgopulos (1/15/2013)

    Second, NUTS! the requirement of a pk or unique index torpedo's my intention, as the source does not create uniqueness and attempts to create the minimum requirement, a unique...

    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 15, 2013 at 6:27 am

    #1577306

  • RE: Size of the ldf file increasing

    winmansoft (1/15/2013)

    But shrinking the log file will increase fragmentation ryt?

    No.

    So is it good habit to shrink the log file?

    Not regularly, no.

    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 15, 2013 at 6:10 am

    #1577293

  • RE: Torn page issue

    Jayanth_Kurup (1/15/2013)

    @Gail , would it make sense now to add a clustered index or rebuild the clustered index ?

    No, it will fail.

    Are you able to access the table , can...

    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 15, 2013 at 5:47 am

    #1577283

  • RE: Torn page issue

    jitendra.padhiyar (1/15/2013)

    Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of 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 15, 2013 at 5:47 am

    #1577282

  • RE: Torn page issue

    jitendra.padhiyar (1/15/2013)

    The were trying to perform below delete operation:

    DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469

    and got error message:

    Msg 8908, Level 22, State 6, Line 1

    Table error: Database ID 23, object...

    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 15, 2013 at 5:45 am

    #1577281

  • RE: Torn page issue

    jitendra.padhiyar (1/15/2013)

    Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?

    How much, no, not after the fact. Which 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 15, 2013 at 2:49 am

    #1577211

  • RE: Torn page issue

    Err... Joie asked you to run CheckDB with no_infomsgs, not CheckDB with the repair allow data loss option specified. Do you have any idea what data was lost when you...

    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 15, 2013 at 2:28 am

    #1577204

  • RE: Does Change Data Capture require a table have a primary key

    A unique index is required if the table is to support net changes as well as all changes

    http://msdn.microsoft.com/en-us/library/cc627369%28v=sql.105%29.aspx

    A capture instance will always include a table valued function for returning all...

    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 15, 2013 at 2:20 am

    #1577198

  • RE: tempdb per processor cores?

    http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

    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 15, 2013 at 1:20 am

    #1577169

  • RE: index architecture

    Index pages are 8kb, like all other pages in SQL.

    http://www.sqlservercentral.com/articles/Indexing/68439/

    http://www.sqlservercentral.com/articles/Indexing/68563/

    http://www.sqlservercentral.com/articles/Indexing/68636/

    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 15, 2013 at 1:19 am

    #1577167

  • RE: Size of the ldf file increasing

    Please read through this - Managing Transaction Logs[/url]

    If the log file has grown too large, a once off shrink to bring it back to normal size is fine. Log backups...

    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 15, 2013 at 1:17 am

    #1577166

  • RE: transaction log working

    sej2008 (1/14/2013)

    Would like to know whether DCL and DDL statements are logged in sql log file before hardening on data file?

    DCL?

    All modifications to the database are logged first before 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 15, 2013 at 1:16 am

    #1577165

Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)