Im not to surprised by that.

You need to follow the advice give in the link i gave earlier , it still doing table scans which are making any possible gain...

Glad to help , though as far as correct goes, there are other methods that may be...

First Off

Inner joins and Outer joins are functionly different, so a performance comparison is irrevlant.

The true answer is , It Depends.

The different join types (Merge , Hash ,Loop)...

Please post the execution plan.

http://tinyurl.com/2u93g8g

If you *Have* to search for a title that contains the text contained in @keyword within in , then full text searching may be a viable alternative.

Try this link

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2009/08/27/sql-and-contiguous-data-ranges.aspx

Hi,

Please see this link http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

Similar to ..???

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/02/20/the-xp-sp3-msxml6-sp2-sql-server-debacle.aspx

From what i can gather....

the install of msxml6 failed.

Looking at its log (SQLSetup0003_AERO70413_MSXML6_1)

I see...

"This package is not supported on this operating system"

The Error 2's look like they are pretty irrelevant...

Good stuff,

just be sure sure that you understand the assumptions made in the code.

an out will always follow an in

the source data will always start with an in.

Thats scarily close to an advert 😉

untested but should be what you are after...

with cteDeviceMovements

as

(

SELECT dm.deviceId,

m.movementId,

m.date,

Row_number() over (partition by dm.deviceId order by m.movementId)%2 as Rown

FROM dbo.DeviceMovement dm

INNER JOIN dbo.Movement m

ON dm.movementId = m.movementId

WHERE m.sourceLocationId =...

There are DMV's that may show you the queries that have been executed and still in cache.

The obvious issue is that not all the queries may be in the cache...

A server side trace is (very ?) light

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/01/trace-profiler-test.aspx