Thanks , pity TVF's are useful for filtering results

Hi Stewart , just trying to confirm , are you reffering to all your data striped across 6 physical disks in a single raid array ?

As stated RAID 50 array with 12 disks.

The strange thing is that i have executed the function and seen markedly quicker results , but the additional locks on tempdb were not there.

Not like they were when the...

I have the same scenario where i have a 12 disk raid array (Raid 50) for my sql server , but i have table with over 200 million rows ....

Even if you only have on raid set with many spindles do you not get the benfit of easier maintenance of indexes due to the partitioning ?

Thanks for your reponse stewart .

The database and tables have the same collation and there fore i should not have to force collation.

It seems to be something to do with...

Thanks for your prompt response.

At this point im fairly stumped , i could not find any visible locks on tables or any reason for the servers slow down. It just...

Sorry i know im in the 2005 forum , but in have a sql 2008 server and there is only sp 1 for the server.

Using DBCC checkDB it returns that...

HI

Wondering if i can jump on the band wagon here. I have a sql 2008 server and i can see in my Tempdb - Temporary Tables section that...

Once again thanks for all your help on this ,

I have used profiler to with showplan_xml to get the execution plan but there seems to be a limitation on viewing...

Thanks

How to i get the actual execution plan of running just a TVF , all i get back now is the TVF as 100%of the cost of the batch ,...

Hi

I can see that it would be difficult to assess my problem from the chunk of code i placed down. But i can assure you the only difference is...

Code without function wrapper (Much faster)

Declare @HierachyReturns TABLE (

[DataSourceId] Int,

[FundId] Int,

[EffectiveDate] DateTime,

[Rank] INT,

[PathKey] VARCHAR(100) ,

[ParentKey] VARCHAR(100) ,

[CategoryId]INT,

[HrchCatName]VARCHAR(100),

[MV]FLOAT,

[MVParent] FLOAT,

[CategoryWeight] FLOAT,

[CategoryWeightReturn] FLOAT,

[CategoryReturn] FLOAT,

[ParentCategoryReturn] FLOAT,

[PortfolioRelReturn] FLOAT,

[IDXReturn]Float

PRIMARY KEY (DataSourceId,FundId,EffectiveDate,PathKey)

)

DECLARE...