Date |
Title |
Rating |
2024-09-21 |
FIRST_VALUE, LAST_VALUE |
None |
2024-09-15 |
Approximate Percentile Functions |
None |
2024-08-27 |
MS SQL DATE_BUCKET |
None |
2024-08-06 |
The WINDOW Clause |
None |
2023-07-03 |
IS [NOT] DISTINCT FROM (The Distinct Predicate) |
None |
2023-06-28 |
MS SQL GENERATE_SERIES |
None |
2022-09-14 |
MS SQL TRIM, LTRIM, RTRIM |
5 |
2021-11-03 |
MS SQL STRING_SPLIT |
None |
2021-05-21 |
LEAST() |
None |
2021-05-20 |
GREATEST() |
None |
2020-02-04 |
HierarchyID data type Performance, tips & tricks |
None |
2020-02-02 |
HierarchyID data type Methods |
None |
2020-01-25 |
Hierarchical data in MS SQL |
None |
2019-11-16 |
Last Actual Plan with sys.dm_exec_query_plan_stats |
None |
2019-11-05 |
Memory-Optimized TempDB Metadata |
None |
2019-10-20 |
Accelerated Database Recovery (ADR) |
None |
2019-10-10 |
UTF-8 support in MS SQL 2019 |
None |
2019-10-01 |
Encrypt database backup step by step guide |
None |
2019-08-29 |
Approximate Count in MS SQL using APPROX_COUNT_DISTINCT |
None |
2019-08-20 |
Install MS SQL on Linux (Ubuntu) |
None |
2019-08-05 |
Scalar UDF are (not) evil? - SQL 2019 |
None |
2019-08-03 |
String or binary data would be truncated |
None |
2019-01-08 |
MS SQL Advice - COUNT(*) vs EXISTS |
None |
2019-01-08 |
MS SQL Advice - Use constraints |
None |
2018-12-23 |
HASHBYTES - Hashing in MS SQL Server |
None |
2018-12-13 |
Historical data with MS SQL System-Versioned (Temporal) Tables |
None |
2018-11-27 |
Modify JSON data using JSON_MODIFY |
None |
2018-11-21 |
MS SQL JSON functions, tips & tricks |
None |
2018-11-14 |
Read JSON data in MS SQL |
None |
2018-11-04 |
Format MS SQL data in JSON format |
None |
2018-10-23 |
MS SQL AT TIME ZONE |
None |
2018-10-17 |
MS SQL DATEDIFF_BIG |
None |
2018-10-07 |
MS SQL STRING_ESCAPE |
None |
2018-10-02 |
MS SQL COMPRESS AND DECOMPRESS |
None |
2018-09-25 |
MS SQL STRING_AGG |
5 |
2018-09-14 |
MS SQL CONCAT vs CONCAT_WS |
5 |
2018-08-23 |
MS SQL TRANSLATE |
5 |
2018-08-20 |
MS SQL FORMATMESSAGE |
5 |
2018-08-13 |
MS SQL CREATE OR ALTER |
5 |
2018-08-03 |
MS SQL DROP IF EXISTS (a.k.a. DIE) |
5 |