Do you cache or not? By default SQL Server cache stores the data & query plan in cache to provide better performance for your queries. Similary caching is also included in SQL Server Reporting Services where this caching can shorten the time required
Read More...
On SSP forums I have looked at the question about Update Statistics and AUTO UPDATE STATISTICS option available on a SQL server database; 1> When i say Auto create statistics, what are the columns for which statistics are collected? Are these all columns
Read More...