Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How many Varchar(max) columns can be given ? Expand / Collapse
Author
Message
Posted Wednesday, August 21, 2013 8:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:34 AM
Points: 103, Visits: 90
Hi,

I just want to know how many varchar(MAX) columns in a single table can be given , without effecting performance ?

Is there any restriction?

Regards

Post #1486733
Posted Wednesday, August 21, 2013 8:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:34 PM
Points: 13,481, Visits: 12,342
pavanr (8/21/2013)
Hi,

I just want to know how many varchar(MAX) columns in a single table can be given , without effecting performance ?

Is there any restriction?

Regards



Way more than you should ever use in a properly designed database. If you are curious about the capacity of stuff you can look here.

http://technet.microsoft.com/en-us/library/ms143432.aspx


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1486737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse