quote:

---

When one customer is modifying their extended table, would we see locking issues on the primary table for customers other than the...

It's because banner manager pro is using an IFRAME element to display the ad in your browser; since IFRAME is a windowed element, and the menu is not (it's implemented...

Hmmm, surprised no one mentioned this yet:

Use:

SET NOCOUNT ON

where appropriate. It limits the amount of code passed between application tiers.

🙂 Even the little things add up...

...

Personally, I think 2 is actually your best option. The cons that you outlined I don't see as drawbacks, actually. You can easily add powerful join indexing simply...

Use DTS to import the csv file. Look in Books OnLine for tutorials on how to use this tool from Enterprise Manager.

CREATE TABLE #temp1 (key INT , string VARCHAR(10))

INSERT INTO #temp1

SELECT geoid, CAST(x AS varchar(3)) + ',' + CAST(y AS varchar(3)

FROM my_table

CREATE TABLE...

Wrap all your EXEC dynamic statements into a stored prcoedure. Then, store the result of your store procedure in a temp table:

DECLARE @RetrievedValue CHAR(10) --...

Not sure what you mean by "cannot find it"...What you want to do is go to the SQL Server Agent --> Jobs --> Right click the job you need -->...

If you INNER JOIN your tables to an empty table, you will always insert 0 records, since the JOIN won't find any matching records. I believe you want something...

If you are dealing with 50 calls/minute and returning very large datasets, I would imagine that paging will be the least of your concerns. I'm not quite sure what...

If you want to post the VB code, I can take a look. We have successfully used COM+/MTS components here for a while and have gone through the gammet...

Basically, stored procedures and views are more maintainable, produce less network traffic (you don't have to send a giant SQL string across the wire). The compilation plans for both...

You might consider caching the dataset returned and using logic in your web page/ COM component to handle the paging...

Just a thought,

Jay

Create a stored procedure that does the required data manipulation, then assign the Job to run the stored procedure:

"EXEC my_stored_proc [args]"

Please post the structure of your Invoice table...it will help in determining the sql for your problem...

Thanks