SQL works very well for larger datasets
July 16, 2018
SQL works very well for larger datasets
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
SQL server is used by most of the teams in the organizations where I worked. It is used to store the data for the large projects especially.
- Faster in performance.
- The concept of CTE(Common table expressions) is really great.
- Temp tables works well and easy to use.
- We need to always use BEGIN TRAN to start a transaction which adds an additional step each time.
- Use of temp tables increases the performance of queries which makes to run the batch jobs faster.
My company selects SQL server for large data related projects because it can handle database backup and restore quickly.