Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
2020-06-15
7,987 reads
math
Optimize Your SQL by Reformulating the Spec
As SQL developers, we tend to think of performance tuning in terms of crafting the best table indices, avoiding scalar and table valued functions, and analyzing query plans (among other things). But sometimes going back to the spec and applying some properties of elementary math can be the best way to begin to improve performance of SQL queries which implement mathematical formulas. This article is a case study of how I used this technique to optimize my SQL implementation of the Inverse Simpson Index.
2021-05-07 (first published: 2019-09-12)
4,666 reads
SQL for 8-year-old Math…But Be Careful of Implicit Type Conversion
How we can use SQL to solve a math problem published in The Guardian...but with a caution about implicit type conversion.
2015-07-14
7,329 reads
Integer left and right shift
3 functions that implement the left (<<), right (>>) and unsigned right (>>>) shift operators, commonly found in C-style languages.
2012-02-15 (first published: 2011-12-30)
5,696 reads
Blogs
WIT Mental Health and Wellness Videos Posted
By Steve Jones
I was honored to speak at the WIT Mental Health and Wellness day last...
Daily Coping 13 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell...
Forums
Limit database restores to specific drive locations
As there isn't an option to use a DDL trigger on a RESTORE query,...
VLOOKUP Equivalent in SQL
Hi there I have two tables, one with an ID and Amount (Table 1)...
The Gift of Asking Stupid Questions
Comments posted to this topic are about the item The Gift of Asking Stupid...
Ask SSC