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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 8:43 am
Is the server seriously overloaded?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 8:38 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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 8:34 am
You could use binary(16) for that, I think. Try that out.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 8:31 am
It can definitely do what you're describing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 17, 2008 at 7:07 am
Viewing 15 posts - 13,336 through 13,350 (of 14,953 total)