I have a stored procedure that will run daily. This SP will need to call another SP on a different server. To do this, I believe that I should be using sp_addlinkedserver, correct? The SP on t...
Hi experts,
I have a big text file (4 gigs; 7 million lines). I'm trying to import this to ACL, but found that it gave me an error "can only defineASCII file with carriage return/line feed ...
I am parsing a DHCP log with Log Parser 2.2. The results are exported to a .csv file and I need to reverse the IP address column.
The IP in the DHCP log is written like : 14.13.12.11
The...
Hi
I am currently drawing and ER diagram and am not sure about how to draw the diagram for the following: A bike must have at least 2 wheels but it may have more. The way that I would dra...
I am looking for a software package (unix or windows based) that can do complex plot point graphs.
What makes them complex is that I have several series. Each series represents a vechicles ...
Here is the file verification report:
Checking Integrity Slip
---ERROR---
The Paradox table appears corrupted.
Index version does not match table version
Index version does not match ta...
We are trying to configure Informatica LDAP. We can get connected to the LDAP server but are having difficult retrieving data. We are not certain what the syntax is for LDAP configuration sc...
Hello...
Is there any document or matrix that details which DBA Tools on the market are considered to be the best? There seems to be so many DBA Tools out there that it is hard to know which ...
Hi experts,
Please give me some trusted information about comparison between oracle 11g installed on Windows and oracle installed on Unix (linux, Sun os). Which is the best? I hesitate to cho...
I'm trying to update one table with values from another table, but am having trouble with the syntax being changed by VS 2005 which adds a Cross Join to my query.
Here is what I want to do:...
Hello.
I have an interesting challenge for you.
A little background:
Our product uses a relational database with data stored in FoxPro, SQL, or Oracle tables. For the tables involved in th...
Can someone give an simple example of V-Optimal Histogram and MaxDiff histogram?
I have a PDF text file that contains math equations and tabular content. I am looking for the best (hopefully free) utility to convert the content to MSWord while salvaging as much special cha...
I have a column of numbers in a table (Acess 2003) that I need to sort in order by the number itself ingoring the positive or negative factor
example
52.00
(16.58)
(3.00)
15.00
the r...
We are using SQL Server 2005 and I have been asked to begin a data warehouse project for our company. Although I'm comfortable with SQL, I know very little about data warehousing and I'm looki...
Hi guys,
Loooking for view / opinions on the following ( got a debate with someone so thought Id ask everyone here)...
Im going to comapre two ways in which i can see i could version gro...
