Forum Replies Created

Viewing 15 posts - 17,641 through 17,655 (of 49,552 total)

  • RE: How to shrink the log file?

    Read the second article I linked.

    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

    July 14, 2012 at 12:27 pm

    #1512813

  • RE: How to shrink the log file?

    Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    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

    July 14, 2012 at 8:16 am

    #1512795

  • RE: SQL Server ignoring maximum file size on transaction log

    And to be even more utterly clear

    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

    July 14, 2012 at 8:05 am

    #1512793

  • RE: SQL Server ignoring maximum file size on transaction log

    yup (7/14/2012)

    Attached files in the main post & here on connect

    Files not accessible.

    Still waiting for the steps to repo. A simple create DB does not work

    Edit: and to be utterly...

    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

    July 14, 2012 at 7:31 am

    #1512789

  • RE: What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

    TDE for the first (ensure backups can't be restored).

    For the second, since you want to encrypt at source, you'll need some 3rd party encryption tool, or the use of encrypted...

    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

    July 14, 2012 at 5:41 am

    #1512781

  • RE: What is the best way to encrypt SSNs and FEIN Numbers (Employer Tax ID Number) in SQL Server 2008?

    Depends, what are you protecting against?

    If a backup is restored, do you want to ensure that some 3rd party can't restore the backups?

    Do you want to ensure that if some...

    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

    July 14, 2012 at 2:59 am

    #1512768

  • RE: Page File Recommendation

    dan-572483 (7/13/2012)

    You want some (I'm told a minimum of 800GB) on the system drive for memory dumps

    800GB for memory dumps? Seriously?

    Unless you're sitting with a TB of physical memory, that's...

    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

    July 13, 2012 at 10:22 am

    #1512640

  • RE: Page File Recommendation

    SQL_Enthusiast (7/13/2012)

    For the OS drive, I read an article stating on a 32GB memory x64 bit system it would be advisable to manually set 8GB...

    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

    July 13, 2012 at 10:16 am

    #1512639

  • RE: Memory Issues

    Depends what the errors are.

    SQL uses a lot of memory. That's by design and a good thing. You should always limit the max server memory to a sensible value based...

    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

    July 13, 2012 at 10:10 am

    #1512637

  • RE: Switching from full recovery model to simple on logshipping DB

    Robert Davis (7/13/2012)

    Specifically, what will happen if you switch to simple recovery mode is that the backup job will start failing because you can't backup a database in simple recovery...

    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

    July 13, 2012 at 9:52 am

    #1512632

  • RE: Page File Recommendation

    Why would you need a page file on that drive?

    Page file is just 'extra' memory for when the OS has too many demands and too little resources. Nothing to do...

    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

    July 13, 2012 at 8:57 am

    #1512599

  • RE: Page File Recommendation

    Yes. OS drive only. Why do you want extra IO on your log drive?

    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

    July 13, 2012 at 8:46 am

    #1512585

  • RE: Rogue transaction log backup

    What's the error log entry from that log backup?

    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

    July 13, 2012 at 8:41 am

    #1512581

  • RE: SQL Server ignoring maximum file size on transaction log

    Take a backup of it please, zip it and upload to some file share.

    Also please detail step by step how you achieved that.

    Right now my server is running some performance...

    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

    July 13, 2012 at 8:41 am

    #1512580

  • RE: Minimum missing value - Query help

    Trivial to solve with a numbers table.

    CREATE TABLE Numbers (

    Number INT PRIMARY KEY

    )

    INSERT INTO Numbers (Number)

    SELECT TOP (100) ROW_NUMBER() OVER (ORDER BY (SELECT 1))

    FROM msdb.sys.COLUMNS

    With that

    CREATE TABLE #Contact

    (

    ContactID INT,

    FirstName NVARCHAR(255),

    MiddleName...

    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

    July 13, 2012 at 3:22 am

    #1512424

Viewing 15 posts - 17,641 through 17,655 (of 49,552 total)