Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development > Database Administration

Database Administration

1-20 of 47     Previous     Next
Doing Upserts with the Help of MERGE
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Get All Tables and Views Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Find out When the Last Full Backup was Taken
by Hannes du Preez
SQL query that displays the last time a full backup was taken, as well as the user who took the last backup.
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
Quick Script Monitors Application-generated SQL
by Jason Bramsden
This script was written to monitor a program whose process life was only a few seconds. It runs forever and only outputs that SQL which is generated by the program as it's running.
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server— and it does not include graphical tools.
Turning Recursive and Nested Triggers On and Off
by Sachin Kainth
This tip gives you the commands to switch recursive and nested triggers on and off.
Getting New Values Entered into a Table
by Sachin Kainth
Find out how you can use :new.<fieldname> to retrieve new values entered into a table.
Resolve DB2 Instance Creation Failure on UNIX
by R. Vijaya
Finds out why AIX DB2 instance creation fails and jpw to resolve it.
Making Tables Read-only in Oracle
by MS Sridhar
In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace.
Identify the Owner of a User Table
by Jaya Nehru Kumar
If your database is maintained by more than one user and some of those users have rights to create tables, it can be difficult to identify the owner of a given table.
Hide System Tables and Objects in MS SQL Enterprise Manager
by Jaya Nehru Kumar
Follow these three, simple steps to hide system tables and objects in MS SQL Enterprise Manager.
Granting Permissions on Database Objects
by Devington B.
Who Is Using the Oracle Database?
by Shiv Kumar
...
Informix Ontape Backups
by DevX Pro
I need to do an ontape Level 0 backup but I need to bypass the "Press Enter to Continue." Simply put, I want to type "Ontape -s -L 0" and not get prompted to "Press Enter to Continue." I am currently running Informix 7.23 on an AIX 4.2. Any ideas ?
Informix Backups Error Message
by DevX Pro
We have Informix IDS 7.30 running under SCO 5.0.5. Backups by ontape fail with an error: "I/O read chunk 90, pagenum 2, pagecnt 1 --> errno = 9" But when we are doing normal queries, it's all fine. Any ideas?
Ontape for Backups to Disk
by DevX Pro
How can 'Ontape' functions be used to back up Informix/Lawson DB to disk? Is dbspace required or can a large area in a directory (e.g., /gsc/bigspace) be used?
Problem with Using Ontape
by DevX Pro
I am running Informix 7.3 on SCO Openserver 5. I run Ontape every morning and it has been going fine. Starting yesterday I've been getting the following error: Archive on rootdbs, onlinedata ABORTED. Aborted by client My tape drive is OK as well as the tapes. I can do a normal CPIO to it and read from it. Any help would be appreciated.
PDQ and Xtree
by DevX Pro
How can I set the PDQPRIORITY for every user in the database? I am also trying to get Xtree to work on the same system so I can better analyze user queries but can't figure out how to do that either.
Generate Audit Table Trigger Code
by David Satz
This code will generate code to do a column-by-column comparison against a table, assuming that you are joining the inserted table (aliased as "i") with the deleted table (aliased as "d") in a ...
1-20 of 47     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date