DECLARE @xml xml =

N'<?xml version="1.0" encoding="utf-16"?>

<TBL_FACTOR>

<RD_FACTOR>

<ID>1</ID>

...

Any data modification query that affects an indexed view maintains the view directly in the query plan that...

shah.simmy (1/30/2012)

---

hi

i have a table Product like this CustomerId,Product,quantity

...

Koen Verbeeck (1/31/2012)

---

It's probably a language thing 😀

I understand that the optimizer can switch joins, but I'm confused by the "uneven rows" part.

I guess it doesn't matter if a table...

Expressing this sort of requirement using a logical (anti-) semi-join using EXISTS, INTERSECT, or EXCEPT seems more natural to me than introducing NULLs with an outer join, and then filtering...

This may be a language thing, but we are talking about...

Loundy (1/31/2012)

---

I've seen a few examples on the forums where some people have used a CTE with the row_number() function and others have used cross apply - I understand both...

Rob-350472 (1/31/2012)

---

Just wondering what you'd make of using nolock in this situation...

Running that query against a large set of customers appears to prevent others from adding a communication until the...

Yes you might need to...

Try this too:

SELECT

[Name1] = MAX(CASE WHEN tp.RowNum = 1 THEN tp.Name END),

[Name2] = MAX(CASE WHEN tp.RowNum = 2 THEN tp.Name END),

...

A second option:

SELECT

c.CategoryId,

c.NameCategory,

Top1.NameDetail

FROM dbo.Category AS c

CROSS APPLY

(

SELECT TOP (1) *

...

The optimizer has to choose one row source in a...

The optimizer considers different join...

Cool.

If you look at the query plan attached, even though it is very quick,...

The Read Committed isolation level guarantees two things:...