Paul White (@SQL_Kiwi) rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server sorts.
Continue Reading »Apr 292015
Apr 232015
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White (@SQL_Kiwi) concludes his series on ACID, transactions, and isolation levels in SQL Server with a great read on READ UNCOMMITTED.
Continue Reading »Apr 202015
Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.
Continue Reading »Apr 142015
For T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) gives a little detail on something he learned this week about altering a column from NOT NULL to NULL.
Continue Reading »Apr 082015
Tim Radney (@tradney) of SQLskills discusses addressing high severity errors in SQL Server – those with high severity (19-25) and the dreaded I/O error 825.
Continue Reading »Apr 012015
Paul White (@SQL_Kiwi) follows up on his thorough breakdown of indexed view maintenance with the details of a bug that can render an indexed view incorrect.
Continue Reading »