An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.
FOR JSON PATH: Choose Whether NULL Properties Appear
FOR JSON PATH omits NULL properties by default. Compare INCLUDE_NULL_VALUES with missing properties and empty strings in a complete output example.
Tagging With a Many-to-Many Table: Storing and Querying Hashtags
Store hashtags in a tag and bridge table, normalize input, query any or all requested tags, and count weekly trends without scans.
SQL SERVER – Soft Delete – IsDelete Column – Your Opinion
Soft delete with an IsDelete column marks rows as deleted but keeps them. Michael J Swart dislikes it, and I agree. I share a similar story and ask your opinion.
Data, Log and tempdb File Placement: Checking Where Everything Lives
Check file placement for data, logs, and tempdb, inspect volume free space, and plan a Windows file move with a verified recovery path.
SQLAuthority News – Fathers and Daughters
My daughter turns one today and I feel so lucky to be a father of daughter. A few words on the special bond between fathers and daughters, with her photos.
Keeping a Change Log for Every Database
A change log for every database records what changed, when, why, and by whom, with a simple table and a habit of updating it.