Ben von Ullrich
@benvonullrich
SQL Hax0r, 1st ever DBA at Sybase, now tracking cancer with Microsoft SQL Server
You might like
But we did learn that the average telephone call time in Italy is 4 times that of Slovenia hummm #PASSSummit
Dude next to me in the Amazon talk is falling asleep. We did just have lunch,,, #PASSSummit
Uh oh our analytics speaker is missing!! #mightneedtoBail #SQLSatRedmond
Alt-select w your mouse selects columns in sql editor! #SQLSatRedmond
You can now reorganize your clustered columnstore indexes #SQLSatRedmond
Sql keeps the col min and max in the columnstore metadata: no computing done at exec #SQLSatRedmond
Ok now downsides: Bulk load of rows in cci is fully logged. Also exclusive table lock. #SQLSatRedmond
Kalen had the second PC ever at Sybase (1st was in engineering), she *pioneered* PC tech support! Those were the days! #SQLSatRedmond
Hey #SQLSatRedmond! @benvonsql is the only person I know who's been using SQLServer longer than me. He gave me my 1st username and password.
Sql 2016 also supports snapshot isolation on clustered columnstore, enabling use of alwayson #SQLSatRedmond
In sql 2016, you can finally create a clustered cs index on a nc primary key : the pk references the columnstore #SQLSatRedmond
When you fetch from columnstore, you only need to fetch selected columns, not the whole row. That's the main benefit #SQLSatRedmond
All the data and index pages are compressed in a clustered column store you get to to 3..10x compression #SQLSatRedmond
Creating a cl CS index takes 1.8x a regular cl index due to compression. 10x faster queries up to 300x faster #SQLSatRedmond
United States Trends
- 1. TOP CALL 3,662 posts
- 2. #BaddiesUSA 64.9K posts
- 3. #centralwOrldXmasXFreenBecky 493K posts
- 4. SAROCHA REBECCA DISNEY AT CTW 513K posts
- 5. AI Alert 1,312 posts
- 6. Good Monday 25K posts
- 7. #LingOrmDiorAmbassador 263K posts
- 8. Rams 30K posts
- 9. Market Focus 2,479 posts
- 10. #LAShortnSweet 23.8K posts
- 11. Check Analyze N/A
- 12. Token Signal 1,741 posts
- 13. #MondayMotivation 6,881 posts
- 14. Vin Diesel 1,549 posts
- 15. Scotty 10.4K posts
- 16. Chip Kelly 9,107 posts
- 17. DOGE 178K posts
- 18. Ahna 7,834 posts
- 19. Raiders 68.2K posts
- 20. Stacey 23.3K posts
Something went wrong.
Something went wrong.