easy to use.
contained inbuilt tools like sql profiler for performance monitoring and debugging.
security updates are easy to apply.
we can check query execution plan, helps in improving production system performance.
easily able to import and export data to excel word or any text document.
we can easily take network backups of database.
Differential backups are very easy and helpful.
we can store very large archive dta, data even older than 10 years old or more.
As interface with each sql server version 2008 , 2012 , 2014 all new ones is similar.User can easily work with new version without difficulty.
Deadlocks queries are best traceable using this software
required licensing from Microsoft.
Required good hardware for long-running queries otherwise results into sql server is busy and software lag.
take a lot of CPU resources.
All our production system using sql server for database management.
we are using this for daily deployment and upgrades of releases.