Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EdVassie

    Oracle Patch Pack polocy

    Can anyone tell me what Oracle's patch policy is for 9i and 10g. I want to know: a) Do Oracle generally release individual patches as problems are found, or do they only release a patch if they think it will fix a support request. How well are these patch regression tested. b) Do Oracle...
  2. EdVassie

    TEMPDB Issue and table being hung up

    Working out how much TempDB space you may need can be complex. There is also the issue of if TempDB .mdf should be fixed size or allow to grow and shrink. We use a fixed size TempDB on our largest servers, spread over multiple physical files, as we expect the type of contention discussed in KB...
  3. EdVassie

    TEMPDB Issue and table being hung up

    There is a little-known way to get log file full messages when you have plenty of spare disk space. When SQL Server determines it needs to increase the log file size in order to complete an active piece of work, it will trigger the log growth process. However, if the space that has been added...
  4. EdVassie

    Exporting from 7.2.3 Desktop

    If you uninstall and re-install MSTR, also re-apply NT SP4. In theory, this should not matter, but in practice NT is prone to loosing expected DLL versions during an uninstall. Also, look at MDAC levels, as this could also be an issue. If all else fails, reformat the disk and re-install NT...
  5. EdVassie

    Not possible Stored Procedure?

    BOL has a good discussion on this. Look for 'hierarchical information' in the index. Basically, if you do not know the depth of your hierarchy, then you must build a temporary table to contain depth information. OLAP services allow you to use recusive SQL, which can speed up such queries...
  6. EdVassie

    Problem using variable for column name

    The response given by cmmrfrds will work, but opens up a VERY big security hole. The problem is known as 'SQL Injection'. This allows a malicious user to add additional code to the data they enter to bypass security. Try running the above code with the value of @theValue set to...
  7. EdVassie

    ELIMINATING UNWANTED RECORDS IN UNION?

    You are getting two rows returned because you are asking for them in your query. The process of removing duplicates in the union considers all fields that are being returned in the result set. Your 'group by' within each side of the union is redundant, because the elimination of duplicates...
  8. EdVassie

    MSDB recovery model changed on its own ????

    According to Microsoft (who probably should be trusted on this...) every time SQL Agent is stated, it will set the recovery mode of MSDB to Simple in SQL2K, or in SQL7 it will set 'Commit at Checkpoint' on. There is no way to prevent this behaviour. You have to design your backup and recovery...
  9. EdVassie

    Populating Remedy Help Dsk from SQL Alerts

    Has anyone looked at automatically feeding SQL Alert information into the Remedy help desk application. We want to get tickets raised for various SQL Server alerts, and if maintenance jobs fail. This posting is a personal opinion only, and may not reflect reality.
  10. EdVassie

    DB2 parallel edition on AIX

    DB2 PE has been obsolete for many years (It relates to DB2 V2.1.2 I think). The current DB2 release is DB2 7.2 You should look at DB2 Enterprise Edition if you can grt your application to fit into a single box. DB2 EE can support many CPUs on the box, and can support clustering for...
  11. EdVassie

    find level for every node in tree structure

    Maybe one day recursive SQL will get implemented in SQL Server, as it has existed in its main competitors for some years... |-0 This posting is a personal opinion only, and may not reflect reality.
  12. EdVassie

    Available server list

    The server list is built by pinging the SQL Server port on all machines in your network segment. If a response is received, the machine is added to the list. If no response, the machine is not added. This process is sometimes called Discovery. Things that can stop discovery working are: a)...
  13. EdVassie

    Deleted default database for all users - now locked out of server!

    Another idea... Add the -T3608 flag to the SQL Server startup parameters, by using regedit, and restart SQL Server. You should be able to log on using a System Admin account. If this works, create a new 'Emps' database, then remove the -T3608 flag and restart SQL Server. Do not make any...
  14. EdVassie

    Maximum statement length (SQL &/2000)

    What is the mximum length for a SELECT statement, and for a CREATE VIEW statement. Are there different limits in SQL 7 and SQL 2000, or in different editions of these products? I have seen reference to a maximum SELECT statement length of 8000 characters. If true, this could be a problem as...
  15. EdVassie

    Backup and Recovery for Cognos

    I have been 'gifted' with the task of reviewing our site's process for Cognos backup and recovery. We run Cognos finance V5.1 on NT4. I think I can spell Cognoss correctly, but that is about the limit of my knowlege of it... Currently all files are copied to tape on a daily basis. Recovery...
  16. EdVassie

    ODBC Connection To DB2 via MSAccess??

    Another alternative... First of all, make sure you have a ODBC definition configured on your windows box for your AS400 DB2 database. In Access, Click on the 'File' menu. Then select 'Get External Data' and 'Link Tables'. For the table type, scroll down the list until you see ODBC data...
  17. EdVassie

    Indexes....Update !

    If a column is used in an index and its value is changed, it will slow the update processing. If a column is used in an index, and its value is NOT changed, it will have no impact on update processing. DB2 will not update a given index if the columns making up the index have not changed in...
  18. EdVassie

    Performance enhancing of correlated query?

    For your situation, I would normally use UPDATE TABLE1 A SET A.COL1 = (SELECT B.COL2 FROM TABLE2 B WHERE A.COLX = B.COLY) It would be worthwhile to use Visual Explain or...

Part and Inventory Search

Back
Top