Banker’s Rounding. What is it good for?
An in depth look at the implications of using Banker's Rounding.
2020-06-15
17,201 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)
5,354 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,454 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)
8,005 reads
Blogs
Redgate Clone Graduating Images
By Steve Jones
I wanted my own custom image in our internal Redgate Clone cluster, so I...
SQL Saturday Syracuse 2024 Recap
By alevyinroc
First Things First Thanks to every who came to my session, Asnwering the Auditor’s...
A New Word: Incidental Contact High
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Tablock to avoid deadlock
Hi, We have 4 stps. the flow of the stored procedure (stp) is as...
Question of the Day
Adding Features During a SQL Server 2022 Upgrade
I have a SQL Server 2016 SP3 instance that I want to upgrade to SQL Server 2022. I don't have replication installed, but I want to enable this on SQL Server 2022. Can I add replication during the in-place upgrade?
See possible answers