Start with this http://www.red-gate.com/community/books/sql-server-execution-plans

See http://msdn.microsoft.com/en-us/library/ms188386.aspx

I aqm not sure what you are asking ? please clarify

ESAT ERKEC (3/5/2013)

---

Think that i have a item total table and it inculudes all item totals and take 300.000 insert and update per a day and it has a

two...

Technically any column which is part of any index will get impacted by any DML operation plus statistics also get hit

Thanks Dwain and lynn 🙂

have you tried this on same machine(server) or from other machine(sql client)...

-- Get all SQL Statements with "table scan" in cached query plan

;WITH

XMLNAMESPACES

(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan'

...

Yes and the first step would be tune your stored proc

1 try to restrict the query...

i didnt get this question ? please clarify

SQL* (2/21/2013)

---

Why the retrieval is slow compared to the unpartitioned...

from BOL

Although partitioned indexes can be implemented independently from their base tables, it generally makes sense to design a partitioned table and then create an index on the table....

Delete will take time as OPC mentioned above as it has to reference child tables too .

Two approaches are there.

first,

although it is not recommened if you are following...

i am not a .net guy, you should search in .net forums like codeproject for this .

Google it 🙂 i am sure it will help you more than anyone else.:-D

I think you are talking about pagination here. this can be done at application and sql server both.

search google for "row_number()"