Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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.

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)...

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...

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...

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...

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...

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...

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...