(TLDR = In brief what is Microsoft SQL Server and what is it used for?)
I'm no technophobe - I'm pretty computer savvy, especially when it comes to all things microsoft. But one thing has continued to befuddle me recently, and this is Microsoft SQL Server.
First, on my home PC (Windows 7 Pro), Windows Update continually tried and failed to install a 300mb update for SQL server, a program I'd never heard of. So I looked in add/remove programs to see if I could repair the previous installation and found roughly 15 entries related to SQL Server, none of which would either uninstall or repair. Eventually I used Revo Uninstaller
to uninstall all of 'em, with no adverse effects to date.
Now, at work (Windows XP), a colleague has been experiencing problems with recurring prompts to install SQL server updates. It's not enough of a problem to call tech-support for, but it is a pain. Meanwhile on my machine, I noticed that sqlservr.exe is by far the most memory-intensive process, using 330mb. I do fairly intensive work on my old machine - mass data processing, not just outlook and word - so any extra fat I can trim potentially helps me go home earlier each day :)
Anyway - sorry for the aggressive title of this post, hehe, but if someone could explain what SQL server is and what it's used for, it would greatly help to satiate my curiousity. Why do I find it on my home PC, and was it safe to remove it thereof? Also, what might its purpose be on a networked office PC, and would it be safe at all to disable the messages that are popping up? I know it has something to do with databases, but alas, that's it :P
Thank you very much in advance! :)