CTE

SQLServerCentral Article

Optimize Your SQL by Reformulating the Spec

  • 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)

You rated this post out of 5. Change rating

2021-05-07 (first published: )

5,365 reads

SQLServerCentral Article

Cursor-Killing: Accessing Data in the Next Row

  • Article

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? This first part in an ongoing series of cursor-killing handles inter-row analysis.

4.86 (94)

You rated this post out of 5. Change rating

2015-12-18 (first published: )

22,626 reads

Blogs

Heading to 2024 PASS Summit

By

I am able to head back to Seattle for the PASS Summit this year....

Tell me the positives of your solution

By

I still have a tendency to talk about all the cons of a proposed...

Monday Monitor Tips: Projecting Disk Space

By

One of the things that many DBAs struggle with is managing space across an...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

SSISDB Folder creation Error

By PravSat

We recently installed SSIS on SQL Server 2022 machine. Trying to create a folder...

Query is timing out

By LearningDBA

I have a view on ServerA that fetches some data from ServerB and ServerC....

Visit the forum

Question of the Day

AUTO_DROP Statistics

In SQL Server 2022, what does this statement do?

CREATE STATISTICS CustomerStats1 ON DimCustomer (CustomerKey, EmailAddress) WITH AUTO_DROP = ON

See possible answers