You want faster inserts right? You only see PAGELATCH_EX waitstats and have some cpu power? Can inserting data into a table using OPTIMIZE_FOR_SEQUENTIAL_KEY go faster? Why not find things out in this post — it has what most posts about…
Ola Hallengren does a great job with his IndexOptimize ( SQL Server Index and Statistics Maintenance ). . Discussion note from working through Jeff Moden’s ( (10) Jeff Moden | LinkedIn ) “Black Arts Index Maintenance #1.2 – GUIDs v.s.…
Blocking and Locking is used by the database engine to make sure the data is reportedback to you correctly, and never use WITH(NOLOCK) queries in production.Why? there is a change you report values incorrectly (data moves between pages or there…
