SQL Server Reviews

Most of SQL Server High Availability and Disaster Recovery solutions. They are easy to configure and maintain.

It provides the best performance and an easy way to monitor and troubleshoot problems.

Indexing, execution plans, and the SQL Server Management Studio performance.

Over seven years.

No.

No.

Medium.

No.

Complex design, easy configuration.

It is not very expensive and is suitable for an international company, like what I am working with. Free licenses are suitable for small companies, too.

No.

Stable and easy to administrate.

The ability to browse table structures and re-design it easily.

It improved the efficiency in giving service to clients, and allowed to me make all kinds of important reports easily.

The compiler should be much more precise and give you more information about the error.

I've used it for two and a half years.

No issues encountered.

Running long and complicated queries could make the software crash. You should run them part by part instead (i.e. with stored procedures).

No issues encountered.

Customer Service:

I haven't had to contact them.

Technical Support:

They give quick, and helpful, responses. About 9/10.

This was the solution I've used.

It's pretty straightforward, and usually everything goes smoothly. Everything was user-friendly and took me a minimum amount of time to understand how everything works.

We did it in-house.

The price is pretty high, buy it's worth getting the license.

No other options were evaluated.

Personally, I love Microsoft products and I’m pleased with this one as well. I would advise you to get it.

Security, lower cost, ease of maintenance and administration, performance. When all of these are considered, our business is able to run faster, more securely, with SQL as the back-end.

The Management Studio front end still needs work as does Indexing.

14 years

No, SQL installs well.

No, SQL was stable for our applications.

No, scaling was easy with SQL. We never had an issue.

Customer Service: Do not expect Microsoft to be in a hurry to get to you, but I have always found their support to be helpful.Technical Support: I would rate the support as average.

We also used Oracle. We supported both with our application.

SQL is very easy to setup.

In-house.

We also used Oracle. We supported both with our application.

Make sure you have your prerequisites installed and the proper amount of resources dedicated. You should not have a problem.

A great database management system for all size companies. SQL server is more user friendly than competitors. Provides easy installation. If you need support or research for the product, it is easy to find help online. There are 3 editions available which will meet any companies needs. Latest version is cloud ready. Offers power and flexibility.

For each additional core feature you want to add to your DBMS edition, it is more money. This is not a FREE program as most other DBMS are. So basically, the more you want, the more you pay.

A great DBMS for organizations of all sizes. Will be my first choice for a DBMS again in the future. The installation process was simple. You will pay for this SQL Server, but don't be afraid to try the free programs also.

It's a normal DMS, so it can be used everywhere you want to use any RDBMS or relational database. It's for normal transactions.

SQL Server could integrate better with other platforms.

I've been using SQL Server for the last six months. Earlier we used DB2, but now we use this one.

SQL Server's performance is fine.

Microsoft support is fine.

We don't deal with the setup because we are developers. The system or admin team does all those things. So I don't have any idea.

I rate SQL Server eight out of 10. We haven't had any issues, but it depends on the use case. So I would recommend it depending on your use case.

On-premises

Other

We use the product for information systems. This is a must both for us. We use it for our Enterprise Portal.

The solution has proven to be very flexible.

The product is quite stable.

Overall, we've found it to be extremely easy to use. 

The initial setup is pretty straightforward. It's not difficult to implement and the deployment doesn't take too long.

Technical support has been pretty good so far. They are helpful.

It's a good option for those that have a lot of Microsoft solutions in use.

The solution needs to be more secure. It's lacking, compared to, for example, Oracle.

The product needs to work on its scalability. Oracle can scale a bit more effectively.

Sometimes we have some performance issues. It's not like Oracle. Oracle is more powerful in terms of performance. 

I've just been dealing with the solution for a few months. It hasn't been too long just yet.

We've had some performance issues overall. It's something that's a pain point for us. They need to work on their capabilities in this regard.

The solution could be more scalable. Oracle scales better for companies that need to expand.

We have two to three customers that use the solution currently.

We've used technical support in the past. They've been helpful and responsive. We haven't had any issues when we deal with them. We are quite satisfied so far with the level of service we receive when we reach out. 

I've also used Oracle in the past. From my side, Oracle is more technical and is more scalable, and more secure than the SQL server.

The installation is quite straightforward. It's not overly difficult or complicated. I found it to be quite simple.

The deployment is rather quick. It took us about one hour, from what I can recall.

We just need one technical person to handle the implementation and maintenance processes. 

Customers do have to pay to use the solution. They tend to pay on a yearly basis. 

I'd rate the solution at a seven out of ten.

I'd recommend the solution to other customers, users, and companies. It's a good option of r many. Sometimes the customer is Microsoft-oriented and sometimes they are Oracle-oriented. If the customer is already using a lot of Microsoft products, SQL just makes sense. 

On-premises

The customer's MES system  use it.  The database system desgin as always on architecture.

Like Data guard in Oracle , always on contain double data and sync data by using transactions store in transaction log

It is easy to establish, and the license price is lower than that of Oracle.  

Otherwise, our customer could can replace primary databases from Oracle into MSSQL AG

Base on  windows cluster,  the always on no needs complicated config process.

Just click and click following  GUI interface.

table partition options,  that is very useful to separate unnecessary cost. 

For legacy data,  we can do partition swith out and store into flat files or old tables.

When it necessary, we can switch in back.

Horizontal partitioning.  

In that case,  cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

Three to five years.

Sometimes , when windows server suddently failed, the database still can be turn on when DB server started.

When do "sp_rename" or "table rebuild" , the cluster index or non-cluster index no needs to rebuild at same time

Customer always comes out many questions

I have no choice. our customer choose MS SQL 

 initial setup straightforward

ordinary level

database administrator

Migration local database into cloud

No, I  have to accepted it 

subpartition is necessary

We primarily use SQL Server for reporting.

I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server.

The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions. 

I've been working with SQL Server for the past seven years. 

SQL Server is stable.

SQL Server is scalable. I can't say if we'll increase usage in the future because I'm only working here as an analyst. It's a company decision. If necessary, then I can make a recommendation. I can go for that if the client wants, so it depends entirely on our client. If the client wants Oracle instead of Microsoft, I don't have an option.

I never contacted Microsoft support about SQL Server, but I have called about Power BI one or two times. It was great support.

I rate SQL Server eight out of 10. 

Public Cloud

Microsoft Azure