Handling Aggregations on a Poorly Designed Database
When the database design is not great, you may have to write some creative queries to get what you need.
2020-02-17
3,302 reads
aggregate function
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.
2019-09-12
2,851 reads
Blogs
Daily Coping 27 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
Forums
Tlog migration
Hi Expert, In tlog migration, from 1 server to another where there is no...
RegisterAllProvidersIP = 0 and timeout in failover
Good morning all , I have an alwayson instance with a multisubnet listener I...
Tempdb increasing crazily
These days, the Tempdb of my one's SQL server increases crazily, sometimes only abount...
Ask SSC