-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Found this store procedure on Tom Kyte’s site which can be used to print columns in a table row wise,… READ MORE
To take backup manually or when cloning a database using the following SQL one can place the database in backup… READ MORE
If archive logs are missing RMAN will fail with the following error also in cases when the archive logs are… READ MORE
The following example shows how to loop through parameters in batch file. c:> TYPE script.bat @ECHO OFF :TOP IF (%1)… READ MORE
After scheduling a task through SQLServer Agent it generated the error below when executing the DTS. The DTS package required… READ MORE
|
Using QSlice one can monitor CPU usage for individual thread on a windows box. Qslice can be downloaded from the… READ MORE
Using the following SQL one can find tables that contain a column name. In SQLServer SELECT table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS… READ MORE
In SQLSever 2005 msdb.dbo.sp_send_dbmail is the new way of sending email and it replaces xp_sendmail. Below are the steps how… READ MORE
|
The following article explains global statistics versus histogram with DBMS_STATS http://www.akadia.com/services/ora_gather_statistics.html READ MORE
— List processes currently running through SQLServer Agent select spid, program_name, blocked from master..sysprocesses where program_name like ‘SQLAgent%’ spid program_name… READ MORE
When using DBMS_STATS to gather table statics Oracle backups up the statistics before overwriting it. The following example shows how… READ MORE
Using the link below one can create SQL script to create database http://geekswithblogs.net/dotNETPlayground/archive/2008/04/18/121331.aspx READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 