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 148     Previous     Next
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.
Get the Last Day of the Current Month
by Hannes du Preez
Language: SQL, Expertise: Beginner - Use this easy query to discover the last day of the current month.
Rebuild All Database Indexes
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - See how to rebuild all of the indexes in your database with this query.
Recompile a Stored Procedure
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to recompile certain stored procedures.
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.
1-20 of 148     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date