quote:

---

...Profiler your database for quite period time and feed the result into Index Tuning Wizard to identify the columns that need to...

Unless I am mistaken, something in your SQL just doesn't make sense. This part:

(Select top 1(traveler.travelerid)

from Traveler

where traveler.travelerid = workhistory.travelerid

order by traveler.travelerid) as Traveler --

doesn't...

quote:

---

...I think searching all my sp's for JOIN statements, and indexing any FK keys found there would be a better optimization. In...

Please post the schemas for both the access table and the sql server table. This will help identify likely troublespots. Thanks.

While that advice is a decent starting point; i.e. first look to foreign key fields used frequently in joins to place indexes on.

However, beware putting indexes on any field (foreign...

Please post the code so that we can analyze...

Thanks

No problem.

Go ahead and post your ASP script and I will take a look...

You're almost there:

CREATE PROCEDURE MyTransProc

   @Param1 DataType

AS

BEGIN TRANSACTION

-- do update/delete

IF @@ERROR <>...

Here's the link you'll need. Sorry for the wait...was on holiday...

http://www.devguru.com/Technologies/vbscript/quickref/formatnumber.html

As for number 2:

I would do the formatting of the decimal in your ASP code. But if you really NEED to do it in SQL, you must do a...

Ah, such is the way of business... Frustrating, isn't it? I can only recommend that you try to keep regular backup scripts of the schema, so that if they...

quote:

---

...protect against sql-injection...

---

Look into the proper use of QUOTENAME function to protect your scripts. ...

Could be any number of things, but it looks like this guy has same issue...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11748&FORUM_ID=9&CAT_ID=1&Topic_Title=For+the+love+of%2E%2E%2E&Forum_Title=General

Sort of. If I understand you're situation correctly, you are giving the user the ability to add multiple funds to a fund program through your application. I would...