Archive

MS SQL (37)

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

Total

37 posts
8 raters