whenever we try to upload the data...the application will be hang or it stop uploading data.
please tell me how to resolve this issue
Thanks in avance
Gosh... still not enough information. We need to know what you're using to "upload the data", see some code, see the table and index
structure (attach the CREATE statements), know what kind of drivers the app is using to do "the upload", know how many rows you're trying to INSERT into the table at one time, etc, etc. There are other things to know like how many FK's you have against the table, how many indexed views you have against the table, and whether or not any triggers are present.
Indexes on such a wide table could certainly be a problem. For example, even if you have just one low selectivity index, such as a bit column or a status column, the page and extent splits may (many times, will) cause enough of a delay to cause massive timeouts on the GUI side of the house. What you've selected as the Clustered Index may also cause such a problem. That, however, may not be the problem here but there's no way to tell because, what you've posted, so far, is a classic "my car won't run, please tell me what's wrong with it" type of question and that's just impossible to answer without more information.
"Partitioning" typically won't help on such problems even if you take to "vertical" partitioning.
I'll also suggest that having a 270 column table might be a design problem to begin with but I've seen that happen especially in the area of Telephony and Call Detail Record processing (for example).
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs