Go Back   Tech Support Forum > Microsoft Support > Windows 7 Support, Windows Vista Support

What is SQL Server?

This is a discussion on What is SQL Server? within the Windows 7 Support, Windows Vista Support forums, part of the Tech Support Forum category. (TLDR = In brief what is Microsoft SQL Server and what is it used for?) Hey, I'm no technophobe -


Closed Thread
 
Thread Tools Search this Thread
Old 04-08-2011, 12:39 PM   #1
Registered Member
 
berban's Avatar
 
Join Date: Oct 2009
Location: Worcester, MA
Posts: 18
OS: Windows 7 Professional



(TLDR = In brief what is Microsoft SQL Server and what is it used for?)

Hey,

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! :)

__________________
berban is offline  
Old 04-08-2011, 12:42 PM   #2
Moderator
- Microsoft Support
 
Join Date: Jan 2011
Location: United States
Posts: 5,003
OS: Win7, Win8, XP, Ubuntu



Microsoft SQL Server - Wikipedia, the free encyclopedia
Microsoft SQL Server 2008 R2 | Database Management System

__________________

TSF does not support assistance through email or private messages, please keep all questions in the open forum.
JMPC is offline  
Old 04-08-2011, 01:03 PM   #3
TSF-Emeritus
 
Ninjaboi's Avatar
 
Join Date: Dec 2010
Location: U.S.A., Texas
Posts: 2,047
OS: Windows XP SP3, Ubuntu 10

My System


Welcome - SQL Database Reference Material - Learn sql, read an sql manual, follow an sql tutorial, or learn how to structure an SQL query!
What is SQL? - A Word Definition From the Webopedia Computer Dictionary
SQL Tutorial
JCC Consulting, Inc. Services Page
A Gentle Introduction to SQL

Those are links you should look at. However, the best link would definitely be this one:

Let me google that for you

Enjoy!
__________________
Ninjaboi is offline  
Old 04-08-2011, 02:54 PM   #4
Registered Member
 
berban's Avatar
 
Join Date: Oct 2009
Location: Worcester, MA
Posts: 18
OS: Windows 7 Professional



Thanks for your help, these links are helpful. I guess you probably found them with google, so in that way you're doing something that I could have done myself. But, of course I have googled the topic, it was just in terms I couldn't understand.

Quote:
Originally Posted by Wikipedia
Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
Quote:
Originally Posted by Microsoft Product Overview
Microsoft SQL Server 2008 R2 is a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI).

Highlights:
- Complete information platform for applications of all sizes.
- Managed, familiar self-service BI tools.
- Support for large-scale data centers and data warehouses.
- Opportunities to build and extend applications in the cloud.
- Integration with the Microsoft Application Platform.
This honestly just doesn't help me a whole lot

Anyway, thanks for your help!!
__________________
berban is offline  
Old 04-08-2011, 07:30 PM   #5
Sr. Tech, TSF Team Emeritus Microsoft Support Staff
 
Join Date: Apr 2009
Location: Iowa
Posts: 1,097
OS: Windows 7 SP1

My System


I'm guessing your computer was built as a webserver. For a PC you don't need SQL server. I'd try to find it and just uninstall it.
__________________
mcorton is offline  
Old 04-12-2011, 12:41 AM   #6
Moderator
- Microsoft Support
Developer
 
Join Date: Feb 2010
Posts: 673
OS: Windows 7 Home Premium x64 SP1



Hello!

A little bit late I know. However, some programs do install and require SQL Server. Microsoft Office Outlook Business Contact Manager will install SQL Server 2005 Express Edition, and the list goes on, but not for very long.

Since it has turned up on your computer, there will be a program somewhere which won't be very happy!

Also, SQL Server is notorious. SQL Service Packs NEVER install successfully without assistance, it seems to me.

It all depends on what error code you have received. I would hazard a guess at the notorious D59. It isn't the most common error, but I just have a hunch that it might be (and this isn't quite just guesswork)

Richard

__________________
niemiro is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] SQL server applications?:S
So I am starting to learn SQL and PHP through w3cschool now and so far all is going great! But I am confused about something. My parents have a restaurant and the cash register they use right now is a computer with a program that uses SQL server as a database. I think. Im pretty sure my...
jasonlee91 Web Design & Development 6 03-12-2011 10:53 PM
Access to Internet lost
Hi guys, I'm working on a home network where quite regularly the internet connection drops and requires the router to be restarted. I know this is something that can happen from time to time but this is happening every few days. For this reason we swapped the modem/router for a new one to see if...
PaoloPanella Modems/Cable/DSL/Satellite 9 03-11-2011 05:55 AM
adding Application server to network
Hello, I have a dl380 g5 it has terminal server running on it and ad, it is also our applications server, it is running server 2003, SAP accounting software and it is also our file server, so I am going to add a couple server to the mix. I am planning on purchasing a g7 proliant dl 380. ...
balbert123 Networking Support 5 01-31-2011 01:42 PM
SQL Server 2000 backup and restore to imaged server
Last week I took an image of my server running sql 2000. The image was then restored to identical hardware and running fine. The original server is still live. I am now looking to switch servers but I need to restore the database to the new cloned server as the database is now about two weeks out...
PhilGT Windows Servers 0 01-24-2011 01:42 PM
Infopath + SQL Server for Browsers
Please help! Situation 1) I have Infopath, my employer has a remote SQL Server, which I'm able to access and create tables to the remote database. 2) I want to create a simple subscribe form (two text fields and a submit button), where the visitors can put their name and email, so that they...
xpsal Microsoft Office support 0 01-08-2011 10:03 AM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 03:57 AM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts