General questions

Question

General questions

ezhil-649633

SSC Eights!

Points: 975
More actions
March 10, 2008 at 10:01 pm

#187838

Maximum Number of rows allowed in sql server 2005 tables ?
Maximum Number of columns allowed in sql server 2005 tables ?
What are all the built in string functions can be allowed for 'TEXT' DataType in sql server 2005?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

I'll answer your third question right now. Don't use text, ntext, or image data types in SQL Server 2005. If converting a SQL Server 2000 data base to SQL Server 2005, consider changing any columns defined as such to varchar(max), nvarchar(max), and varbinary(max) respectively. The text, ntext, and image data types have been depreciated, and may not be supported in future versions of SQL Server.

😎

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Now for your other 2 questions.

Max number of columns: 1,024

Max number of rows: probably restricted by the amount of disk space available.

😎

GSquared SSC Guru Points: 260824 More actions · Answer 3

Just to add to Lynn's answer: The maximum number of rows is purely a limitation of disk space available.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Jeff Moden SSC Guru Points: 1004304 More actions · Answer 4

My answer would be, do your own interview. These answers are in Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736129 More actions · Answer 5

Search Maximum Capacity Specifications in Books online (or google).

Some of these will change in SS2k8