Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / murtaza

1.sql server supports Relational database Management Systems
whereas access does not support all the features of RDBMS.
2.sql server 2005 supports partitioning,bcp utility,Data
transformation services(DTS),SSIS which r not supported by
access
3.sql server 2005 supports crystal reports for reporting
services and can be use as an BI tool for OLAP Queries
access does not support crystal reports and does not support
BI tool.
4.sql server supports more large and mid size data processing
and access does not support volumnous data.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

More SQL Server Interview Questions

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

How do I perform an unattended install of sql server 2000?

0 Answers  

How to loop through the result set with @@fetch_status?

0 Answers  

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

What the different components in replication and what is their use?

0 Answers  

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

0 Answers   TCS,

What are group functions in query statements in ms sql server?

0 Answers  

What is intellisense?

0 Answers  

How to return the second 5 rows in ms sql server?

0 Answers  

How to create an inline table-valued function?

0 Answers  

What are the two types of concurrency?

4 Answers  

What are views used for?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories