SQL server pivot function and automatic data table name pop up are awesome
May 18, 2018
SQL server pivot function and automatic data table name pop up are awesome
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
Microsoft SQL server is currently used only in the IT department and Data Analytics department. We mainly use it for database management. For our data analytics team, I use SQL server to write queries to produce desired tables of data
- Tables in database automatically pop up in writing SQL, makes it easier to navigate
- Has pivot functionality, so I can query pivot tables instead of making them in Excel
- Great connection to Excel in terms of exporting queries
- Windows set up time takes longer than other DB software
- Does not allow numbers in "group by" clause, users need to write the column names explicitly
- It's easy to use and have data table pop up in writing queries, that reduced time in writing codes. That also eliminate memorization of the tables.
- Using pivot function eliminate the need to export data to excel, which saves a lot of time.
SQL server is a better software because of its support by Microsoft and it's data table pop up function. Also it has pivot function that others lack.