Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rekiller
Starting Member
31 Posts |
 Posted - 2010-05-06 : 18:15:49
|
Hi there,I have a Partitioned Table with 4 file groups depending of Time Unique Key (integer) one for 2005 to 2008 and another for 2009 and 2012 data.The integer unique key is table dimension that 1 represent a date, and next value 2 represent date plus 1 day and so on.The table works fine. So if i want to query data from one year I have to do something like following query:select * from PartitionedTable where time_wkey between Number1 and Number2 Sometimes, partionedtable only retreives me data with the WHERE clause from only the first partition 2005-2008, but if I remove the where clause it retreives me all years 2005 to 2012.It seems that WHERE clause sometimes doesnt works for all paritition.When we restarts sql server, it works fine,What could it be?I have SQL Server 2008 R1 |
|
|
|
|
|
Problem Retrieving Data from Partitions