Hi Paul

4 minutes down to 20 seconds is reasonable. Can you post the actual plan with the new indexes in place please? Let's see if there's more room for improvement.

Sean Lange (7/5/2012)

---

Sorry yesterday was a holiday here in the US. It looks...

You need a new index on MG_BOOKING_COMMODITY, on BOOKING_ID and include GENERAL_COMMODITY_CD & REEFER_FLG. This should improve performance by about 65%.

MG_BOOKING would benefit from an index on at least some...

icampbell (7/5/2012)

---

How do i search a string that contains 6 or seven characters but no spaces this is to identify incorrect postcodes

ie select pk,pcode

from postcode

where pcode like '%%%%%%'

Thanks,

...

The description's a bit vague so this is something of a guess:

SELECT [Column 1], [Datatime],[Column 2] , [Column 3]

FROM [test].[dbo].[upload] S

WHERE NOT EXISTS (

SELECT 1

FROM [test].[dbo].[upload] x

WHERE x.[Column 2]...

Hi Paul

Here's what I suggest you do.

First, comment out the three CROSS APPLY blocks and the references to their results in the output of the query, like so:

SELECT ...

Brandie Tarvin (7/5/2012)

---

So I have a non-SQL related WHOOT of my own. I got a 5 star review for my short story, Legend of the Beemen.

http://lasrsff.blogspot.com/2012/07/legend-of-beemen-by-brandie-tarvin.html

Excuse me while I bounce...

Cheers mate. It had to be done, and it was fun...

The third parameter of CHARINDEX makes it very useful for trivial string splitting. How would you...

Can you please post the actual plan as an attached .sqlplan file? Thanks.

Does the view really start with SELECT 1 FROM dbo.PayorHeader or is this a simplification?

Does this help?

DROP TABLE #Temp

SELECT Value1 = CAST(Value1 AS ntext)

INTO #Temp

FROM (

SELECT Value1 = 'XXX XXXX:Test Indexing:04 Environment and Approvals:00 Remote Operations Centre:01 Application:02 MDP:figures for MDP:Carrooda ANEF.pdf '

) d

SELECT...

It was an old version :blush: the updated one...

Hi Jeff

This one, which I'm pretty sure is the most recent:

ALTER FUNCTION [dbo].[DelimitedSplit8K]

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE WITH SCHEMABINDING...

ferrarielly (7/4/2012)

---

Hi,

the function is the following:

ALTER FUNCTION [dbo].[LI_Vista_RigheEvadibili_FiltrataFn]()

RETURNS @Results TABLE (Progr decimal(18,0),

codclifor varchar(7),

DOCTYPE varchar(3),

NUMDOC decimal(18,0),

AS

insert into @Results (Progr,codclifor ,DOCTYPE,

NUMDOC)

(select td.Progr,td.codclfor,

td.DOCTYPE,td.NUMDOC,

where extd.maglogisticaT=1 and

td.TIPODOC in ('AAA','BBB')

return

end

The td table is...