dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL

PL/SQL
  SQL
Transact-sql
1-20 of 152     Previous     Next
Three Levels of Data Abstraction in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about the levels of data abstraction employed in SQL to hide irrelevant details from users.
Delete Data Safely with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Explore to how to safely delete data in SQL.
Name All of the Normalization Forms in SQL
by Hannes du Preez
Language: Java, Expertise: Beginner - Explore a list of the names of all normalization forms in SQL.
Discovering the Reason for Poor Query Performance
by Hannes du Preez
Language: SQL, Expertise: Beginner - Explore some of the reasons why your query performance might not by up to expected speeds.
Types of Indexes that Exist in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Get an overview of the index types available in SQL.
T-SQL Performance Tip: Stored Procedure Names
by Hannes du Preez
Language: SQL, Expertise: Beginner - See why you should avoid prefixing your Stored Procedure names with sp_.
T-SQL Performance Tip: NOT IN vs NOT EXISTS
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn the difference between using not in and not exists in T-SQL.
User Creation and Scenarios
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.
T-SQL Performance Tip: The * Operator
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about why you should use explicit column names in T-SQL.
T-SQL Performance Tip: Owner or Schema Name
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about how to improve query performance by including owner or schema name.
Using REGEX Case Sensitively
by Srinath MS
Language: SQL, Expertise: Intermediate - See how to navigate using regex case sensitively in MySQL.
T-SQL FORCEPLAN
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about what happens in the SQL Server query optimizer when Forceplan is set to on.
Set ARITHIGNORE to On
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to control whether error messages will be returned from overflow or divide-by-zero errors occurring during a query.
Explore a Few Math Functions in SQL Server
by Hannes du Preez
Language: SQL, Expertise: Beginner - See several math functions that can be used in T-SQL.
Using LOCK_TIMEOUT in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to specify how long a statement should wait for a lock to be released.
Using NUMERIC_ROUNDABORT in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to specify the level of error reporting that has been generated when an expression being rounded has caused loss of precision.
Get All the Tables with a Count of Their Records
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this query to get all the tables with a count of their records.
Reseed All Autonumber Fields in All Tables
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn more about a query that will allow you to reseed all auto-numbered fields.
Get the First Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to find the first date of the current month.
Get All Columns in All Tables of a Specific Data Type
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to find a specific data type across all tables and columns in a database.
1-20 of 152     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date