Viewing 2 posts - 1 through 2 (of 2 total)
Does the table has many NC indexes? Does it have triggers or is merge replicated ?
You could optimize files also (create several data files per that table, set decent FILEGROWTH...
January 18, 2013 at 11:34 am
#1578833
Wait type for inserts in PAGEIOLATCH_EX
For the Selects I see Clustered Key Lookups and Clustered Index Seeks. Actually these are all EDMX queries.
January 17, 2013 at 9:58 am
#1578397