Reputation
236
Top tag
Next privilege 250 Rep.
View close votes
Badges
2 11
Newest
 Commentator
Impact
~22k people reached

  • 0 posts edited
  • 0 helpful flags
  • 117 votes cast
1d
revised When to use sort_in_tempdb when rebuilding indexes?
added 88 characters in body
1d
comment When to use sort_in_tempdb when rebuilding indexes?
I edited my comment with my tempdb configuration. Thanks, Did not know about the serial online rebuild tip. I'll do some more testing and try to get with the SAN admin, who unfortunately has been less than welcoming. Are there any specific waitstats I should be comparing (ex. PageIOLatch)? Our tempdb writes are super high (4000ms) which is horrendous. Under 40ms for main DBs. That might be a question for another time though...!
1d
revised When to use sort_in_tempdb when rebuilding indexes?
tempdb configuration
1d
asked When to use sort_in_tempdb when rebuilding indexes?
Jun
26
awarded  Commentator
Jun
26
accepted XQuery on Extended Events joining with dm_exec_query_plan not working
Jun
26
comment XQuery on Extended Events joining with dm_exec_query_plan not working
Yes, that's it. I discovered it just a minute ago coincidentally. This can be closed or whatever needs to be done. Thank you.
Jun
26
asked XQuery on Extended Events joining with dm_exec_query_plan not working
Jun
4
revised INSERT INTO with TABLOCK taking longer than without TABLOCK
added 187 characters in body
Jun
4
comment INSERT INTO with TABLOCK taking longer than without TABLOCK
@Kin - No, it is not enabled.
Jun
4
revised INSERT INTO with TABLOCK taking longer than without TABLOCK
add image
Jun
4
asked INSERT INTO with TABLOCK taking longer than without TABLOCK
May
14
awarded  Yearling
Jan
7
awarded  Notable Question
Nov
13
comment How best to index large table with many index keys
Thanks @Aaron, I always keep those MERGE issues in mind. However in our case, those tables are only modifed by our ETL load and only during off-peak hours, so I don't think we're affected.
Nov
13
asked How best to index large table with many index keys
Oct
16
awarded  Popular Question
Oct
8
accepted Viewing how much transaction log is used in Simple Recovery Model
Oct
7
revised Viewing how much transaction log is used in Simple Recovery Model
added 71 characters in body
Oct
7
asked Viewing how much transaction log is used in Simple Recovery Model