Powerbuilder .net
when it going to release, i would like to know the cost.
Answer Question
| May 18, 2010 2:54 AM
PowerBuilder, Sybase
when it going to release, i would like to know the cost.
Answer Question
| May 18, 2010 2:54 AM
PowerBuilder, Sybase
SalesForce Developer
I have recenlty joined a Company as a salesforce developer. Please let me know how it is to make a career in this technology. .
Answer Question
| May 3, 2011 12:34 PM
IT career development, IT careers, Salesforce
I have recenlty joined a Company as a salesforce developer. Please let me know how it is to make a career in this technology. .
Answer Question
| May 3, 2011 12:34 PM
IT career development, IT careers, Salesforce
OLTP in Oracle
while using OLTP in Oracle 10g stanadard edition, does row level locking happen? What are its benefit?
Answer Question
| April 21, 2010 9:23 AM
OLTP in Oracle, Oracle 10g, Row Level Security
while using OLTP in Oracle 10g stanadard edition, does row level locking happen? What are its benefit?
Answer Question
| April 21, 2010 9:23 AM
OLTP in Oracle, Oracle 10g, Row Level Security
SQL query
I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION. questions are : 1)Display the first four rows of employee table. 2)Display the empno,ename from row 2 to row 5. 3) Display the empno,ename for employee of 2nd row 4) Display details of all even [...]
Answer Question
| April 20, 2010 3:58 PM
MySQL, MySQL admin, MySQL query
I have two database tables of employee where employee table maintains EMPNO,ENAME,JOB,MANAGER,HIREDATE,SALARY,COMMISION ,DEPTNO and department table maintais details of DEPTNO,DNAME,LOCATION. questions are : 1)Display the first four rows of employee table. 2)Display the empno,ename from row 2 to row 5. 3) Display the empno,ename for employee of 2nd row 4) Display details of all even [...]
Answer Question
| April 20, 2010 3:58 PM
MySQL, MySQL admin, MySQL query
Save or export vb 6 form
Hi, I have a vb project which displays information from a MS Access database on textboxes and Lables for names and other calculation records. i would like to export the form containing these textboxes and lables filled with data from the MS access database to either pdf, doc or any other file type for saving [...]
Answer Question
| April 19, 2010 3:44 PM
Access Database, Database import/export, PDF, save or export vb 6 form, VB 6
Hi, I have a vb project which displays information from a MS Access database on textboxes and Lables for names and other calculation records. i would like to export the form containing these textboxes and lables filled with data from the MS access database to either pdf, doc or any other file type for saving [...]
Answer Question
| April 19, 2010 3:44 PM
Access Database, Database import/export, PDF, save or export vb 6 form, VB 6
How to use Insert command between two servers to speed up performance
We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the [...]
Answer Question
| April 19, 2010 4:34 PM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance
We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the [...]
Answer Question
| April 19, 2010 4:34 PM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance
Which certification will benefit me
Hi I am a SAP (MM and SRM) functional consultant with work ex of 2 years. I always wanted to be in project management and during my tenure as SAP consultant I even got some opportunities to work with PM team. Now, I am looking for a change in my career. So, I am pursuing [...]
Answer Question
| April 21, 2010 8:02 PM
IT careers, PMP, Project management, SAP certifications, SAP Enterprise Resource Planning, SAP SRM, Supplier relationship management
Hi I am a SAP (MM and SRM) functional consultant with work ex of 2 years. I always wanted to be in project management and during my tenure as SAP consultant I even got some opportunities to work with PM team. Now, I am looking for a change in my career. So, I am pursuing [...]
Answer Question
| April 21, 2010 8:02 PM
IT careers, PMP, Project management, SAP certifications, SAP Enterprise Resource Planning, SAP SRM, Supplier relationship management
Creating a database in Access 2007
I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building [...]
Answer Question
| April 24, 2010 12:08 PM
Access 2007, Access Database, CREATE DATABASE statement
I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building [...]
Answer Question
| April 24, 2010 12:08 PM
Access 2007, Access Database, CREATE DATABASE statement
How useful is SCJP?
I am a third year IT engineering students,my aggregate percentage is not good,there are very less possibilities for me to get a job in on campus placement ,so do you think SCJP could help me getting a job
Answer Question
| April 21, 2010 9:20 PM
IT careers, SCJP, Sun Certifications
I am a third year IT engineering students,my aggregate percentage is not good,there are very less possibilities for me to get a job in on campus placement ,so do you think SCJP could help me getting a job
Answer Question
| April 21, 2010 9:20 PM
IT careers, SCJP, Sun Certifications
SQL 2005 Security to access 2 databases on same server via Stored Procedure
We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive “SELECT permission was denied on the object”. We have [...]
Answer Question
| April 16, 2010 8:33 PM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003
We are tyring to apply best security practices by only granting EXECUTE security to Stored Procedures connected to a Role and make users members of the role. However the SP needs to access data from another DB on the same server and when trying we receive “SELECT permission was denied on the object”. We have [...]
Answer Question
| April 16, 2010 8:33 PM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003
Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET
Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the comments section. You can also sign up [...]
Answer Question
| April 21, 2010 6:17 PM
Database, Exchange, Microsoft Live Chat, Oracle, SQL Azure database, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 R2, Windows
Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the comments section. You can also sign up [...]
Answer Question
| April 21, 2010 6:17 PM
Database, Exchange, Microsoft Live Chat, Oracle, SQL Azure database, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 R2, Windows
Access 2007 filters
when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.
Answer Question
| April 15, 2010 2:29 PM
Access 2007, Access 2007 functions
when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.
Answer Question
| April 15, 2010 2:29 PM
Access 2007, Access 2007 functions
Oracle 9i Migration from Solaris to AIX
Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at http://searchoracle.techtarget.com/answer/Migrating-Oracle9i-database-from-Solaris-to-AIX) but the article was from 10-09-2006. Is the solution provided still stands [...]
Answer Question
| July 24, 2010 10:48 PM
Database migration, Migration, Oracle 9i, Solaris, Solaris to AIX
Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at http://searchoracle.techtarget.com/answer/Migrating-Oracle9i-database-from-Solaris-to-AIX) but the article was from 10-09-2006. Is the solution provided still stands [...]
Answer Question
| July 24, 2010 10:48 PM
Database migration, Migration, Oracle 9i, Solaris, Solaris to AIX
Have you taken a shot at the Intel Open Port IT Scavenger Hunt?
If you’re answer is no then what are you waiting for? Get in the hunt! You could win… GRAND PRIZE WINNER: Dell Precision T7500 Tower Workstation FIRST RUNNER UP: $100 Amazon.com Gift Card SECOND RUNNER UP: $50 Amazon.com Gift Card THIRD RUNNER UP: $25 Amazon.com Gift Card IT Knowledge Exchange members receive 200 Knowledge Points [...]
Answer Question
| June 4, 2010 2:40 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP
If you’re answer is no then what are you waiting for? Get in the hunt! You could win… GRAND PRIZE WINNER: Dell Precision T7500 Tower Workstation FIRST RUNNER UP: $100 Amazon.com Gift Card SECOND RUNNER UP: $50 Amazon.com Gift Card THIRD RUNNER UP: $25 Amazon.com Gift Card IT Knowledge Exchange members receive 200 Knowledge Points [...]
Answer Question
| June 4, 2010 2:40 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP
Replicating a partitioned table to a secondary server
I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is done [...]
Answer Question
| September 16, 2010 3:31 PM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning
I have a rather large table of approximately 3 billion records. The table is partitioned into 24 monthly file groups, each with its own data file. I use a sliding window archiving solution to switch out data to our staging table, where it is then loaded onto an archiving database. The switch out is done [...]
Answer Question
| September 16, 2010 3:31 PM
Merge replication, SQL Server replication, SQL Server tables, Table partitioning
Retrieving data tables without backup SQL
If I truncate a table without the backup of it, how do I retrieve the table data?
Answer Question
| April 9, 2010 3:23 PM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables
If I truncate a table without the backup of it, how do I retrieve the table data?
Answer Question
| April 9, 2010 3:23 PM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables
View a concise list of all Job Schedules SQL Server 2000
I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can’t be sure. The number jobs I have makes this an onerous task. Is there a way to query the database [...]
Answer Question
| April 8, 2010 11:35 AM
SQL job scheduler, SQL Server 2000
I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can’t be sure. The number jobs I have makes this an onerous task. Is there a way to query the database [...]
Answer Question
| April 8, 2010 11:35 AM
SQL job scheduler, SQL Server 2000
Access 2003 – Setting Form’s Recordsource
Hi I have a SQL query which I know works. I tested it by creating a pass-thru query in Access and running the query below: SELECT PcSd.PRICE_SCHEDULE_ID, CASE WHEN PcSd.PRICE_LEVEL_CD IN ('BGA', 'BNG') THEN 'Brand' ELSE 'Generic' End As Price_Level, PcSd.PRICE_TYPE_CD, PcSd.DISPENSE_FEE_AMT, PcSd.MARKUP_PCT*-100 AS MARKUP_PT, PcSd.SOURCE_TYPE_CD FROM GAHPP0BD.RPT_PRICE_SCHEDULE AS PcSd Group BY PcSd.PRICE_SCHEDULE_ID, CASE WHEN [...]
Answer Question
| April 8, 2010 8:18 PM
Access, Access 2003, Access 2003 forms
Hi I have a SQL query which I know works. I tested it by creating a pass-thru query in Access and running the query below: SELECT PcSd.PRICE_SCHEDULE_ID, CASE WHEN PcSd.PRICE_LEVEL_CD IN ('BGA', 'BNG') THEN 'Brand' ELSE 'Generic' End As Price_Level, PcSd.PRICE_TYPE_CD, PcSd.DISPENSE_FEE_AMT, PcSd.MARKUP_PCT*-100 AS MARKUP_PT, PcSd.SOURCE_TYPE_CD FROM GAHPP0BD.RPT_PRICE_SCHEDULE AS PcSd Group BY PcSd.PRICE_SCHEDULE_ID, CASE WHEN [...]
Answer Question
| April 8, 2010 8:18 PM
Access, Access 2003, Access 2003 forms
In-Memory Processing Storage options
Is “in-memory”processing a reality? I am researching the viability of IMDS (IN-MEMORY DATABASE SYSTEM). RDBMs is rapid failing its ability to storage the data receive. This is just in the discussion stage. I am looking for evidence that is a viable possiblity in today’s business world.
Answer Question
| April 7, 2010 4:52 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
Is “in-memory”processing a reality? I am researching the viability of IMDS (IN-MEMORY DATABASE SYSTEM). RDBMs is rapid failing its ability to storage the data receive. This is just in the discussion stage. I am looking for evidence that is a viable possiblity in today’s business world.
Answer Question
| April 7, 2010 4:52 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
SCADA systems interview, any tips?
I have an interview on SCADA systems. Could anyone help with what kind of questions should i be expecting, they need someone with knowledge in everything right from communications,controls and database. (HArdware + Software).I dont have much experience on my resume but still they considered me for an interview so i am hoping they are [...]
Answer Question
| April 7, 2010 6:27 AM
Data acquisition, IT careers, SCADA
I have an interview on SCADA systems. Could anyone help with what kind of questions should i be expecting, they need someone with knowledge in everything right from communications,controls and database. (HArdware + Software).I dont have much experience on my resume but still they considered me for an interview so i am hoping they are [...]
Answer Question
| April 7, 2010 6:27 AM
Data acquisition, IT careers, SCADA
