-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Examples of using “SAVEPOINT” and “ROLLBACK TO” SQL> select * from scott.test; no rows selected SQL> insert into scott.test values… READ MORE
When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is… READ MORE
To move/rename current block change tracking file, one would need to restart the database. # Get current block change tracking… READ MORE
|
When running Microsoft Management Console if you get the error where it fails to initialize, one possible fix could be… READ MORE
To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @oem_errorlog nvarchar(255) EXECUTE master.dbo.xp_instance_regread… READ MORE
Backup in RMAN can be compressed when they are being created. Using the following command one can compress backup to… READ MORE
Starting RMAN with check syntax will check syntax of RMAN command, it will report errors if the syntax is incorrect.… READ MORE
When clicking on Properties, SQLServer could display the following error message “Property Owner is not available for Database ‘[DatabaseName]’. This… READ MORE
|
Move by one character h – Move cursor left j – Move cursor down k – Move cursor up l… READ MORE
http://support.microsoft.com/kb/923247 Using DBCC CHECKDB (0) WITH ESTIMATEONLY will estimate space needed in tempdb when DBCC CHECKDB is run. Sample Output:… READ MORE
|
Article to manage SQL Server 2000 transaction log growth http://www.mssqltips.com/tip.asp?tip=950 READ MORE
— Get process id of current process $ echo $$ 6113 — shows process id $ ps PID TTY TIME… READ MORE
|
sp_tableoption is used to turn on/off features on tables like turn on the text in row feature for datatype text,… READ MORE
|
Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. —… READ MORE
If using SQLDeveloper from Oracle there was an issue we ran into where the user who were granted read access… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 