Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.
Continue Reading »Feb 172016
Feb 112016
Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from int to bigint, detailing several challenging obstacles.
Continue Reading »Jan 292016
As part of a new series, Aaron Bertrand takes a look at what happens to the structure of a page when an INT column needs to be upsized to a BIGINT.
Continue Reading »Dec 042015
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 »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 »