Forum Replies Created

Viewing 15 posts - 2,581 through 2,595 (of 49,552 total)

  • RE: Distributed Replay / Testing

    alex.sqldba (8/23/2016)

    Restore last full backup up to the marked transaction

    Full backups can't be restored to times or marks, they are always restored to the consistent point at the end of...

    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 23, 2016 at 9:26 am

    #1896948

  • RE: SELECT permission denied

    If they're getting denied access to just one table, then there's a object-level permission set on that table. Check the DMVs for the details, you can then use REVOKE to...

    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 23, 2016 at 7:20 am

    #1896894

  • RE: Pages and Extents

    Yes it can, and that knowledgable friend is wrong, 64kb is not the ideal block size, SQL does not read and write in extents only.

    http://blog.purestorage.com/what-is-sql-servers-io-block-size/

    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 23, 2016 at 4:24 am

    #1896840

  • RE: Unless the log is being backed up is there a reason for setting a databse to the BULK LOGGED recovery model

    You've got a DB in full or bulk-logged recovery model and you've never backed up the log? Might want to fix that before the log fills the drive (log space...

    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 23, 2016 at 4:20 am

    #1896837

  • RE: Big Transaction Log

    Can't see the picture.

    Shrink is how you reduce the file size, but unless there's a really good reason, and a lot of free space in the file that will never...

    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 22, 2016 at 1:03 pm

    #1896746

  • RE: Can we shrink datafile of a database which is configured with log shipping

    Jeff Moden (8/22/2016)

    and only back to the last "dirty" VLF for log files.

    Any shrink to the log file only removes space to the last active VLF. VLFs cannot be...

    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 22, 2016 at 12:58 pm

    #1896744

  • RE: Can we shrink datafile of a database which is configured with log shipping

    Jeff Moden (8/19/2016)

    Note that (IIRC) switching to BULK LOGGED may have an impact (as in break it) on log shipping so you may be stuck with having the 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 22, 2016 at 12:56 pm

    #1896742

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    szejiekoh (8/22/2016)

    I wanted to sort this out because people are telling me that you can have a 2 node window cluster setup without any form of share disk at 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

    August 22, 2016 at 12:53 pm

    #1896739

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    Yes, it must be on a cluster.

    As I said above, recommeded quorum model is either node majority or node and file share depending how many nodes you have (you need...

    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 22, 2016 at 10:06 am

    #1896696

  • RE: Extended Event DDL and Filter out Temp tables?

    Try filtering on database_id, or is the db_id the id of the connection rather than the 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

    August 22, 2016 at 9:48 am

    #1896690

  • RE: How to recover SQL Jobs?

    You can check the default trace, but I'm not sure if job deletions are recorded.

    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 22, 2016 at 9:36 am

    #1896688

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    Avbailability Groups do not require shared storage. Recommended quorum model is either node majority or node and file share depending how many nodes you have.

    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 22, 2016 at 8:47 am

    #1896672

  • RE: Want solution on access utilization of RAM by SQL server 2005

    2M (8/22/2016)

    due to this our server RAM utilization is almost 96% all the time , the moment we shut down SQL Services RAM Utlizatin drops below 5%

    when we checked 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 22, 2016 at 6:52 am

    #1896633

  • RE: Alwayson on WSFC - is shared disk really not needed ?

    Always On is a marketing term that encompases multiple features.

    Always On Windows Failover Clustering required shared storage, just like clustered SQL instances always have.

    Always On Availability Groups does not require...

    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 22, 2016 at 6:34 am

    #1896624

  • RE: MY SQL INSTANCE DIDNT RECONIZE LOCAL DISK

    Is it a clustered instance?

    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 22, 2016 at 5:55 am

    #1896602

Viewing 15 posts - 2,581 through 2,595 (of 49,552 total)