Working with T-SQL function AVG ()
Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.
2022-07-01
2,572 reads
aggregate function
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,445 reads
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,375 reads
Blogs
Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger
By Steve Jones
There is a SET command in SQL Server that changes how much data is...
Secret management using Pulumi ESC SDK and Azure Key Vault
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Forums
install sql express
I yesterday dowload a sqlexpress and intalled on one of a testing database for...
The User Login
Comments posted to this topic are about the item The User Login
Using Feature Flags
Comments posted to this topic are about the item Using Feature Flags
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers