troubleshooting Question

table size and performance

Avatar of websss
websssFlag for Kenya asked on
Microsoft SQL Server
18 Comments2 Solutions125 ViewsLast Modified:
I have a table with 38 columns
I now need to add another 9 columns or more
or move them to a separate table

The table has millions of rows and is accessed quite a lot (like every 30 secs by 200 users), so i'm thinking by adding more columns to this table will really impact performance, but i'm not sure
can someone help clarify is this is a big NO NO or whether it will be fine adding these on same table
SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros