Forum Replies Created

Viewing 15 posts - 8,566 through 8,580 (of 49,552 total)

  • RE: WAITFOR wait type

    The WAITFOR wait type indicates that the session in question is currently running a WAITFOR DELAY or WAITFOR TIME statement.

    http://msdn.microsoft.com/en-us/library/ms187331.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

    July 3, 2014 at 2:18 am

    #1726703

  • RE: SQL Server 2008 performance issue

    Lansend1 (7/2/2014)

    Thanks Gail will check the book out.

    Luis Thanks for the response, please see below for output of query, but note we did not set it , the server...

    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 3, 2014 at 1:00 am

    #1726691

  • RE: Partitioned Table on same physical volume performance

    No, you don'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

    July 2, 2014 at 3:41 pm

    #1726646

  • RE: Partitioned Table on same physical volume performance

    Sliding window, fast deletes (of entire partition of data), index rebuilds at the partition level.

    Partitioning's not usually about performance in the first place.

    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 2, 2014 at 3:07 pm

    #1726640

  • RE: columns compare

    Cursors? Why?

    SELECT MAX(ABS(t.idvalue - maxID.idvalue))

    FROM #temp AS t

    CROSS JOIN (SELECT TOP (1)

    ...

    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 2, 2014 at 9:49 am

    #1726556

  • RE: Performance Tuning Methodology

    TheSQLGuru (7/2/2014)

    High Power setting, numerous associated with the IO subsystem (regardless of type). Many/most SQL Servers are or are now being put on VMs and there are quite a...

    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 2, 2014 at 9:43 am

    #1726554

  • RE: Performance Tuning Methodology

    Kwisatz78 (7/2/2014)

    In regards server level configuration do you know any good resources for recommended settings?

    To be honest, most things I would leave at default unless I have a good reason...

    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 2, 2014 at 7:53 am

    #1726499

  • RE: Transaction file Growing

    Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/

    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 2, 2014 at 2:23 am

    #1726402

  • RE: How to repair backup of .mdf file database?

    Jeff, would you mind removing the quote of the spam post (that's all those are)?

    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 2, 2014 at 2:21 am

    #1726401

  • RE: Derived tables vs Normal table joins

    wilks (7/2/2014)

    I had misunderstood the scan count from IO statistics, I see now it can refer to an index or table scan.

    No, it doesn't. It is not a count 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

    July 2, 2014 at 2:17 am

    #1726398

  • RE: SQL Server 2008 performance issue

    DO NOT check boost priority. It should not be enabled and can lead to OS instability if it is enabled.

    Max server memory should be set. See chapter 4 of https://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

    July 1, 2014 at 3:43 pm

    #1726341

  • RE: Database stuck in Recovery pending state

    sqlguru939 (7/1/2014)

    A file activation error occurred. The physical file name 'i:\Vid\FSDATA' may be incorrect. Diagnose and correct additional errors, and retry the operation.

    Does that directory exist?

    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 1, 2014 at 3:38 pm

    #1726340

  • RE: Derived tables vs Normal table joins

    Scan count != number of table scans. Rather ignore the scan count, it's not consistent.

    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 1, 2014 at 10:26 am

    #1726268

  • RE: Can NoLock be used on table-returning functions?

    nonghead-webspam (7/1/2014)

    Reason I want to use NoLock is because queries are returning slowly. Instructions say that is what it is good for.

    No.

    Nolock is not a performance tuning technique....

    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 1, 2014 at 10:24 am

    #1726262

  • RE: SQL - Regular Maintenance - Best Practice??

    Backups. First and most important, get your backups set up and ensure that your backup strategy can meet your SLAs

    Integrity checks. Often enough that should you encounter corruption restoring from...

    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 1, 2014 at 5:25 am

    #1726116

Viewing 15 posts - 8,566 through 8,580 (of 49,552 total)