I would also make sure to perform a backup before you make the change. The script is going to rename the existing table, create the new table strcuture, load the...

neil (12/6/2007)

---

Hi Antares thanks for that.

I tried running your modified version of the code, but the query did not run any faster unfortunately.

I also tried deleting the index on BIC/FZFIGL_C02...

Generally the query engine on short lists like this can do constant scans faster than temp table. In addition,...

Looking at it things look good as all the index lookups are seeks. However, I would still review and try all of my recommendations

1) Try my altered query and...

Halim Dahlan (12/5/2007)

---

Hi,

I'm new to ASP.NET and ADO.NET and was just trying out SqlParameter. How do I use SqlParameter to get a return code along with other parameters (input). I...

AUTO_FIX matches based on the user alias in the DB to a login account.

UPDATE_ONE allows you to specify the alias mapping to...

With regards to the question I view it this way.

Anyone can learn to program and can call themselves a programmer once they learn the basics.

What seperates them from the good...

Also it is common to see DISTINCT replaced by GROUP BY becuase of the way each is handled GROUP BY generally will perform faster. As well, you should always use...

Sorry I don't see it.

I will add that unless you have a significant amount of test data you may not be able to tell a difference becuae of the way data can be in...

I may just be misunderstanding you, do you mean SQL 2000 Enterprise Manager? If so then no you cannot connect.

If you mean you are running a query using OPENROWSET...

BTW another thought, is this true

[S2].[FISCYEAR] = N'2007'

Is FISCYEAR really an NVARCHAR column if not but is a VARCHAR do like so

[S2].[FISCYEAR] = '2007'

but if it is numeric do like...

Matt Miller (12/4/2007)

---

...and based on Antares' reformat - you might care to add on extra index per table covering each of the fields in the ON statement, and INCLUDE anything...

One note

mdp.[/BIC/FZFIGL_C02] Clustered index on KEY_ZFIGL_C02P

nonclustered nonunique index on KEY_ZFIGL_C02T

nonclustered nonunique index on KEY_ZFIGL_C02U

nonclustered nonunique index on KEY_ZFIGL_C021

nonclustered nonunique index on KEY_ZFIGL_C022

nonclustered nonunique index on KEY_ZFIGL_C023

nonclustered nonunique index on KEY_ZFIGL_C024

nonclustered...

This may or may not resolve the data a little faster but helps me a little bit if you can get the text version of the execution plan and post...