OK - what is that?...

GilaMonster (9/28/2011)

---

From a query window (connected to that database)

EXEC sp_updatestats

Or, maybe better

UPDATE STATISTICS <table name> WITH FULLSCAN

where <table name> is the name of the table that you did all those...

Also - you said:

"It is also possible the inserts are not actually going to the end of the table, but are being inserted all over the table, then the index...

How do I run sp_updatestats?

Setting is timeout ----- Would you give me an example?

<asp:SqlDataSource id="Test" CacheDuration="Infinite" runat="server" ConnectionString="<%$ ConnectionStrings:TestConnectionString %>" SelectCommand="SP_Test" SelectCommandType="StoredProcedure">

<SelectParameters>

<asp:Parameter DefaultValue="UNV" Name="DropDownList1" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

Yes, I posted and you guys gave me some great suggestions that I am working on. (for fixing the code)

post the actual execution plan----------- I know how to view the execution plan when I run my query. How would I copy it out to post it?

Also, do I need to "DO" anything with indexes to keep them running good?

I will check all out. Thank you for the links.

I'll check it out. Thanks for everything!

OK - Thanks. What I will do is start from the beginning and post a new question about my indexes first to make sure I have that setup correct.

Well, I have a huge table. Going on 3,000,000+ records with a aspx web front where users actively query this table with around 10 different parameters. Just completed...

Hello. This post was a huge help for me. I am able to get it to work in a stored procedure. Is it possible in a function?...