I often find myself teaching mathematics to my daughter, and recently, she has been diving into the realm of Quadratic Equations.
SQL SERVER – Writing Function for The Rule of 72
I had a fascinating side conversation with a client that introduced me to a financial concept called the Rule of 72. Let us learn today.
SQL SERVER – Difference Between ISNULL and COALESCE
SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE
TRY_CAST vs CAST: Finding Rows That Will Not Convert Before a Load
Find text values that will not convert before loading, separate invalid and missing input, and use explicit date styles and culture parsing.
Approximate Percentiles With APPROX_PERCENTILE_CONT
Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.
Heartbeat Gaps: Finding Missing Check-Ins With LAG
Detect missing check-ins with LAG, report closed heartbeat gaps, and find silent or never-seen sources using an explicit UTC tolerance.
Performance Troubles – Function on Date Variable – SQL in Sixty Seconds #192
However, I have a really good reason to use that. Today we are going to discuss Performance Troubles – Function on Date Variable.