Articles about SQL
Other articles
What can mathematics do for your programming? That's an interesting question to explore, even more so when answered with an example.
When working with subqueries and common table expressions, you should consider the following best practices: Use subqueries to break down complex queries Consider the performance of subqueries, compared to other methods for retrieving data Use...
Consider the following when you join data from multiple tables: Join tables on primary and foreign keys because it improves performance Limit the number of tables in a join Limit the number of tables in a join query because too many joins can s...
When you use clauses and operators to summarize data, consider the following: Index frequently aggregated columns to improve performance Avoid using aggregate functions on columns that contain NULL values Use the ORDER BY clause to guarantee t...
The following recommended practices should help you work with T-SQL, effectively and efficiently.
If you create an index containing all the columns (or more) that you need for a query, then this is referred to as a covering index.
The best practices for monitoring and controlling resources in SQL Server 2008 are: Establish a performance baseline over a period of time that reflects the differing utilization of SQL Server 2008 over the business cycle Choose an appropriate ...
Follow the guidelines given below when planning and implementing an appropriate backup strategy: Perform backups on a regular basis.
For best results, adhere to the following best practices when creating and optimizing indices in SQL Server 2008 (caveats apply): Create indices on columns that join tables, including primary and foreign keys to improve query performance Place ...
Normally you can use the LEN function to find the length of a string field, however this does not work on a text field.
Copyright © 2024 carlbelle.com