Viewing 4 posts - 1 through 4 (of 4 total)
If the issue is limited to one single table I'd check it's clustered key choice. Fragmentation is most often the results of page splits which are most often caused by...
August 1, 2013 at 9:31 am
As a DBA responsible for a 4TB DWH, WhereScape scares the shit out of me.
Where adding a single column to a table in the Northwind DB during a demo...
August 1, 2012 at 4:12 am
you will need to execute a manual checkpoint command in tempdb because tempdb isonly flushed when its tranlog becomes >70% full.
See http://www.sqlskills.com/BLOGS/PAUL/post/What-does-checkpoint-do-for-tempdb.aspx
April 10, 2012 at 6:56 am
does this tell you more?
***Stack Dump being sent to X:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0018.txt ...
June 8, 2011 at 3:46 am
Viewing 4 posts - 1 through 4 (of 4 total)