Viewing 15 posts - 13,336 through 13,350 (of 14,953 total)
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...
June 17, 2008 at 8:43 am
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...
June 17, 2008 at 8:36 am
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...
June 17, 2008 at 8:34 am
You could use binary(16) for that, I think. Try that out.
June 17, 2008 at 8:31 am
It can definitely do what you're describing.
June 17, 2008 at 8:30 am
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...
June 17, 2008 at 8:17 am
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...
June 17, 2008 at 8:13 am
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...
June 17, 2008 at 8:09 am
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...
June 17, 2008 at 8:03 am
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...
June 17, 2008 at 7:30 am
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...
June 17, 2008 at 7:24 am
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,...
June 17, 2008 at 7:21 am
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...
June 17, 2008 at 7:15 am
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...
June 17, 2008 at 7:07 am
Viewing 15 posts - 13,336 through 13,350 (of 14,953 total)