Search results for query: *

Is it possible to force a pdf file be read as a txt file? There is information included in the pdf that I want to search for and extract to another file. If I open the pdf in a text editor such as Textpad I can locate the information-- /Type /Annot /Subtype /CIINFO /Rect [ 0 0 0 0 ] /T...

I am not real skilled with subqueries so I am having a hard time with the syntax Here is the complete query SELECT SU_Name AS CABINET, SU_Key_ID2 AS DOCTYPE, SU_Value1 AS DOC_DESCRIPTION, SU_Value2 AS SUBFOLDER, (SELECT LEFT(SU_Value3, CHARINDEX('|',(SU_Value3))-1)) AS IDX, (SELECT...

There will always be at least one pipe.

I have a substring that I am trying to work out Here is the source data pattern. 8HTD9R|| or 8HTD9R||| or 1S494PX|1O00J2U|| I have taken the value before the first | and pulled it into a column. (SELECT LEFT(SU_Value3, CHARINDEX('|',(SU_Value3))-1))...

Thanks for the link but I am looking for opinions/experiences on in production environments.

7280-- Do you have this environment setup currently or is it planned?

We have recently had IBM come in and asses our 5.1.1 environment. They have recommended that we move to 6.1 ND with load balancing (edge server?). I was wondering if anyone can give opinions on-- Running WAS 6.1 on 64 bit server 2003: is WAS 64 bit or does it run as a 32 bit app? Any...

These are al helpful questions and I will answer them all at once-- The disks are RAID5 in 2 4 drive pool. It appears that there are 2 controllers-- 1 for each pool. As far as alignment I don't believe I have any control over this on the iSCSI box itself. However I do believe that from a...

There is no switch involved. This is connected via a cross over cable. So to clarify do I only need to set jumboframes on the NIC that is directly connected to the iscsi box?

Are jumbo frames just set on the NIC connected to the iSCSI box?

I have a windows 2003 server running BE 11d. I have a dedicated gbit nic for the public network and another gbit nic connected to a REO 4000 directly with a cat5e crossover cable. Most of the hosts I backup are conected via gbit nics. When I do backup to disk the best transfers I am seeing are...

The WWW server has alway been hardcoded to 100 full on both sides. I did find that the PIX's port config on the switch was set to auto and hardcoded to 100 Full on the PIX. I switched the PIX port conf on the switch to match but still don't see any appreciable improvement.

We use a Cat 6509 runinng IOS as our core switch. Connected to this is our internet access router, 2 PIX 515s, local switchs, and servers. We have multiple vlans setup to separate the DMZ of the pixs, the outside port of the pixs, and the internal network (less than 200 hosts). Recently we...

I have a column (DOCLOCATION) with data like C:\CIG\CIGdev\LETTERS\PRINT\DAILY\ACCTNG.PDF I would like to substring from the right to the first \ and get ACCTNG.PDF When I use SELECT RIGHT(DOCLOCATION, CHARINDEX('\',DOCLOCATION)) it returns PDF Any help would be appreciated.

works great! Thanks

I have a situation where there are multiple rows for one value (an insurance policy) that represent subfolders. I need a list of policies that do not have a certain subfolder. SELECT APP_FOLDER_TAB.AF_TITLE, CABINET_FOLDER_REL.CF_FOLDER_ID,CONTAINER_TAB.CT_TITLE_TXT FROM APP_FOLDER_TAB INNER...

The processor on the server averages about 30-40% during the process. The sqlservr process has never used more than 500%(spike) of the total processor (800%). The controller on the SAN is a HSG80 with 256MB of cache and is supposed to be able to handle over 24K IOPS SAN swap file.. I don't know...

We have a SQL 2000 box - Compaq DL580, quad xeon, 4gb ram -connected to an Compaq MA8000 SAN (not fiber channel). We are implementing a third party data mining application. When we run a day's worth of data into the system our disk transfer/sec increases from spikes of less than 75 to a steady...

yep...just found it in another thread... THANKS!

I have records to insert and want to evaluate if they are already present. If they are present I want to update fields if not I want to insert a record. I thought an IF..ELSE would be appropriate but because it is boolean I am not sure how make it work (or if it is appropriate) IF (SELECT...