Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development > Database Administration

Database Administration - Page 2

21-39 of 39     Previous     Next
Turn Off the Index Maintenance of DataTable when you Load Data
by Srinath M S
Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.
Encrypting and Decrypting a Database Connection String
by Hannes du Preez
Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database
Using the SET NOCOUNT SQL Method
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how to use the NOCOUNT method to switch off the DONE_IN_PROC messages and boost the performance of queries and network traffic.
Built-in JSON Functions in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Did you know that SQL has some very handy built-in JSON functions?
Using the SQL LCASE Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
Get a List of all Tables In Oracle SQL
by Ben Brumm
Understanding OFFSET in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - Learn an easy way to fetch the next 10 records from a given point.
by Hannes du Preez
Language: SQL||Expertise: Beginner
Convert Oracle Queries into Microsoft SQL Format
by Andrew Kuprianov
Language: SQL||Expertise: Intermediate
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.
21-39 of 39     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date