Indexed Views will helps by pre-computing aggregations and store them in the index. Moreover, joining tables can be pre-join and results data can be stored.

This can speed up your queries...

Hi,

One more thing to add here is; running the SQL Server Profiler from another machine (not the server itself) will help in minimizing the performance impact.

Good luck! 😉

Hossam AlFraih (6/19/2009)

---

Hi Amit,

I used the script on one of my tables it gives me about 600 MB for 400,000 records.

I filled that table with "actual" data (400,000 records) and...

Hi Amit,

I used the script on one of my tables it gives me about 600 MB for 400,000 records.

I filled that table with "actual" data (400,000 records) and It is...