• Developer 10g

    I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

    Kelp115 pointsBadges:
  • Storing archived information in SQL Server or on a SAN

    My company is storing PC files in SQL Server in an image field, and this data has to be archived. Due to our retention policy, the size of this data could grow to as much as 5 terabytes total, spread over 500,000 to 1,000,000 records. Should we store this data in SQL Server in an image field, or...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Deciding on configurations for SQL Servers

    My new server has 3 x 146GB SAS 15k 3.5" HD, which came pre-configured as RAID 5, and 2x 73GB SAS 15k 3.5" HD, which came as RAID 1. Should I leave this configuration as is or should I change it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • send data from sqlserver to ms access

    i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .

    Usjpcha10 pointsBadges:
  • Replicate Stored Procedures

    Is anyone aware of a tool to automate the replication of the Strored Procedures from one iSeries to another?

    Jma180015 pointsBadges:
  • Efficient storage of survey answers

    We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given...

    Eyoder5 pointsBadges:
  • SQL Stored Procedures

    I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL CHARACTER(4), INOUT FOUND INTEGER(2)) LANGUAGE SQL SELECT COUNT(*) INTO FOUND FROM...

    Jglyons15 pointsBadges:
  • Slowdown of the SAN due to overusage of temporary tables

    We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing a test system with SQL Server log files

    We need to implement a test system where the entries created in various tables on a test server need to be automatically re-generated on a live server so that there are no manual errors. We think the only way to do this is to use SQL Server log files. However, we are not sure that the tools...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Application transfering

    Do you know how a system (a Veritas Cluster System to be exect) automatically transfers an application from the primary server to the standby server in the case of a failure in primary server? Does the target need to pay a license for both servers in this case?

    BKDelNY5 pointsBadges:
  • SQL Connection

    Using VB6 How can I build a connection code to connect to SQL DB

    Khl5 pointsBadges:
  • DrawBacks of SSRS

    Hi I was asked this question in an interview?Please anyone help on it... 1)What are the drawbacks of SSRS? or What are the problems faced in SSRS?

    Sriradhi25 pointsBadges:
  • SQL Server 2000 to SQL Server 2005 migration

    Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason for that and how can we prevent...

    Vidukarth25 pointsBadges:
  • Converting data field into hours, minutes, seconds.

    How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?

    Tonya5 pointsBadges:
  • join tables with nested select count and group by

    hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno)...

    Bijendersverma5 pointsBadges:
  • Copying databases in SQL Server 2005 and SQL Server 2008

    In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do i replace a sql tables field value with another value

    I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE"...

    Ilfoprog50 pointsBadges:
  • Explaining features in SQL Server 2005

    I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Receiving an error consistently in SQL

    I receive the following error constantly in SQL: "Notice: Use of deprecated function sql_query in /var/www/html/includes/sql_layer.php on line 43 Notice: Use of deprecated function sql_fetch_array in /var/www/html/includes/sql_layer.php on line 64" It repeats over and over, and I am not sure how to...

    SQL Server Ask the Experts2,585 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