Row limit

Can a MS Sql table hold 5 million records
Yes.
You will need adequate hardware and good structure and indexes, but 5M rows
is well within SQL maximum capacity limits.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"MikeB" <mbercu@.g1sg.com> wrote in message
news:D7E7356A-921E-4817-8DED-8B82ACFB7A81@.microsoft.com...
> Can a MS Sql table hold 5 million records
|||It can hold waaaaay more than that. :-)
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"MikeB" <mbercu@.g1sg.com> wrote in message
news:D7E7356A-921E-4817-8DED-8B82ACFB7A81@.microsoft.com...
Can a MS Sql table hold 5 million records
|||SQL Server does not have a row limit... this will be based mostly on your
hardware. Please read http://www.aspfaq.com/2345
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"MikeB" <mbercu@.g1sg.com> wrote in message
news:D7E7356A-921E-4817-8DED-8B82ACFB7A81@.microsoft.com...
> Can a MS Sql table hold 5 million records
|||We have 2.5 million in a health claim table - back in the mainframe days
reports could run for hours. SQL handles queries against this table in
seconds. We stayed on the Digital VAX mainframe till SQL2K came along.
Whenever a query doesn't work the way we want, we look at index issues -
that has always corrected odd behavior.
We have used INDEX HINTS in some queries - and they also help...
Even queries not against indexed scans still work in under a minute.
"MikeB" <mbercu@.g1sg.com> wrote in message
news:D7E7356A-921E-4817-8DED-8B82ACFB7A81@.microsoft.com...
> Can a MS Sql table hold 5 million records
|||Hi,
There is no limitation of ROWS in SQL Server. But to store this you should
have adequate hard disk space.
As well as during retrieval you must have adequate Indexes to make the
retrieval faster.
Note:
If you have mutiple disk controllers you can create filegroups in which data
is ponted towards one disk controller and index against other. This will
reduce the I/O and executes the query faster.
Thanks
Hari
MCDBA
"MikeB" <mbercu@.g1sg.com> wrote in message
news:D7E7356A-921E-4817-8DED-8B82ACFB7A81@.microsoft.com...
> Can a MS Sql table hold 5 million records