PDA

Click to See Complete Forum and Search --> : What is MSSQLServer's main purpose?

code?
October 10th, 2006, 05:42 PM
im new in the MSSQLServer, but i've had the program for 5-7 months, and i dont even know what to use it for. yea i tried to find some tutorials on just sql, but... is it for use with a program, or the web, or both, or what?
Shuja Ali
October 11th, 2006, 03:28 AM
In simple words SQL Server is a database engine/server which is used to store data. It is a well organized Relational Database Management System. To understand why we would need a RDMS take a look at
RDBMS Explained here (http://en.wikipedia.org/wiki/RDMS)
code?
October 11th, 2006, 02:07 PM
if i had a website, could i put the database on the site, and have a program the enables users that have that program to upload/send and/or download/recieve files on that database?
Shuja Ali
October 12th, 2006, 02:20 AM
if i had a website, could i put the database on the site, and have a program the enables users that have that program to upload/send and/or download/recieve files on that database?
Have you read the topics in the link that I provided. Please go through them and then see if you can anaswer your question yourself.
jstephens
October 12th, 2006, 12:28 PM
A database is used to store data that is related in some form or fation. Think of it as an oversized filing cabinet that can easily pull of the specified file.

Databases can be categorized in two ways, either oltp or olap. OLTP (online transaction processing) is basically a database that stores transactions or goods sold or bought. OLAP (Online analytical Processing) is a database that hold historical records for business analysis. OLTP databases can Be both. Say a Manager wants To look up how many widgets he sold to Brazil in this range of months. OLAP will never be a OLTP. OLAP sometimes is refered to as a Datawarehouse.

OLTP = Lots of writing and reading from the database.

OLAP = Lots of reading from database.
code?
October 12th, 2006, 01:38 PM
yea i looked at it and i got it, i just have to mess with some stuff on VC#'05 on creating databases, and ill get the hang of it.
Shuja Ali
October 13th, 2006, 02:14 AM
yea i looked at it and i got it, i just have to mess with some stuff on VC#'05 on creating databases, and ill get the hang of it.
Good. All the best :thumb: