SQL DBA

SQLServerCentral Article

Exploring Parameter Sensitive Plan Optimization in SQL Server 2022

  • Article

PSPO (Parameter Sensitive Plan Optimization) is a SQL Server feature that improves query performance by accepting varied data sizes based on the runtime parameter value(s) specified by the customer. It deals with the situation in which a single cached plan for a parameterized query isn't the best option for all potential incoming parameter values. Non-uniform data distributions exhibit this phenomenon. When using PSPO, SQL Server keeps several execution plans for a single query, each one customized for a particular parameter value. With the help of this feature, numerous execution plans for a parameterized query are generated, each of which is tailored for a certain range of parameter values.

You rated this post out of 5. Change rating

2023-07-21

1,438 reads

Technical Article

5 (6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

6,820 reads

SQLServerCentral Article

Running SQL Server on Oracle and Google Cloud

  • Article

In this article, we will analyze the various out-of-the-box deployment options Oracle Cloud Infrastructure and Google Cloud Platform offers to host a Microsoft SQL Server database. This information can prove to be handy while deciding on the best cloud provider to host a given application or database.

4.2 (5)

You rated this post out of 5. Change rating

2022-02-18

6,216 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

Community at PASS Summit

By Ryan Booz

Comments posted to this topic are about the item Community at PASS Summit

Facing Error in Development

By hema41

Hi all As a seasoned developer, I had faced fair share of coding challenges...

ASCII value of certain column is null

By SQL_Surfer

When ASCII(Column) is null, what does it represent? Is this some kind of special/control...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers