Forum Replies Created

Viewing 15 posts - 13,786 through 13,800 (of 49,552 total)

  • RE: File Groups advatages

    SQL* (3/21/2013)

    If there is any corruption while writing the data to PRIMARY File Group's files the database will not available to access. We can make the Database available by adding...

    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

    March 21, 2013 at 3:35 am

    #1599275

  • RE: Doubt about Shrinking process , Rebiulding index and fragmenatation

    Log fragmentation is described in the article I referred you 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

    March 21, 2013 at 3:18 am

    #1599268

  • RE: Database deleted

    Yup, restore from 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

    March 20, 2013 at 1:59 pm

    #1599118

  • RE: Rebuilt Index

    haiao2000 (3/20/2013)

    GilaMonster (3/20/2013)

    DBCC INDEXDEFRAG is deprecated, etc, etc. replacement is ALTER INDEX ... REORGANIZE

    Thanks Gail,

    So Reorganize will work for SQL 2000 and newer?

    2005 and newer, same as your ALTER 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

    March 20, 2013 at 12:55 pm

    #1599086

  • RE: Rebuilt Index

    DBCC INDEXDEFRAG is deprecated, etc, etc. replacement is ALTER INDEX ... REORGANIZE

    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

    March 20, 2013 at 12:43 pm

    #1599080

  • RE: reduce resource waits on sql server without upgrading sql server

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    And chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    March 20, 2013 at 12:42 pm

    #1599079

  • RE: Are the posted questions getting worse?

    I'm getting the string impression, out of his depth and doesn't know it.

    http://www.sqlservercentral.com/Forums/Topic1431330-1292-1.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

    March 20, 2013 at 12:41 pm

    #1599078

  • RE: Sql server back ground processes.

    solomon.jernas (3/20/2013)

    But i want know, this way , thread and cost of query , lazy writer, memory . what are things involve in DML query.. Architure level...

    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

    March 20, 2013 at 12:26 pm

    #1599069

  • RE: Upgraded from SQL2000 to SQL2008R2 - Now have corruption

    If you're getting recurring corruption (you repair, corruption comes back, you repair, etc), your IO subsystem is faulty, check logs, update drivers, etc. SQL is not in the habit 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

    March 20, 2013 at 12:23 pm

    #1599068

  • RE: Transaction Log

    kevaburg (3/20/2013)

    If your transaction logs are getting big even in SIMPLE Recovery Mode, could it possibly be that you have a great deal of DML occuring without commits? INSERTs, UPDATEs...

    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

    March 20, 2013 at 12:19 pm

    #1599065

  • RE: Non-clustered Covering Indexes - Many w/few included columns vs Single w/many included columns

    Yup, consolidate, that should be one index.

    The only counter case for keeping it separate would be where queries that use those indexes absolutely must run as fast as possible and...

    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

    March 20, 2013 at 12:16 pm

    #1599062

  • RE: Do Users based on logins in master have access to other databases?

    clintonG (3/20/2013)

    Also, I wasn't talking about SQL permissions, you need to lock down the windows machine, limit administrative access, make sure that no one has permissions to the machine unless...

    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

    March 20, 2013 at 12:14 pm

    #1599060

  • RE: Do Users based on logins in master have access to other databases?

    clintonG (3/20/2013)

    Not to my foreknowledge but I may actually be trying to do a trick niavely as my intent to locate the mdf/ldf files at My Documents > My Data...

    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

    March 20, 2013 at 12:11 pm

    #1599059

  • RE: DBCC CheckTable returns following results, best way to deal with this?

    That could well be it. Just keep an eye on things, run regular CheckDB and make sure that things remain OK.

    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

    March 20, 2013 at 12:09 pm

    #1599057

  • RE: Sql server back ground processes.

    There are lots of processes running in the background all the time. Query sys.dm_exec_sessions and filter for is_user_process = 0. That'll show you all the background system processes.

    They aren't specific...

    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

    March 20, 2013 at 3:12 am

    #1598782

Viewing 15 posts - 13,786 through 13,800 (of 49,552 total)