Hello all. I have a table that has over 3 million records in it. I have an ASP based application that is starting to drag based on the table being so large. I have stored procedures that hit the table that I think are just taking a long time to run now that so many records are there. I have run SQL profiler on many occassions and used the Index Tuning Wizard to help and it has before but now I ran it again and there are no suggestions after running a thourough run of it. Any other suggestions to speed things up on this DB table? Thanks all
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.