The DBCC_OBJECT_METADATA Latch Paul Randal continues his series on latches, showing how computed columns can really slow down DBCC operations. Paul Randal ◆ July 27, 2021 1
Fundamentals of table expressions, Part 10 – Views, SELECT *, and DDL changes Continuing his series on table expressions, Itzik Ben-Gan explains why it is a bad idea to use SELECT * in views. Itzik Ben-Gan ◆ July 14, 2021 0
UI Design Patterns That Don't Scale Michael J Swart takes a look at a few common UI design patterns that don't necessarily scale well with SQL Server. Guest Posts ◆ July 8, 2021 1
Deprecated features to take out of your toolbox – Part 3 As part of a long game on deprecated SQL Server functionality, Aaron Bertrand questions why anyone is still using text / ntext / image. Aaron Bertrand ◆ July 1, 2021 0