Forum Replies Created

Viewing 15 posts - 17,071 through 17,085 (of 49,552 total)

  • RE: Full vs Transaction Log Backup

    Lynn Pettis (8/20/2012)

    If this means that it backs up a 21 GB log file for a 20 MB database because no t-log backups have been run between full backups, then...

    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 20, 2012 at 9:45 am

    #1527703

  • RE: Full vs Transaction Log Backup

    Full backups do not affect the transaction log.

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

    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 20, 2012 at 9:43 am

    #1527701

  • RE: Adding 2nd Transaction Log File to Mirrored Database

    Add it to the principal and ensure that the file path exists on the mirror.

    Why are you adding a second log file?

    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 20, 2012 at 9:42 am

    #1527697

  • RE: Table Permissioning

    sqlnaive (8/20/2012)

    Nothing sort of this, right ??? 🙂

    Did you try 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

    August 20, 2012 at 6:58 am

    #1527568

  • RE: Create index with DROP_Existing

    Sure you can. Use the ONLINE keyword when rebuilding the index.

    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 20, 2012 at 6:28 am

    #1527554

  • RE: Determine if a database is read-only when the log is not marked as read-only so DBCC SHRINKFILE may be skipped?

    John Mitchell-245523 (8/20/2012)

    But if you have a good reason for doing this, you need to check that the database is read-write and that each individual file you're going to 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 20, 2012 at 6:28 am

    #1527553

  • RE: Determine if a database is read-only when the log is not marked as read-only so DBCC SHRINKFILE may be skipped?

    The database as a whole can be read-only (sys.databases) or individual files can be read-only.

    Aside, why do you have a job shrinking the log? On a dev system I could...

    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 20, 2012 at 5:49 am

    #1527530

  • RE: Table Permissioning

    Why on earth not use the built ins?

    You could create a role that grants the permissions on the schema, then any tables added to the schema get the permissions

    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 20, 2012 at 5:45 am

    #1527527

  • RE: Table Permissioning

    That would be the db_datawriter built in role. Works as you want, insert, update, delete rights on all 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

    August 20, 2012 at 5:19 am

    #1527520

  • RE: OS 64 Bit, SQL 32 Bit

    Shouldn't be any issues unless you're using linked servers with 32-bit drivers.

    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 20, 2012 at 5:04 am

    #1527510

  • RE: Tlog space getting full whcle executing the Update statement

    If your database is in full recovery you need to take log backups between each batch. Otherwise make the log larger.

    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 20, 2012 at 3:55 am

    #1527483

  • RE: Clustered Key. (Making it unique).

    It's described in Books Online, I think under index architecture.

    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 20, 2012 at 3:53 am

    #1527482

  • RE: OS 64 Bit, SQL 32 Bit

    No issues, but you're going to have all the 32-bit memory limitations. Why not install 64-bit SQL?

    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 20, 2012 at 3:53 am

    #1527481

  • RE: HAving Brain fade on a simple SQL query

    You need to join the views (union appends them together). You're getting duplicate rows because the join columns are either wrong or insufficient. What you have to join on I...

    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 19, 2012 at 3:11 pm

    #1527412

  • RE: Transaction Log drive in simple recovery

    This is decent - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Disclaimer: I worked on that book.

    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 19, 2012 at 2:21 pm

    #1527409

Viewing 15 posts - 17,071 through 17,085 (of 49,552 total)