We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

NEWBIE: Trying to drop column with many columns failing

BrianMc1958
BrianMc1958 asked
on
Medium Priority
230 Views
Last Modified: 2008-01-09
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
Comment
Watch Question

Commented:
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!

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.