1
  • Oracle 9i Designer

    Do you have any opinions on the use of Designer versus a tool like Erwin or PowerDesigner in handling the following concerns: Database generation Reverse engineering Accurately representing every detail of a database Speed Use for different DB platforms Thanks for any comments.

    Pegasusdba0 pointsBadges:
  • Database modeling question

    I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we're deep into data modeling. We can't agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can't quite prove that...

    VirgilReality20 pointsBadges:
  • SQL Server worst practices

    Hello, My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. Jeremy Kadlec, a performance and tuning expert at SearchSQLServer.com, recently wrote up what he considers some of the worst SQL Server practices and offered recommended fixes. You can see the list here:...

    Nbellistri0 pointsBadges:
  • Upgrade to SQL Server 2005 sooner or later?

    Hello, I'm the editor of SearchSQLServer.com and I am hoping to get your opinons on a timely topic. Prior to Microsoft announcing its November 7 release date for SQL Server 2005, we had run a poll asking site members: How have the delays with SQL Server 2005 affected your organization's plans? 58%...

    RobynLorusso230 pointsBadges:
  • Changing the statement heap parameter on iSeries

    Hi, I would like to know how to change the statement heap parameter DB2 (stmtheap) on the AS/400. I tried the command GET DATABASE CONFIGURATION FOR database-alias (giving alias name as the AS/400 server name) but it returns the error "SQL0901N The SQL statement failed because of a non-severe...

    Sbkhole0 pointsBadges:
  • Inserting data into a vargraphic data type field

    How to insert data into a vargraphic data type field. I have done the following CREATE TABLE TEST_TABLE (FLD1 VARGRAPHIC(20)) This is done succesfully INSERT INTO TEST_TABLE VALUES('TEST') This gives a SQL error Please let me know how I can acheive it.

    Sbkhole0 pointsBadges:
  • Stored Procedure Error

    This is mu stored Procedure: CREATE PROCEDURE ADMINISTRATOR.DIMS_SP_PerformSearch ( vuserId integer, vsearchText varchar(500) , vfromID integer, voption integer ) ------------------------------------------------------------------------ -- SQL Stored Procedure...

    Jsbaig0 pointsBadges:
1

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