469,914 Members | 2,125 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,914 developers. It's quick & easy.

SQL Server Scalability

Could someone out there please help me to answer these questions?
Thanks in advance.

1. What aspects of SQL Server allow it to reliably scale up to support
a large global enterprise? And, when does SQL Server reliability
begin to fail?

2. Given a role-based security model and without doing a benchmark,
are there potential performance issues of using a SQL Server database ?
How would this change if more of the security was moved to the
application level or moved to the database?

3. How does SQL Server manage access to data at the record and data
field level?

4. w do support and administration requirements compare between SQL
Server (or MSDE) and Oracle? Consider levels of expertise needed from
central server to desktop implementations.

Jul 23 '05 #1
1 1086
1.
http://www.microsoft.com/sql/techinf...calability.asp

2.
http://www.microsoft.com/sql/techinf...ty/default.asp

3.
http://www.microsoft.com/technet/pro.../sp3sec00.mspx

4. http://www.microsoft.com/sql/evaluat...re/default.asp

If you have more specific questions after you've reviewed the
documentation, then feel free to ask. And don't forget that having good
staff, a good design and a good implementation plan is usually far more
important than whether to pick product A or product B.

Simon

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Roger Binns | last post: by
7 posts views Thread by Murtix Van Basten | last post: by
67 posts views Thread by Mike MacSween | last post: by
6 posts views Thread by joe | last post: by
1 post views Thread by Jochen Fromm | last post: by
42 posts views Thread by Paul | last post: by
1 post views Thread by AJ | last post: by
4 posts views Thread by Smokey Grindle | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.