내가 좋아할 만한 콘텐츠
Hey friends! Want to work somewhere exciting and fun? Great colleagues and perks? Make a difference in helping people find love and connection? Then check this out & apply or let me know if you want more info #sql #BigData #aws #sqlserver #databricks join.matchgroupcareers.com/careers/job/30…
Why does a 3000 line row-by-row INSERT script perform better with a GO after each statement than without? Script is only 481KB and takes a few seconds with GO and a few minutes without. It can’t all be parse/compile? #sqlhelp
Even though it's a pretty tiny read, it is executed hundreds of of times per second. Changing the FILLFACTOR from 100 to 80 resulted in either no change or slightly worse performance. Original tables did contain 50% fragmentation. Would like to know what else could be a factor?
#sqlhelp I have a query plan which doesn't change after an index rebuild incl. costs, rows, row size, etc. Even though reads & writes remain the same, worker time increases (0.1 to 0.6 ms). Reads are 99.9% logical reads, and back-end storage is high-end SAN. Any explanations?
#sqlhelp I have a query plan which doesn't change after an index rebuild incl. costs, rows, row size, etc. Even though reads & writes remain the same, worker time increases (0.1 to 0.6 ms). Reads are 99.9% logical reads, and back-end storage is high-end SAN. Any explanations?
Vancouver PASS Chapter Meetup August 2019 - Power BI Report Server: a Deep Dive by Luca Gualtieri, Co-founder & CTO PBILab this Thursday. Sponsored by #POF and our very own @SQLSocialite Don’t miss out, RSVP and details at vancouver.pass.org! #SQLServer #sqlpass #PowerBI
#sqlhelp optimizing indexes showed interesting impact when rebuilding sometimes: logical reads, worker time cut in half, but elapsed time doubles anyways. Could this be stats? No blocking wait diffs. Same test workload. Difference is use of parallelism.
If anyone is interested or knows someone who is, please pass them on to me for filling some careers. I can definitely vouch for how great it is to work at POF! Check it out here: #careers #businessintelligence #itdevelopment #itmanagement #poflife pof.com/careers.aspx?a…
#sqlhelp. I’ve reposted this question more clearly here about possible issue with DMV perf of dm_exec_query_stats: dba.stackexchange.com/q/202948/94927…
#sqlhelp weird issue with job to collect from dm_exec_query_stats INNER JOIN sys.dm_exec_cached_plans CROSS APPLY dm_exec_sql_text suddenly jumped in reads, writes, and cpu time 10x. No changes to code. Seems like autostats issue but how can it be fixed?
No we just impl. RG and moved on. It's been a week now and memory hasn't grown nor page life expectancy dropped since.
Yup, strange but true. We have 6TB of RAM, and memoryclerk_XTP consumed over 5TB, eventually paging out the buffer pool thrashing PLE too
Since RG is only in Ent. Ed., seems strange that it would be required. GC does not work for in-mem tbl variables only in-mem tbls.
We used to replace highly active user tables to queue notifications via push/pop. Ins/del ops mostly. Some table variable usage as well.
Would love to hear more about how you are using In-Mem in your environment. Tmp table replacement? User tables also?
United States 트렌드
- 1. Gabe Vincent 3,379 posts
- 2. Deport Harry Sisson 7,206 posts
- 3. #Blackhawks 2,050 posts
- 4. Angel Reese 48.6K posts
- 5. Mavs 5,558 posts
- 6. DuPont 1,549 posts
- 7. Blues 21.3K posts
- 8. #AEWDynamite 18.1K posts
- 9. #PokemonZA 1,372 posts
- 10. Lakers 17.8K posts
- 11. tzuyu 225K posts
- 12. Deloitte 5,589 posts
- 13. #VSFashionShow 549K posts
- 14. #Survivor49 3,471 posts
- 15. jihyo 178K posts
- 16. Nazar 6,682 posts
- 17. Tusky 2,226 posts
- 18. Birdman 5,010 posts
- 19. Hofer 1,732 posts
- 20. Mad Max 3,224 posts
Something went wrong.
Something went wrong.