- Optimize and tune queries for performance
Creating Partitioned Views
Table Hints (Transact-SQL)
SET ANSI_PADDING (Transact-SQL)
Introducing SQL Trace
max degree of parallelism Option
- Optimize indexing strategies
XML Best Practices
Planning Guidelines for Partioned Tables and Indexes
Creating Partitioned Tables and Indexes
- Scale database applications
Creating Distributed Partitioned Views
- Resolve performance problems
Dynamic Management Views and Functions (Transact-SQL)
Performance Optimizations for the XML Data Type in SQL Server 2005
- Optimize data storage
Other related posts:
Teach Yourself Azure in 4 hours
Geek Post Monthly Newsletter Volume 2 Issue 10
Add a comment
Please note: comments that are inappropriate or promotional in nature will be deleted.
E-mail addresses are not displayed, but you must enter a valid e-mail address to confirm your comments.
Are you a registered Geekzone user? Login to have the fields below automatically filled in for you and to enable links in comments. If you have (or qualify to have) a Geekzone Blog then your comment will be automatically confirmed and shown in this blog post.