We have launched a new, bi-weekly newsletter to offer you the freshest content from our blogs and beyond. Subscribe at: https://sentryone.com/community.
Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.
Tim Radney (@tradney) discusses some aspects of the msdb database that probably require more attention than they currently get in a lot of environments.
Aaron Bertrand (@AaronBertrand) compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Aaron Bertrand (@AaronBertrand) shows the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.
For T-SQL Tuesday #67, Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
