Ifyou want to retrieve the data from table 1 which is not there in table 2 and similarly data which is there in table2 but not in table 1. Then...

In most all cases (index or not), the simple "Jeff" function held it's own against the CLR (even after removing the "bit" penalty where it finally passed about half the...

Dwain, Just a small point

Why do you need CTE because this is more of a specifc requirement and if you have 4 districts then it will exceed 6100 unless...

Yesterday , I got a chance to read the thread fully. The cube method wont work as mentioned because you have some kind of mapping between districts but cube method...

Gullimeel (7/3/2012)

--------------------------------------------------------------------------------

set statistics io,time on

go

select SUM(ca.IsGuid) from myguid mg

cross apply

IsGuid(mg.myguid) ca

go

select SUM(ca.IsGuid) from myguid mg

cross apply

IsGuidGulliMeel(mg.myguid) ca

go

Sorry forgot to add that... I took the time for second run to...

I tried with 121317 rows..same...

That is possible.Are you going to call the function for each row in the table?Or are you trying to join the output of the function (where the output of function...

set statistics io,time on

go

select SUM(ca.IsGuid) from myguid mg

cross apply

IsGuid(mg.myguid) ca

go

select SUM(ca.IsGuid) from myguid mg

cross apply

IsGuidGulliMeel(mg.myguid) ca

go

Sorry forgot to add that... I took the time for second run to make sure...

You mentioned that you are getting 35 million rows.It is just returning 60K rows as i mentioned before your table has around 4K pages ( i could see the fragment...

I used your IVF and added my statement before your like statement as I did in the code snip...

drop FUNCTION dbo.IsGUIDGulliMeel

go

CREATE FUNCTION dbo.IsGUIDGulliMeel

(@pSomeString VARCHAR(100))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN

SELECT...

22Gb is the size of the table. It takes around 5 minutes to create the PK constraint. But as mentioned by Lynn, you should create it as Online = ON.It...

Actually, the target table has over 8M rows in it (47M in production) and we're inserting about 1.3M. The select tables are dropped and reloaded very time we import data...

Which one to test? Using the unqiueidentifier or the code snip i...

@jeff

I would add following.This will be more helpful if most of my rows are not guid.But if most of them are GUID the I might stick with what...

If you have replied based on below. Then I am sorry it was not about your query.It was query posted...