Coming October 25: PeerSpot Awards will be announced! Learn more

SQL Server Questions

Celes Agiriga - PeerSpot reviewer
Celes Agiriga
It Application Analyst at City of Corpus Christi
Jul 25 2022

I work as an IT Application Analyst at a governmental organization (size: 1000+ employees).

Currently, I'm researching Oracle Database and SQL Server. Which product is better and why?

Akın Kurtulan - PeerSpot reviewer
Akın Kurtulan
System Director at Türkiye İş Bankası
Jun 09 2022
Hi community members, I work as a System Engineer at a large Financial Services company. Currently, I'm trying to understand the main differences between the two Relational Databases tools: MSSQL and Oracle Multitenant Architecture? Can you share your opinion? Thanks.
Read More »
Patric Gehl - PeerSpot reviewer
Patric GehlHi Akin, First, both DBs manage your relational data on several operating… more »
3 Answers
Sudharshan Reddy - PeerSpot reviewer
Sudharshan Reddy
Project Delivery Manager at GBM
Hi peers, I'm working at a Software Solution company and I'm doing some research: I'm trying to compare SAP BW4HANA with Microsoft SQL Server and I would like to understand the pros and cons of each one.  Please share your knowledge and experience about these products with me! Thanks
Read More »
Patric Gehl - PeerSpot reviewer
Patric GehlMS SQL Server is a database;  BW4HANA is a data warehouse and a reporting tool… more »
1 Answer
Aashutosh Sharma - PeerSpot reviewer
Aashutosh Sharma
User at Sutherland Technologies

Hi,

I work at a Computer Software company with 10K+ employees. I'm researching SQL Server and SAP HANA. 

In your opinion, which is better and why?

Thanks for your help!

Ts Nurul Haszeli - PeerSpot reviewer
Ts Nurul HaszeliIt really depends on the purpose of usage. Both have strengths and limitations… more »
1 Answer
Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Mar 30 2022

Hi,

We all know it's really hard to get good pricing and cost information.

Please share what you can so you can help your peers.

Tim Lenz - PeerSpot reviewer
Tim LenzWhen looking at the cost of licensing SQL Server the most important thing is to… more »
65 Answers
Nurit Sherman - PeerSpot reviewer
Nurit Sherman
Content Specialist
PeerSpot (formerly IT Central Station)
One of the most popular comparisons on IT Central Station is SAP HANA vs SQL Server. One user says about SAP HANA, "[It] provides us with predictive capabilities for asset maintenance and real-time forecasts." Another user says about SQL Server, "While it didn’t have all the abilities of a true...
Read More »
Bonnie Harmon - PeerSpot reviewer
Bonnie HarmonI agree with the two statements below and would add: MS SQL Server: Pros:… more »
Bruce Greeff - PeerSpot reviewer
Bruce GreeffThe two are not really directly comparable. HANA DB is designed to run… more »
Dr. Victor Gonzalez - PeerSpot reviewer
Dr. Victor GonzalezDefinitively HANA is the most modern DBMS which was developed from zero… more »
6 Answers
Julia Frohwein - PeerSpot reviewer
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
Mar 30 2022

Hi Everyone,

What do you like most about SQL Server?

Thanks for sharing your thoughts with the community!

Miriam Tover - PeerSpot reviewer
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Mar 30 2022

Please share with the community what you think needs improvement with SQL Server.

What are its weaknesses? What would you like to see changed in a future version?

RogerMorera - PeerSpot reviewer
RogerMoreraThe way to make cursors and manage raw data in rows can be improved. Currently… more »
reviewer1001628 - PeerSpot reviewer
reviewer1001628They can build more performance-tuning tools in it. They can also make the stuff… more »
Don Ingerson - PeerSpot reviewer
Don IngersonMy experience with SQL Server has been doing database testing with UFT. The main… more »
94 Answers
Julia Frohwein - PeerSpot reviewer
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
Mar 30 2022

How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

Julia Frohwein - PeerSpot reviewer
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
Mar 30 2022

If you were talking to someone whose organization is considering SQL Server, what would you say?

How would you rate it and why? Any other tips or advice?

it_user752199 - PeerSpot reviewer
Project Manager - HCM Solutions at a tech vendor with 1,001-5,000 employees

Looking for a comparison of Microsoft SQL 2017 and SAP Hana.


Mordechai Danielov - PeerSpot reviewer
Mordechai DanielovSAP Hana under the full use license can support non-SAP applications that's not… more »
it_user379329 - PeerSpot reviewer
it_user379329There are several similarities b/w the relational databases. I would go with one… more »
it_user525360 - PeerSpot reviewer
it_user525360DP DHL does use both tools but the use is largely restricted by business… more »
12 Answers
it_user308226 - PeerSpot reviewer
SAP NetWeaver Implementer at a tech services company

Thanks!

it_user308529 - PeerSpot reviewer
it_user308529Hi, The answer to this question is - it depends. There are a lot of… more »
7 Answers
Avigail Sugarman - PeerSpot reviewer
Avigail Sugarman
Community Manager at PeerSpot (formerly IT Central Station)

Where do these solutions have room for improvement? What aspects are already working well?

it_user104457 - PeerSpot reviewer
Consultant at a comms service provider with 51-200 employees

I'm looking to compare SQL Server 2005 & InfoBright. What are the pros and cons of these solutions?

Thanks,

Pankaj

Ariel Lindenfeld - PeerSpot reviewer
Ariel Lindenfeld
Sr. Director of Community
PeerSpot (formerly IT Central Station)
Relational Databases Tools Questions
DLAM - PeerSpot reviewer
DLAM
User at MH
I work for a healthcare company with less than 1,000 employees. I am new to FileMaker Pro but my company uses FileMaker Pro (FM Pro) as the frontend development tool. More and more applications will be built using FM Pro.   In the long run :  1. Is FM Pro Embedded DB or MS SQL Server a better ...
Read More »
Jeremy  Cox - PeerSpot reviewer
Jeremy CoxIn general, I think that because FM is a closed system that uses its internal DB… more »
Martin Klier - PeerSpot reviewer
Martin KlierI have no experience with FileMaker, so I can't answer any FileMaker specific… more »
DenisMunger - PeerSpot reviewer
DenisMungerFileMaker pro compared to MS access: FileMaker server plays the role ms SQL… more »
10 Answers
Nurit Sherman - PeerSpot reviewer
Nurit Sherman
Content Specialist
PeerSpot (formerly IT Central Station)
Hi peers, One of the most popular comparisons on IT Central Station is IBM DB2 vs Oracle Database. What is the biggest difference between these two solutions? Which would you recommend? Thanks for your help! --Rhea
Read More »
it_user100737 - PeerSpot reviewer
it_user100737Both DB2 and Oracle are legacy relational databases. 20+ years ago you might… more »
Rehana Parvin - PeerSpot reviewer
Rehana ParvinI think -- Oracle is well known for its performance and security feature and… more »
Sydney Chidambaram - PeerSpot reviewer
Sydney ChidambaramI have worked on both, I kind of agree and disagree with the first repsonse… more »
29 Answers
Reviewer3064 - PeerSpot reviewer
Head - Server and Storage at a financial services firm with 1,001-5,000 employees
Does running Oracle 11g and 12c databases under OLTP type workload on SPARC architecture really offer performance benefits compared to a similar specification Intel based server (keeping the Core-count same to remove the licensing from the picture)?
Read More »
it_user115209 - PeerSpot reviewer
it_user115209In my experience SPARC provides far better performance than x86 based server… more »
it_user104364 - PeerSpot reviewer
it_user104364Hi, The answer for your question is a simple: yes, it performs better on the… more »
30 Answers
it_user673410 - PeerSpot reviewer
Practice Manager Business Development Central & Eastern Europe at a tech vendor with 1,001-5,000 employees

Hello, I am looking for use cases/references for embedded solutions with Informix, especially in the plant construction, manufacturing and car manufacturing / automotive supplier. 

Thanks, Milko

Ariel Lindenfeld - PeerSpot reviewer
Ariel Lindenfeld
Sr. Director of Community
PeerSpot (formerly IT Central Station)
Let the community know what you think. Share your opinions now!
it_user182115 - PeerSpot reviewer
it_user182115Backup and replication options.
Orhan Eripek - PeerSpot reviewer
Orhan EripekA single reason is not enough, we can rank the following reasons: -… more »
reviewer933993 - PeerSpot reviewer
reviewer933993Top in my list - Performance - Security
60 Answers
it_user7077 - PeerSpot reviewer
BI Expert at a tech services company with 501-1,000 employees

Any information you can share about moving to MySQL will be helpful to the community.