How do I use primary keys in SQL server?
I have a table called course,and course_id is primary key in this table. I created another table subject.I mapped these 2 tables by course_id as foreign key,I  created another table teacher,i want to map this with subject, only subject_id to teacher_id mapping is required,how i mapp this,can i use course_id?  

Answer Question   |  September 9, 2010  7:03 AM
Primary keys, SQL, SQL Server, SQL tables

How to remove consistency check in lotus notes?
How to remove conistency check in lotus notes? Because everytime when i used to access my archieve data base takes longer time to open…Is there any option is there to cancel the consistency check? 

Answer Question   |  September 27, 2011  6:14 AM
Consistency Control, Database Consistency Checker, Lotus Notes, Lotus Notes administration, Lotus Notes configuration

Interview preparation
I have 34 years of IT experience and has been retrenched a few months ago. As you can imagine it is hard to find new employment at my age. I mostly worked in a development environment, but lately only did Account Management. I spent a short time doing maintenance on a system, which confirmed that [...]

Answer Question   |  September 13, 2010  12:27 PM
IT career development, IT career planning, IT careers, IT industry, IT structure, SDLC

Display External File Properties in Excel
I have an MS Access database that uses two tables (tblOrders1 and tblOrders2) that are linked to two MS Excel spreadsheet files (Orders1.xls and Orders2.xls). The Excel spreadsheet files are occasionally updated by being replaced with new files with the same file names. I want to continuously display the Excel files “date modified” dates on [...]

Answer Question   |  September 7, 2010  5:25 PM
Access 2003, Access Database, Excel 2003, External file properties, Office 2003, Windows XP

SQL Express 2005 query times lagging
I execute some simple queries on my own system’s sql server express 2005, the executions time is under 1 second but when I execut the same queries on our server’s sql server express 2005, the queries execution time is about 3 seconds or more and I don’t know why. both of the systems have the [...]

Answer Question   |  September 15, 2010  7:40 AM
SQL Express 2005, SQL queries, SQL Server, SQL Server performance, SQL Server Query

IT career education qualifications
does edu qualification affect it career?eg. I am a commerce graduate and gniitian will it work?

Answer Question   |  November 4, 2010  5:55 PM
IT career development, IT career planning, IT careers, IT education

DB Table/Query Layout for Ranking System
Hello, I’m building a Membership DB where Members can achieve certain ranks (Rank1 – Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them. [...]

Answer Question   |  September 2, 2010  10:09 AM
Access 2007, Access Database, Access query, Database, Query

In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?
In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks

Answer Question   |  September 2, 2010  11:14 PM
Access 2007, Access 2007 functions, Access Tables, File locks, Windows 7, Windows 7 in 2010

Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

Answer Question   |  November 3, 2010  8:14 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration

Are you worried about IT job security?
With new, amorphous offerings such as the cloud and SAAS, are you worried at all about your position or department being outsourced? It seems IT is always under construction; is it a matter of certain positions becoming obsolete or is IT simply being rearranged and retitled? Is this something you or your company’s directly dealing [...]

Answer Question   |  October 13, 2010  7:25 PM
Cloud Computing, IT careers, IT job situation, IT jobs, Open IT Forum, Outsourcing, Outsourcing services, SaaS

Connect JasperServer and Sql 2008
i tired these steps : # Download the Microsoft JDBC driver: Microsoft SQL Server JDBC Driver # Extract to a good location. I chose c:program files to extract to. # Copy the sqljdbc4.jar to your installation directory which by default is: c:program filesjasperserver-pro-3.5.1apache-tomcatwebappsjasperserver-proWEB-INFlib # Restart JasperServer (there is a shortcut in the start menu to [...]

Answer Question   |  September 1, 2010  4:03 AM
Jasper, JasperServer, JDBC, SQL, SQL 2008, SQL Server 2008, SQL Testing

how to limit data access on AS400 through ODBC, client access or Sequel viewpoint product
[strong]User profiles are assigned a group on our iSeries, and the group has object authority to the data files. What data they can actually see and update is controlled by the application, limited by menu travel and other security parameters built into the system. My issue is with Client Access, ODBC or 3rd party SEQUEL [...]

Answer Question   |  September 1, 2010  2:03 PM
AS/400, Data access, iSeries Access, ODBC, SEQUEL ViewPoint

Updating database index
when i create a table with nearly 100 rows, database index gets update to accomodate those 100 rows. Can i find out the time taken by the index to get updated from previous state to a state to accomodate those 100 rows?

Answer Question   |  August 31, 2010  7:18 AM
Database, Database index strategy, Database management, Indexing, SQL Database Indexing

Running Profiler, an update statement show reads but no writes?
Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = ’29-Aug-2010 01:23:24 AM’ WHERE UserKey = ‘M’[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td] [td]2010-08-29 01:23:24.407[/td] [td]0[/td] [td]1[/td] [td]2[/td] [/tr] [/tbody] [/table]

Answer Question   |  September 7, 2010  2:16 PM
SQL 2005, SQL Profiler, SQL Server 2005, SQL Server 2005 administration, UPDATE statement

Sap enterprise portal
Future opportunities in Sap EP

Answer Question   |  March 24, 2011  10:28 AM
IT careers, SAP careers, SAP Enterprise Portal, SAP EP

Career advice: Software versus Networking
Dear Sir , I am a lecturer in Engg College in Andhrapradesh Lot of my students asking .. which is good carrer .. Going to software side is good . Or Going to Netoworking side by doing courses like MCSE /CCNA /RHCE etc is good … Which side is giving more stable career and good [...]

Answer Question   |  September 1, 2010  6:03 AM
802.11 networking equipment, IT career planning, IT careers, Networking careers, Software development, Software Test Engineer

Substring A Packed Field
Hello I have a flat record format that I move into an external data structure. Within the external data structure, I have many packed fields. Rather than refer to each of pacekd field by external field name, I would like to be able to substring each packed field out, and then, move the value of [...]

Answer Question   |  September 3, 2010  4:13 PM
Array, Data Structure to Flat File, Data structures, Flat files, Packed Fields, Substring

Merge two datasets in a DO loop
I have two datasets like this: data1 : store sales1 sales2….sales52 1 2 3 . . 10 data2: Store sales1 sales2…..sales52  1 2 3 . . . 100   okay, now what I want is to take the first row of data1 merge it with data2, take the difference of sales between the observation from [...]

Answer Question   |  September 21, 2011  3:44 PM
DO LOOP statement, MERGE statement, SAP Business Intelligence, SAS, SAS Business Intelligence software, SAS Data Analysis

Will the SQL performance improvements in V6R1 affect QUERY?
Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

Answer Question   |  September 17, 2010  3:13 PM
i5, SQL performance, SQL queries, SQL Query, V6R1

Prophet 21 Database Dictionary
Is there a data dictionary for the prophet 21 database? I am looking to create applications that use data stored by prophet 21 software. Is there available software to interface with prophet 21 data?

Answer Question   |  August 27, 2010  2:20 PM
Application software, Data Dictionary, Database, Prophet 21, SQL, SQL Database