[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

NEWBIE: Trying to drop column with many columns failing

Dear Experts,

I'm trying to drag and drop a table into a tabbed pane in Visual Studio 2005 (C#), and I'm getting this message:

     sum of the columns' FillWeight values cannot exceed 65535

Admittedly, the table has around 400 or so columns...

Is there any way around this?

Thanks,
BrianMc1958
0
BrianMc1958
Asked:
BrianMc1958
1 Solution
 
dabitbolCommented:
Hi,

Seriously, I would consider normailizing your database (split into smaller tables), this will be a serious performance issue if you try to query all of your columns. Another way would be to create a view for a subset of your Data. Don't forget, with 400 columns your transferring a huge chunk of data over the internet or network.

Good Luck!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now