Reputation
297
Top tag
Next privilege 300 Rep.
Create new tags
Badges
4 14
Impact
~30k people reached

  • 0 posts edited
  • 0 helpful flags
  • 139 votes cast
Jan
20
awarded  Popular Question
Jan
17
awarded  Popular Question
Jan
5
accepted When to use sort_in_tempdb when rebuilding indexes?
Dec
14
accepted Where clause to filter rows for Azure Stretch Database?
Nov
13
asked Error scripting data using SQLPSX Powershell?
Nov
4
asked Where clause to filter rows for Azure Stretch Database?
Oct
21
accepted Estimated row size and estimated data size is incorrect
Oct
21
comment Estimated row size and estimated data size is incorrect
Thank you @Martin!
Oct
21
comment Estimated row size and estimated data size is incorrect
Sorry, another followup question - why would actual data size be 40GB too? Because that's the grant that was estimated? So will estimated data size and actual data size usually be the same then?
Oct
21
comment Estimated row size and estimated data size is incorrect
Ah ok, that's kind of what I thought. Didn't know about the engines formula for column capacity. I was hoping it would use something along the lines of what's in dm_db_index_physical_stats or maybe stored in stats somewhere. Is there any other solution besides decreasing the column sizes? Updating stats with FULLSCAN? The performance impact is the overhead of getting an overestimated memory grant (which I guess is better than an understimated grant).
Oct
21
asked Estimated row size and estimated data size is incorrect
Aug
27
comment How to trace an SSIS package using Extended Events?
@AaronBertrand Yes, that would be the only thing for this database. From a SQL Task, the application name (client_app_name) is Microsoft SQL Server.
Aug
27
asked How to trace an SSIS package using Extended Events?
Aug
21
awarded  Notable Question
Aug
4
asked Finding when a currently running Extended Events session started?
Aug
4
awarded  Caucus
Aug
4
awarded  Constituent
Jul
31
revised When to use sort_in_tempdb when rebuilding indexes?
added 88 characters in body
Jul
31
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...!
Jul
31
revised When to use sort_in_tempdb when rebuilding indexes?
tempdb configuration