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 60     Previous     Next
Identify Tables with Large Column Counts
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.
Find Out the Column Name Using the COL_NAME() Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.
Using the Replace Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - The REPLACE command behaves as INSERT when there is no record matching the constraints.
The sp_spaceused Procedure in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.
Merge Two DataTables, Preserving the Old Values
by Srinath M S
Language: .NET, Expertise: Beginner - Learn how to maintain all the old values when merging two databases.
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
Using DATEFROMPARTS SQL Function
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.
1-20 of 60     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date