I have a SQL Server 2005 database that is 6 years long the transaction tables are already big in gigabytes and Im having difficulty in querying with inner joins on those large transaction tables and of course some reference tables since im supposed to get reports on them. how do I make my query fast? I've taken indexing as a solution but is there any other way?
Please help.. thanks.