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 |
|
sateesh.sqldba
Starting Member
25 Posts |
 Posted - 2010-08-18 : 15:27:51
|
| Hi Experts, i have huge data for a table like 40 lac rows so i am planning to create table partitioned so will you please help me out i am having three businesses for each business i have data for 2009,2010 datalike Business year CL 2009 CL 2010 BI 2009 BI 2010 UN 2009 UN 2010 So i want make it separate data by Business and year please help me out i am new to this conceptThanks In Advancesateesh |
|
|
MSquared
Yak Posting Veteran
52 Posts |
Posted - 2010-08-18 : 15:41:39
|
| How will the data be queried? Will the businesses ever be combined in a query or are they strictly separate? Is the data being queried through a stored proc or inline sql? How is the data being inserted into the tables (stored procs, bulk load)? Will it be queried by Business Year or will it be queried by specific dates>For Faster results please follow the posting guidelines herehttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
sateesh.sqldba
Starting Member
25 Posts |
Posted - 2010-08-18 : 22:30:59
|
we are using through Stored proc an bulk data inserted and it is queried by Business year only(like we will pass parameter like 2009,2010) quote:
Originally posted by MSquared
How will the data be queried? Will the businesses ever be combined in a query or are they strictly separate? Is the data being queried through a stored proc or inline sql? How is the data being inserted into the tables (stored procs, bulk load)? Will it be queried by Business Year or will it be queried by specific dates>For Faster results please follow the posting guidelines herehttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
sateesh |
|
|
|
|
|
|
PROBLEM TO CREATE PARTITIONED TABLE