|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2008 / 2005 / 2000 / 7 / 6.5 largest possible database?
Does someone know what is the largest possible database with the
following relational database systems: Sql server 6.5 Sql server 7 Sql server 2000 Sql server 2005 Sql server 2008 http://www.hd720i.com/Category/SQL-Server/1-1.aspx Could not find any info on 6.5, and I forget now, sorry. When 6.5 was valid
the disks available were microscopic compared to what is available now. SQL 7.0 = 1,048,516 TB SQL 2000 = 1,048,516 TB SQL 2005 = 524,258 TB SQL 2008 = 524,272 TB On 6/16/09 2:37 PM, in article unxnbGr7JHA.1***@TK2MSFTNGP04.phx.gbl, "Rajoo Sharma" <s***@sharma.com> wrote: Show quoteHide quote > Does someone know what is the largest possible database with the > following relational database systems: > > Sql server 6.5 > Sql server 7 > Sql server 2000 > Sql server 2005 > Sql server 2008 > > http://www.hd720i.com/Category/SQL-Server/1-1.aspx Aaron;
Since I never expect to reach anywhere near the theoretical upper limit, I never bother to find out or remember the exact upper limit for eahc version. But your reply seems to suggest that SQL7/2000 can support larger databases than SQL2005/2008. That sounds odd! Is there a typo? Linchi Show quoteHide quote "Aaron Bertrand [SQL Server MVP]" wrote: > Could not find any info on 6.5, and I forget now, sorry. When 6.5 was valid > the disks available were microscopic compared to what is available now. > > > SQL 7.0 = 1,048,516 TB > SQL 2000 = 1,048,516 TB > SQL 2005 = 524,258 TB > SQL 2008 = 524,272 TB > > > > > On 6/16/09 2:37 PM, in article unxnbGr7JHA.1***@TK2MSFTNGP04.phx.gbl, "Rajoo > Sharma" <s***@sharma.com> wrote: > > > Does someone know what is the largest possible database with the > > following relational database systems: > > > > Sql server 6.5 > > Sql server 7 > > Sql server 2000 > > Sql server 2005 > > Sql server 2008 > > > > http://www.hd720i.com/Category/SQL-Server/1-1.aspx > > I just checked against BOL 2000 vs. BOL 2008, and those numbers are
per the BOL... -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message news:EBC499AD-B2EF-4071-833D-5D1CCD8C2098@microsoft.com... > Aaron; > > Since I never expect to reach anywhere near the theoretical upper > limit, I > never bother to find out or remember the exact upper limit for eahc > version. > But your reply seems to suggest that SQL7/2000 can support larger > databases > than SQL2005/2008. That sounds odd! Is there a typo? > > Linchi > > "Aaron Bertrand [SQL Server MVP]" wrote: > >> Could not find any info on 6.5, and I forget now, sorry. When 6.5 >> was valid >> the disks available were microscopic compared to what is available >> now. >> >> >> SQL 7.0 = 1,048,516 TB >> SQL 2000 = 1,048,516 TB >> SQL 2005 = 524,258 TB >> SQL 2008 = 524,272 TB >> >> >> >> >> On 6/16/09 2:37 PM, in article >> unxnbGr7JHA.1***@TK2MSFTNGP04.phx.gbl, "Rajoo >> Sharma" <s***@sharma.com> wrote: >> >> > Does someone know what is the largest possible database with the >> > following relational database systems: >> > >> > Sql server 6.5 >> > Sql server 7 >> > Sql server 2000 >> > Sql server 2005 >> > Sql server 2008 >> > >> > http://www.hd720i.com/Category/SQL-Server/1-1.aspx >> >> Still, it's kind of odd. Seems to be going in the wrong direction.
Linchi Show quoteHide quote "Tibor Karaszi" wrote: > I just checked against BOL 2000 vs. BOL 2008, and those numbers are > per the BOL... > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Linchi Shea" <LinchiS***@discussions.microsoft.com> wrote in message > news:EBC499AD-B2EF-4071-833D-5D1CCD8C2098@microsoft.com... > > Aaron; > > > > Since I never expect to reach anywhere near the theoretical upper > > limit, I > > never bother to find out or remember the exact upper limit for eahc > > version. > > But your reply seems to suggest that SQL7/2000 can support larger > > databases > > than SQL2005/2008. That sounds odd! Is there a typo? > > > > Linchi > > > > "Aaron Bertrand [SQL Server MVP]" wrote: > > > >> Could not find any info on 6.5, and I forget now, sorry. When 6.5 > >> was valid > >> the disks available were microscopic compared to what is available > >> now. > >> > >> > >> SQL 7.0 = 1,048,516 TB > >> SQL 2000 = 1,048,516 TB > >> SQL 2005 = 524,258 TB > >> SQL 2008 = 524,272 TB > >> > >> > >> > >> > >> On 6/16/09 2:37 PM, in article > >> unxnbGr7JHA.1***@TK2MSFTNGP04.phx.gbl, "Rajoo > >> Sharma" <s***@sharma.com> wrote: > >> > >> > Does someone know what is the largest possible database with the > >> > following relational database systems: > >> > > >> > Sql server 6.5 > >> > Sql server 7 > >> > Sql server 2000 > >> > Sql server 2005 > >> > Sql server 2008 > >> > > >> > http://www.hd720i.com/Category/SQL-Server/1-1.aspx > >> > >> > > > Still, it's kind of odd. Seems to be going in the wrong direction. I thought so too, but there may be a reason...Perhaps it is as simple as they found some limitation when producing
2005 BOL they didn't think of for earlier BOL? A limitation which was there all the time? I doubt that they actually tested an installation with that amount of RAM? ;-) -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:C65FE77B.2E4DE%ten.xoc@dnartreb.noraa... >> Still, it's kind of odd. Seems to be going in the wrong direction. > > I thought so too, but there may be a reason... > > Or perhaps, they needed to use a bit in a system table column (or some
internal data structure) for something else. Just a wild guess. Anyway, this is all 'theoretical'. Linchi Show quoteHide quote "Tibor Karaszi" wrote: > Perhaps it is as simple as they found some limitation when producing > 2005 BOL they didn't think of for earlier BOL? A limitation which was > there all the time? > I doubt that they actually tested an installation with that amount of > RAM? ;-) > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in > message news:C65FE77B.2E4DE%ten.xoc@dnartreb.noraa... > >> Still, it's kind of odd. Seems to be going in the wrong direction. > > > > I thought so too, but there may be a reason... > > > > > > I'd love to see the SAN that has 500,000 TB, never mind 1MM TB.
On 6/18/09 2:11 PM, in article u3ItnAE8JHA.1***@TK2MSFTNGP05.phx.gbl, "Tibor Karaszi" <tibor_please.no.email_kara***@hotmail.nomail.com> wrote: Show quoteHide quote > Perhaps it is as simple as they found some limitation when producing > 2005 BOL they didn't think of for earlier BOL? A limitation which was > there all the time? > I doubt that they actually tested an installation with that amount of > RAM? ;-) "Rajoo Sharma" <s***@sharma.com> wrote in message 2008 http://msdn.microsoft.com/en-us/library/ms143432.aspxnews:unxnbGr7JHA.1420@TK2MSFTNGP04.phx.gbl... > Does someone know what is the largest possible database with the following > relational database systems: > > Sql server 6.5 > Sql server 7 > Sql server 2000 > Sql server 2005 > Sql server 2008 > > http://www.hd720i.com/Category/SQL-Server/1-1.aspx 2005 http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx 2000 http://msdn.microsoft.com/en-us/library/aa933149(SQL.80).aspx 6.5 amd 7 http://technet.microsoft.com/en-us/library/cc917550.aspx But it is not all that straight forward as MSDE/SQL Express have their own limits. John Essentially unlimited. :-) Actually more realistically the ability to
PERFORM at the high-end of the size scale is constrained by your design, indexing, code and especially the hardware. There are currently SQL Server databases in the tens of terabytes that I know of, and quite likely bigger than that that I haven't heard of. -- Show quoteHide quoteKevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "Rajoo Sharma" <s***@sharma.com> wrote in message news:unxnbGr7JHA.1420@TK2MSFTNGP04.phx.gbl... > Does someone know what is the largest possible database with the following > relational database systems: > > Sql server 6.5 > Sql server 7 > Sql server 2000 > Sql server 2005 > Sql server 2008 > > http://www.hd720i.com/Category/SQL-Server/1-1.aspx  
Other interesting topics
error logging on SQL 2008
Disk full from delete Is it collation or something else How to BKP? Why sa shows in Logins Schedule windows server and sql server reboot weekly Conversion from nvarchar to varchar Fetch 1.2 million records in 30 seconds Determine actual row size? What happens to running trace when SQL is shutdown |
|||||||||||||||||||||||
