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 is the partitioning method?

0 Answers  

what is a traditional network library for sql servers? : Sql server database administration

0 Answers  

What is mean by candidate key?

0 Answers  

Does partitioning help performance?

0 Answers  

What is Right Outer Join?

2 Answers  

Define normalisation?

0 Answers  

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

What is isnull() operator?

0 Answers  

What is an indexing strategy?

0 Answers  

Explain query editor regions

0 Answers  

For more SQL Server Interview Questions Click Here
Categories