What you might want to do is split the RAID 10 into two RAID 1s, and put data/index files on one and log files on the other. Then run...

Is the server seriously overloaded?

You can add those columns to the include part of the non-clustered indexes, which will reduce your bookmark lookups, but keep in mind that it will also slow down insert/update/delete...

I've seen that before in small tables. How many rows are there in the table the index is on?

The other thing you might do is rebuild the index by...

You could use binary(16) for that, I think. Try that out.

It can definitely do what you're describing.

What you might want to do is set up the Access database as a linked server in SQL. In Management Studio, under Server Objects, set up a connection under...

I created the following just by using the "Script Object as..." right-click functions:

/****** Object: StoredProcedure [dbo].[LookupTest1] Script Date: 06/17/2008 10:10:10 ******/

IF EXISTS (SELECT * FROM...

Take a look at ApexSQL's Doc product. It won't do all the work for you (as you mentioned), but it will do a lot of it, and make the...

It is possible.

Michael's idea of building a VBA script in Excel and using that might be better, might not, it depends on how much data you're moving around and how...

I often use GO between logical parts of a long script, to help me keep track of which parts are which. Even if it's not technically necessary, it can...

I see two options for this:

1. Continue to have the C++ application connect to it directly, without going through SQL.

2. Create a database on the SQL server, and connect to...

Try this:

select GL_ACCOUNT

from Trans

where isnumeric(GL_ACCOUNT) = 0

Most likely, that will find the fields you're having a problem with.

You can either add "and isnumeric(GL_ACCOUNT) = 1" to your Where clause,...

There's an upgrade wizard that can handle some DTS packages. MSDN has data on that. If it can't be done by the wizard, you'll need to rebuild it...

Try this, see if it gives the right results:

;WITH POH (OFFER_WID, SOURCE_WID) as

(SELECT OFFER_WID, SOURCE_WID

FROM W_SRC_OFFR_H

INNER JOIN W_PARAM_G

ON W_SRC_OFFR_H.ETL_PROC_WID = W_PARAM_G.ETL_PROC_WID

WHERE OFFER_WID != 0)

SELECT CHF.CONTACT_WID ,

COUNT(DISTINCT CHF.SOURCE_WID) ,

COUNT(DISTINCT...