Viewing 15 posts - 8,566 through 8,580 (of 49,571 total)
The WAITFOR wait type indicates that the session in question is currently running a WAITFOR DELAY or WAITFOR TIME statement.
July 3, 2014 at 2:18 am
Lansend1 (7/2/2014)
Luis Thanks for the response, please see below for output of query, but note we did not set it , the server...
July 3, 2014 at 1:00 am
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.
July 2, 2014 at 3:07 pm
Cursors? Why?
SELECT MAX(ABS(t.idvalue - maxID.idvalue))
FROM #temp AS t
CROSS JOIN (SELECT TOP (1)
...
July 2, 2014 at 9:49 am
TheSQLGuru (7/2/2014)
July 2, 2014 at 9:43 am
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...
July 2, 2014 at 7:53 am
Please take a read through this: http://www.sqlservercentral.com/articles/Administration/64582/
July 2, 2014 at 2:23 am
Jeff, would you mind removing the quote of the spam post (that's all those are)?
July 2, 2014 at 2:21 am
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...
July 2, 2014 at 2:17 am
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/...
July 1, 2014 at 3:43 pm
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?
July 1, 2014 at 3:38 pm
Scan count != number of table scans. Rather ignore the scan count, it's not consistent.
July 1, 2014 at 10:26 am
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....
July 1, 2014 at 10:24 am
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...
July 1, 2014 at 5:25 am
Viewing 15 posts - 8,566 through 8,580 (of 49,571 total)