When viewing object details on a table, the data tab only returns 34 rows on tables with more then 34 rows. I have verified that the "Database - General, Number of rows to initially fetch" has unlimited checked. (Row count is 0 and "Apply to editor" is also checked.
Now, If I create a data filter where column1 is not null, All rows are then returned. But as soon as the filter is removed, data is limited to 34. This occurs on tables with indexes and tables without indexes. I have updated statistics ..
What am I missing ?