mrdenny (7/18/2010)
What's the query look like that you are running? A table with a few hundred thousand records shouldn't take long to run, and shouldn't need to be partitioned. I've got tables with hundreds of millions of records with no partitioning running with no problem.Can you post the execution plan for your query which isn't running correctly?
Hi sir!
Can you explain little bit how you are doing this "I've got tables with hundreds of millions of records with no partitioning running with no problem" - I know that here speaks the SQL Server MVP and one of the SQL Masters! I would like to know in which version of SQL Server and some few infos about (Hardware/Software config.)