Aaron Bertrand (@AaronBertrand) compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Continue Reading »Jun 292015
Jun 242015
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.
Continue Reading »Jun 232015
With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.
Continue Reading »Jun 092015
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.
Continue Reading »Jun 052015
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.
Continue Reading »