Under SQL Server 2000 Enterprise Manager's Database Maintenance Plan, is the option to "Reorganize data and index pages" the same as executing the...
I guess I've been thinking I had to anaIyze an entire batch of statements in order for ITW to consider indexes that balance all of the query...
Here are three examples. I've changed the object names in some cases for confidentiality reasons. Any syntax errors are from the editing and not in...
Thanks for the reply. I did look in the other posts but none answered my question. The integer ID is not unique. I should have said there are...
In general, I've seen a comment that varchar columns don't make efficient index columns. However, I have a customer material table which has two main...
Thank you, Luis. That should give me what I need.
According to SQL Server Query Performance Tuning Distilled by Sajal Dam, the Index Tuning Wizard only looks at the first SQL statement in a batch...
I am working with SQL Profiler and the Index Tuning Wizard in order to improve the database performance for my client's web site. Before I implement...
Currently, very little. The auto create statistics, auto update statistics and torn page detection options are checked. Because of table...
I have a B2B web site that supports both online transactional processing as well as reporting requests. This is not what one would consider a high...
Separate names with a comma.
