InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:44:30 GMT20http://www.sqlservercentral.com/Forums/Topic743276-146-1.aspxIt should only access the partition where the data resides. Yo should be able to verify this by having SSMS show you the actual execution plan when running the query.Sun, 28 Jun 2009 21:23:27 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic743276-146-1.aspxhow does SQL-Server 2005 behave when i run parameterized queries on a partitioned table? does the partition pruning mechanism still work or do i need to do something so that the pruning mechanism will continue to work? for example : the table RECORDS has four columns :record_id char(10)record_type smallintcustomer_id smallintcreation_date datetimeand is partitioned by the column customer_id.if i'll issue the query :select * from RECORDS where customer_id = : x;will SQL-Server access all partitions or will it access only the needed partition? if the first option is true, how can i make it access only the needed partition?any information on that matter will help. thanks is advance, Hanan.Sun, 28 Jun 2009 08:38:34 GMTHananLevy