Fundamentals of Table Expressions, Part 11 – Views, Modification Considerations Itzik Ben-Gan returns to his table expressions series, covering what you need to think about when using a view to modify its underlying table(s). Itzik Ben-Gan ◆ September 8, 2021 0
Split strings the right way – or the next best way Aaron Bertrand (@AaronBertrand) explores some common approaches people use to split strings, complete with performance analysis. Aaron Bertrand ◆ September 2, 2021 25
The APPEND_ONLY_STORAGE_INSERT_POINT Latch In his ongoing series on latches, Paul Randal explores a latch you may experience in write-heavy workloads involving snapshot isolation levels. Paul Randal ◆ August 27, 2021 2
Bucketizing date and time data Itzik Ben-Gan shows us a new function in Azure SQL Edge, DATE_BUCKET, explains some use cases, and gives us alternative syntax until it is supported in all SQL Server platforms. Itzik Ben-Gan ◆ August 11, 2021 7
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
The FGCB_ADD_REMOVE Latch In his series on latches, Paul Randal dives deep on the mechanics of the FGCB_ADD_REMOVE latch class. Paul Randal ◆ June 22, 2021 3
Foreign Keys, Blocking, and Update Conflicts Paul White looks at foreign key blocking under read committed snapshot isolation, and related update conflicts under snapshot isolation. Paul White ◆ June 17, 2021 4
Fundamentals of table expressions, Part 9 – Views, compared with derived tables and CTEs Itzik resumes his series on table expression fundamentals, this time comparing views to CTEs and derived tables. Itzik Ben-Gan ◆ June 9, 2021 2
