Sorry GilaMonster, miss use of words. But i do get what you said.

Happens when I have 100s of things to do at the same time. 😀

Gila like I stated to Jeff, the function is not a must. See it as n lazy and resource expensive way of writing the query. The join is faster...

You are right Jeff. removing the RBAR UDF from the query and using a simple join does make the query almost 60% faster.

Just to clarify the use of those look-up...

Execution Plan for Query:

SELECT * FROM DATAS.tblDailyData

WHERE dbo.fnLKPInstrumentExchangeKey(InstrumentKey) = 4 AND DateKey = 20100101

I had to to make the where clause tak date into account otherwise it would have...

Not necessarily. Usually the CL column is the only one 60% of our users are interested in. But the more advanced users prefer to use Op, Cl, Hi, Lo, VWAP...

GilaMonster (2/2/2010)

---

roelofsleroux (2/2/2010)

---

A picture of the execution plan is near-useless. It's just a pretty picture without all the information that's in the properties and tooltips, which is what is really...

dbo.fnLKPInstrumentExchangeKey is used to find the ExchangeKey of an instrument whether it is JSE, LSE, NYSE.

Its basically to avoid JOIN statements. I have a suspicion that it could have and...

Just to add to all the info

Me and my System Administrator had a look at the server that runs SQL Server.

The Virtual Memory is set to 2GB out of the...

Hey you all

Sorry about the delay, internet problem.

Right!

To answer all your questions:

Gail: I have attached screenshot of the table structure, and execution plan for the following query

[font="Courier New"]SELECT *...

SERVER SPECS:

HP ProLiant ML350

2x Intel Xeon 2.50GHZ processors

4GIG RAM

I have reorganized, rebuild the index and even after that it still shows no change.

The Total Fragmentation is currently 15.2%.

I have to add that last week over 10,000,000 was added with SSIS package from 1500 csv files.

I kinda crashed our SQL Server using a [font="Courier New"]INSERT INTO tblX SELECT FROM tblY[/font] method. Haha!

After damage control, I decided to take a safer approach by using SSIS ......

The data I'm working with is Stock Exchange Closing Prices per Ric

This data will never change again but is used for statistical purposes.

The reason its in a temp table is...

I actaully used the following:

"[font="Courier New"]INSERT INTO xxx FROM yyy[/font]"

The statement was running for over 8min when one of the other developers noticed that his connection to SQL Server has...

Thanks for your replies everyone.

Seems one can always track n problem like this back to Database Design. I adjusted the design of the tables to include specific Grouping ID's that...