why SQL server is more used to store database rather than
Access

Answer Posted / anilreddy

Access can store only 2 GB of data where as in SQLSERVER 2005 one column can store more than 2 GB of data

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between update lock and exclusive lock?

665


How can we call UDF(User Define Function) using C# code in ASP.net ?

6363


How do clustered indexes store data?

798


what are acid properties? : Sql server database administration

668


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

694






Does partitioning improve performance sql server?

645


What are SSL and TSL protocols?

747


What is an execution plan? When would you use it?

728


What are the types of sql server?

699


How network traffic be reduced by using the stored procedure?

774


explain different types of cursors? : Sql server database administration

751


Explain what are the events recorded in a transaction log?

737


What is the difference between Normalization and De-normalization?

778


what is the difference between Delete and Truncate command in SQL

811


What is the query and subquery?

806