Limit to the number of records in SQL Developer?

Question

Limit to the number of records in SQL Developer?

Doctor Who 2

SSCrazy Eights

Points: 8194
More actions
July 4, 2009 at 7:52 am

#131770

I've got SQL Server 2005 Developer Edition loaded on my home PC, which I do development against. I know there is a limit to the file size of the .mdf file (4 GB), but is there a limit to the number of rows of data that a table could contain?
Rod

Viewing 8 posts - 1 through 7 (of 7 total)

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

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

Doctor Who 2 (7/4/2009)
I've got SQL Server 2005 Developer Edition loaded on my home PC, which I do development against. I know there is a limit to the file size of the .mdf file (4 GB), but is there a limit to the number of rows of data that a table could contain?

Actually that is not correct the Developer is an Enterprise edition with no deployment restrictions so it comes without any restrictions, the 4gig MDF file restriction is for Express edition.

If there is any restriction it will be few concurrent users because of the default no deployment restriction.

Kind regards,
Gift Peddie

WayneS SSC Guru Points: 95460 More actions · Answer 2

Doctor Who 2 (7/4/2009)
I've got SQL Server 2005 Developer Edition loaded on my home PC, which I do development against. I know there is a limit to the file size of the .mdf file (4 GB), but is there a limit to the number of rows of data that a table could contain?

I think Microsoft can best answer this question: http://www.microsoft.com/sqlserver/2008/en/us/developer.aspx

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Gift Peddie SSC Guru Points: 73570 More actions · Answer 3

WayneS (7/4/2009)
Doctor Who 2 (7/4/2009)
I've got SQL Server 2005 Developer Edition loaded on my home PC, which I do development against. I know there is a limit to the file size of the .mdf file (4 GB), but is there a limit to the number of rows of data that a table could contain?
I think Microsoft can best answer this question: http://www.microsoft.com/sqlserver/2008/en/us/developer.aspx

The OP is running 2005 so the link below is what is needed note the developer is not listed because as I already covered it is the Enterprise edition. I am running both 2005 and 2008 developer edition now.

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx

Kind regards,
Gift Peddie

Doctor Who 2 SSCrazy Eights Points: 8194 More actions · Answer 4

Thank you for this great feedback. My guess is the Developer edition restricts the number of concurrent connections, then.

Rod

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

Doctor Who 2 (7/4/2009)
Thank you for this great feedback. My guess is the Developer edition restricts the number of concurrent connections, then.

That is just my guess if people decide to use it for production because it cost under $50 online compared to the thousands of dollars the Enterprise edition costs.

Kind regards,
Gift Peddie

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

There is no connection limitation on SQL developer edition. It is exactly like Enterprise edition in every way, except it is not licensed for production usage. The licensing on developer edition allows a single developer to use it on as many instances as they like. Additional users must have additional licenses

http://www.microsoft.com/Sqlserver/2005/en/us/developer.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 7

GilaMonster (7/4/2009)
There is no connection limitation on SQL developer edition. It is exactly like Enterprise edition in every way, except it is not licensed for production usage. The licensing on developer edition allows a single developer to use it on as many instances as they like. Additional users must have additional licenses
http://www.microsoft.com/Sqlserver/2005/en/us/developer.aspx

Precisely....

--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)