Aaron Bertrand (@AaronBertrand) walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.
Continue Reading »Dec 042015
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 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 »Mar 182015
Paul Randal (@PaulRandal) of SQLskills describes several ways clustered index fragmentation can sneak up on us, and how it can impact your workload.
Continue Reading »Jan 232015
Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.
Continue Reading »Jan 122015
Aaron Bertrand (@AaronBertrand) shows how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.
Continue Reading »