SQL

Optimize Your SQL by Reformulating the Spec

• by Phil Jacobs

• SQLServerCentral

• Aggregates
• Arithmetic
• arithmetic expression
• CTE
• math
• Performance Tuning
• PerformanceTuning
• Query Optimization
• Query performance
• Query Tuning
• queryperformance

• Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

Log in or register to rate

You rated this post out of 5. Change rating

2021-05-07 (first published: 2019-09-12)

5,228 reads

• Discuss

Dynamic SQL for beginners in 33 minutes

• by arthur

• SQLServerCentral

• Dynamic SQL
• T-SQL

• Article

Learn some of the basics of using Dynamic SQL in a short series of videos.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (5)

Log in or register to rate

You rated this post out of 5. Change rating

2019-08-12

8,143 reads

• Discuss

Previous Monday to the Start of the Previous Quarter

• by philmac750

• SQLServerCentral

• Script

Previous Monday to the Start of the Previous Quarter

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2019-07-29 (first published: 2019-07-18)

427 reads

• Discuss

SQL and T-SQL for Beginners in 229 minutes

• by arthur

• SQLServerCentral

• T-SQL

• Article

The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.5 (2)

Log in or register to rate

You rated this post out of 5. Change rating

2019-07-16

22,063 reads

• Discuss

Manage SQL Server Agent History More Effectively

• by Additional Articles

• MSSQLTips.com

• Agent

• Article

In this tip we look at how to build a custom approach to managing SQL Server Agent history data.

2019-04-12

SQL and NoSQL Database Features and Differences

• by Additional Articles

• MSSQLTips.com

• SQL

• Article

In this tip we will talk about the features and main differences between SQL and NoSQL databases.

2019-04-10

Converting a History Table into a System-Versioned Temporal Table

• by Additional Articles

• SimpleTalk

• SQL Server 2016

• Article

Temporal tables were introduced with SQL Server 2016. To take advantage of this feature, you might start fresh with a brand new table. It is possible, however, to convert an existing table with accumulated history to the new functionality. In this article, Mala Mahadevan explains how to create temporal tables for both scenarios.

2019-04-01

Creating CRUD Stored Procedures in SQL

• by Additional Articles

• Database Journal

• Stored Procedures

• Article

Back to the basics: learn how to Create, Read, Update and Delete operations are pivotal for any database application. Plus, you’ll see how to use Stored Procedures to manipulate data on the database side instead of on the application side.

2019-03-26

Introduction to SQL for Cosmos DB

• by Additional Articles

• SimpleTalk

• SQL

• Article

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

2019-03-25

219 reads

Resumable Online Index Create and Rebuild Operations

• by Additional Articles

• SimpleTalk

• SQL

• Article

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

2019-03-21

1,738 reads