Query Optimization

SQLServerCentral Article

5 (4)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

10,579 reads

SQLServerCentral Article

Optimized Plan Forcing with Query Store in SQL Server 2022

  • Article

In this Article ,  We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

5 (1)

You rated this post out of 5. Change rating

2023-09-04

4,606 reads

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,376 reads

External Article

The Query Optimizer: Date Correlation Optimisation

  • Article

In SQL Server 2005, a feature was introduced that was hardly noticed, but which might make a great difference to anyone doing queries involving temporal data. For anyone doing Data Warehousing, timetabling, or time-based pricing, this could speed up your queries considerably. Who better to introduce this than Query Optimizer expert, Fabiano Amorim?

2009-10-26

3,485 reads

Technical Article

Statistics Used by the Query Optimizer in Microsoft SQL Server 2008

  • Article

Microsoft SQL Server 2008 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes what data is collected, where it is stored, and which commands create, update, and delete statistics. By default, SQL Server 2008 also creates and updates statistics automatically, when such an operation is considered to be useful. This paper also outlines how these defaults can be changed on different levels (column, table, and database).

2009-07-24

2,506 reads

Blogs

Using a Local Large Language Model (LLM): Interacting with Local LLMs Using PowerShell

By

As AI continues to evolve, many of us are looking for ways to leverage...

Monday Monitor Tips: Finding the Hostname for Queries

By

I was chatting with a customer recently and they wanted to know which host...

Can AI Read Execution Plans?

By

Yeah, yeah, second AI post in a row. I promise not to make a...

Read the latest Blogs

Forums

SSIS Won't Create Log Entries

By water490

Hi everyone My SSIS package will not log to sysssislog.  I am not sure...

SQL Server is terminating in response to a 'stop' request from Service error

By naga.rohitkumar

Dear All, In one of the server its repeatedly restarting sqlserver services and not...

Visit the forum

Question of the Day

Database Files on Shares I

I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?

See possible answers