Forum Replies Created

Viewing 15 posts - 19,396 through 19,410 (of 49,552 total)

  • RE: Correcting bad autogrowth settings

    GilaMonster (4/3/2012)

    A standard windows file defrag tool can tell you that. Run it while the database is detached or SQL shut down. Be very, very, very careful with 'online' defrag...

    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

    April 3, 2012 at 8:53 am

    #1468272

  • RE: Database in Suspect mode with error in recovery phase

    The only repair level that is supported in emergency mode is repair_allow_data_loss

    I recommend restoring from backup, I highly doubt that is repairable seeing as the error is on the database...

    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

    April 3, 2012 at 8:38 am

    #1468254

  • RE: How can I determine if a SQL Server ldf log file is in use on a server?

    Query sys.master files. Check the column that shows the physical file name.

    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

    April 3, 2012 at 8:27 am

    #1468242

  • RE: Correcting bad autogrowth settings

    Drenlin (4/3/2012)

    I guess there is no way in knowing how fragmented the database files are. Am I correct?

    A standard windows file defrag tool can tell you that. Run it while...

    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

    April 3, 2012 at 8:06 am

    #1468222

  • RE: To create the sql server health check

    Divine Flame (4/3/2012)

    GilaMonster (4/3/2012)

    bala2 (4/3/2012)

    Thanks for reply,

    I am not having experience on development part.can you please help me out

    There's no development required in what I suggested.

    Do we have the option...

    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

    April 3, 2012 at 8:02 am

    #1468221

  • RE: Catching the culprit!!

    mathew.walters (4/3/2012)

    True, but then you could also delete audit data if you wanted to, I assume that it's not malicious.

    Deleting audit data requires permission on the server, permissions whereever 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

    April 3, 2012 at 7:19 am

    #1468194

  • RE: Catching the culprit!!

    S_Kumar_S (4/3/2012)

    Gail, I dont see the screen you pasted in sql server 2008. Is it for sql server 2008R2 only?

    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

    April 3, 2012 at 7:18 am

    #1468193

  • RE: 2008R2 Foreign Keys Don't have cardinality

    SQL can figure it out by checking which table has the unique constraint on the column.

    If both sides have a unique constraint, then it's a 1:1 foreign key, otherwise...

    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

    April 3, 2012 at 6:56 am

    #1468184

  • RE: Shrink the log file of database which is in transactional replication

    Please read through 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

    April 3, 2012 at 6:50 am

    #1468180

  • RE: Catching the culprit!!

    mathew.walters (4/3/2012)

    Evil Kraig, your statement is incorrect, the host_name() function retrieves the host name of the machine making the request, I have used it in the past for auditing 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

    April 3, 2012 at 6:49 am

    #1468179

  • RE: To create the sql server health check

    bala2 (4/3/2012)

    Thanks for reply,

    I am not having experience on development part.can you please help me out

    There's no development required in what I suggested.

    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

    April 3, 2012 at 6:24 am

    #1468163

  • RE: TempDB Size

    Not really. Best thing to do would be a full load test on a dev/test server (with production data volumes) and see how big TempDB needs to 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

    April 3, 2012 at 1:50 am

    #1468038

  • RE: To create the sql server health check

    Start with the Policy-based management policies that ship with SQL. You'll have to load them into the list of policies, they're somewhere in the install directory of 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

    April 3, 2012 at 1:39 am

    #1468036

  • RE: Dynamic SQL statement gets logged in Transaction log?

    The rows being inserted will be logged. The statement itself won'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

    April 3, 2012 at 1:27 am

    #1468031

  • RE: rebuild index with -2

    Unfortunatley 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

    April 3, 2012 at 1:25 am

    #1468030

Viewing 15 posts - 19,396 through 19,410 (of 49,552 total)