dcsimg
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 Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 2443     Previous     Next
RESEED Identity Columns of All Tables
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to loop through all the tables and execute the DBCC CHECKIDENT command.
Working with the IIF Statement in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.
Using the Insert on Duplicate Key Update in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the insert on duplicate key update and how to use it in MySQL.
Using fn_builtin_permissions
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn more about an SQL function that allows you to get a list of available permissions.
Resize Your TempDB in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to resize the tempdb temporary database in SQL.
Understanding the AVG Function in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - Learn how to use the AVG function to calculate the average in MySQL.
Get Current Language ID
by Hannes du Preez
Language: SQL, Expertise: Beginner - See which select statement to use to get the language ID.
Using sys.dm_db_index_physical_stats
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to return size and fragmentation information for the data and indexes of the specified table or view in SQL Server.
Using AUTO_INCREMENT in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.
Write SQL Results to a Text file
by Hannes du Preez
Finding the Current User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.
Diagnose System Slowdowns
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to quickly diagnose System slowdowns.
Identify Tables Storing GUID Values
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to identify tables that store a GUID (Globally Unique Identifier) value.
Using sys.dm_db_missing_index_group_stats
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to return summary information about groups of missing indexes, excluding spatial indexes.
Employing DROP USER in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn to how to properly use the drop user command in MySQL.
Read All SQL Server Log Files
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.
Using the DATALENGTH SQL Function
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to use a SQL function to return the length of a column in a table.
Empowering MySQL to Send Batched Statements in a Single Request
by Octavia Anghel
Language: SQL, Expertise: Intermediate - See how to empower MySQL to send batched statements in a single request.
Employing DBCC PINTABLE and DBCC UNPINTABLE Functions
by Hannes du Preez
Language: SQL, Expertise: Advanced - See how to ensure a table always stays available in SQL Server's cache. You can Pin the table and Unpin it when it is not needed anymore.
Compress and Decompress SQL Functions
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to compress and decompress data in SQL.
1-20 of 2443     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date