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 > SQL > Transact-sql

Transact-sql

14 of 14     Previous     Next
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.
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.
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.
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 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.
Working with the IIF Statement in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.
Determine Which Version of SQL You Are Running
by Hannes du Preez
Language: SQL, Expertise: Beginner - Check out these two T-SQL methods that determine which version of SQL you are running.
Disable Indexes with SQL
by Hannes du Preez
Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
Using TRY and CATCH Blocks in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to handle errors in T-SQL.
Using xp_create_subdir to Create Windows Folders with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.
Using the @@rowcount Global Variable in SQL
by Hannes du Preez
Language: SQL||Expertise: Intermediate
14 of 14     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date