Microsoft SQL Server Reviews & Product Details

I like very much to be able to manage the SQL database because it has a very good flexibility, it is one of the most secure database, it still has an excellent security tool, Baseline Security Analyze that is very good in security. Review collected by and hosted on G2.com.

some of the problems I noticed in sql, it was connection errors, sometimes it does not connect the database, and also problems with some performance problems, this problem also sometimes happens, I think it should analyze and correct. Review collected by and hosted on G2.com.

Processing capacity and volume of information that can be stored, has the ability to run scheduled tasks, integration with reporting services and has a graphical environment for create database schemas,is an ideal database engine to work with relational models, is optimal, fast, stable, secure and supports large amounts of information Review collected by and hosted on G2.com.

Queries of a gigantic volume of information cause that the Log of the database is filled considerably Review collected by and hosted on G2.com.

MS SQL Server is a very robust database platform allowing complex queries to be executed Review collected by and hosted on G2.com.

SQL Server uses a lot of resources compared to other database applications Review collected by and hosted on G2.com.

The read and write scripts along with the stored procedure and the query execution is really well with MS SQL compared to other products. We have been using it since the 2012 version and all of them are going really good. With the regular security patches from Microsoft, it helps keep the DB secure as well Review collected by and hosted on G2.com.

Sometimes when you have Stored procedures which are written in SQL 2012 version when they are compared in 2014 or the current version we see there is a significant change in IO operations and read write operations processing time, we have to record and verify that and identify which querry is now taking more time compared to native. This should be taken care by Microsoft Review collected by and hosted on G2.com.

Over the years, Microsoft finally figured out that MS SQL should run in more places - not just in Windows Server, but regular Windows and now Linux. So now you can just run whatever your platform is, and put MS SQL on it. It even has support for Macs if you can get through that process too.

The management platform is probably one of the most user friendly out there. Click, set this up, add a table, call it a day. Review collected by and hosted on G2.com.

Some things are still esoteric, and you'll have to start looking up basic things. Like "Why can't I log into the machine and need a Windows account" or "How do I do auto-increment"? It's not difficult to figure out, but it's things that should have a "Hi, if you're using this for the first time, these are some things to look for." Review collected by and hosted on G2.com.

Its easy to use and is snappy. Analytical operations can also be performed. Its easy to use and is snappy. Analytical operations can also be performedIts easy to use and is snappy. Analytical operations can also be performed Review collected by and hosted on G2.com.

Large queries take too much time to compute. Designing and altering a table is quite tediousLarge queries take too much time to compute. Designing and altering a table is quite tediousLarge queries take too much time to compute. Designing and altering a table is quite tediousLarge queries take too much time to compute. Designing and altering a table is quite tediousLarge queries take too much time to compute. Designing and altering a table is quite tedious Review collected by and hosted on G2.com.

common use. MS SQL is commonly used many places, so skills learned are widely useful. Review collected by and hosted on G2.com.

the licensing. having an Azure virtual server with SQL web, and then decide it's better hosted on our own hardware, only to find out you can't run SQL web yourself and the cost for the SQL license is more than the cost of the virtual server for years. But the SQL database is just a bit bigger than allowed under SQL express. Review collected by and hosted on G2.com.

MSSQL is a great addition if you're already using the Microsoft stack. It integrates natively with their tools and offers standard DBMS syntax. Review collected by and hosted on G2.com.

Does not work well with my full technology stack, including Linux machines and various cloud technologies. There are also less tutorials available for MSSQL. Review collected by and hosted on G2.com.

It can handle a larger dataset easily, It is easy to manage, manipulate and use the data on a regular basis,

more if it is used with the MSBI(SSDT) it becomes more fun to transform data by creating packages and deploying on the server further if the task is more over regular it can be scheduled on requirement basis.

It can answer your business question in very less time, reporting becomes easy for a larger dataset with Microsoft SQL It won't take much time to learn if you know the basic fundamentals of the data, Review collected by and hosted on G2.com.

It takes much time to run your queries if not structure of the table is not properly optimized, the query performance degrades as the data increases, setting up the SQL server and working around the access is a very painful job, one without a good experience will not be able to deploy,there should be a built-in queries or the syntaxes, so every time there is no need to search for the solution if we get an error. Review collected by and hosted on G2.com.

The most popular DB running on windows operating systems

Data Bases supports by almost every windows based software (some of software integrate MS SQL in the installation package)

Easy to setup (any release)

Has different types of installation packages (online, downloaded)

Management Studio also has no problems with connecting to different types of DB

Biggest support community

Can be optimized by different systems used this DB

Not uses many resources

Has free version (up to 10 GB of memory) Review collected by and hosted on G2.com.

While installing needs internet connection

Different reduction of DB versions suits different to systems, used DB

Database constantly improves and users community solve and share troubleshooting experience of any issue

Support engineers also helps you Review collected by and hosted on G2.com.