Optimizer

An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(43)

You rated this post out of 5. Change rating

2009-10-28

7,967 reads

Blogs

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Often we find out about a problem reported by a customer after the incident...

Let’s face it, most of the time, you probably don’t want your SQL Server...

Comments posted to this topic are about the item Improving the Performance of UPDATE...

Comments posted to this topic are about the item Replacing a Null

Comments posted to this topic are about the item The End of SQL Server...

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;