• SQL performance vs. Internal pgogram database access

    Is SQL access to a database faster than using the file internally within a program? Assuming that the following: The program was coded to use the keyed index. The SQL statement is coded to use the index that exists on the logical in the most efficient manor.

    Crookedpinkies0 pointsBadges:
  • SQL SERVER 2005 Database Options

    We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

    Rick Martinez585 pointsBadges:
  • SQL Server 2005 Memory

    I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro's that sql server can only use 4GB of RAM is that true?

    Rick Martinez585 pointsBadges:
  • Help needed for connect statement using sqlrpg

    Hi All, I need to do some checking in 2 different AS400 servers. I will read the data from one server(say local) then using connect type 2, connect to the other server(say remote), check the data and then returns back to my local server. I'm using sqlrpg for this and created 2 pgms for this. One...

    160780 pointsBadges:
  • Can I use filler to skip a column in a csv file on SQL*LOADER rel 8.0.6.3.0

    We are running Oracle E-business suite 11.5.10.2 on db 9i but when I execute sql*loader it gives me version 8.0.6.3.0. Is the key word FILLER available for me to use to skip unwanted columns in a comma delimited input file? I know FILLER became a key work in 9i - is that the db 9i? Why is my...

    Meb10 pointsBadges:
  • Why does SQL server use no more than 500MB in RAM?

    Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use 29GB. Our database is...

    Rick Martinez585 pointsBadges:
  • NTVDM encountered a hard error installing SQL 2000 onto Windows Server 2003

    Trying to install SQL server 2000 on windows 2003 Server SP2 I got ntvdm encountered a hard error. Please help

    Mamamama5 pointsBadges:
  • openquery no records returned SQL Express 2008

    I run theis procedure against a link server (Quickbooks) It runs with no errors but will not return records. SELECT   *   FROM QODBC ...Customer

    Dendic5 pointsBadges:
  • Any Python use?

    I know of a port to iSeries from way back. Wondering if there much use? I find that for some tasks, it can be more expressive than RPG. Especially useful if you have an ORM to help with table / SQL generation. Or if you want object orientation.

    Jorjun110 pointsBadges:
  • SQL Server Profiler

    What numbers are considered high when using sql server profiler for reads, writes, and duration

    Rick Martinez585 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    We want to upgrade our SQL Server 2000 to SQL 2005. What should we watch out for and what is the actual procedure for the upgrade? Will it require another server or can the upgrade be done in place?

    NewnanIT1,110 pointsBadges:
  • How to count the common column rows in the table for each column and row…..

    I have a table and that table have columns like d1,d2,d3,d4....... d1      d2    d3    d4 --------------------------- 200   300   100  300 100   200   101  101 300   ---    300  200 how can i display the output like below...  for each row.... ColumnD1 Count 200    3...

    Paanduranga15 pointsBadges:
  • web-based GPS tracking application development with asp.net

    i'm a final year degree student majoring in network computing.  i'm developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on...

    Veriya30 pointsBadges:
  • Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 pointsBadges:
  • Production SQL Database has been restored with Old database backup

    Dear Expert, I need your Advice, today in morning i run Symantec backup restore on SQL 2008 server where i overwrite the production Database with Old backup. Is there any way i can retreive the old Database until yesterday. i dnt have any backup of New database which i accidentally overwritten.  ...

    Aleem60015 pointsBadges:
  • SQL Server I/O

    Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of...

    Rick Martinez585 pointsBadges:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • To increase number and combine data using sql

    hi, I want to create a sql that generate a number of 4 digits with combination of character input.The number will increase if it is new record. for example : category = 'P' so the output will be :  P-0001 for the next record the output will be : P-0002 any ideas? thanks.  

    Syirah5 pointsBadges:
  • Migrate MYSql database to SQL 2005

    We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell470 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following