SQL Server is relational database management server whose basic purpose is to store and retrieve data as per user's request. The retrieval of data is based on structured query language (SQL). The query can be from a user on the same computer or a user across a network. There are different versions of SQL Server; the latest is SQL Server 2012 was released on March 6, 2012. The other popular ones are SQL Server 2008 R2, SQL Server 2008, SQL Server 2005 and SQL Server 2000.
SQL was written in powerful C++ programming language and now is available in many languages including English, Chinese, French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian and Spanish.
SQL Server Editions:
The different editions of SQL Server are available for different stream of users. These are
Data is stored in database in columns. Different data types are available like Integer, float, decimal, char, etc., which can store data depending upon user’s needs. Physically table is rows are stored in number of partitions. Rows are stored in each partition is in B-tree or heap structure.
To retrieve data from SQL server data, queries are used. A query can be written in many different ways. Using a single query multiple tables can be accessed. SQL buffers upto 8 KB pages in RAM.
Every database transaction executed on SQL Server must be consistent and reliable. For this SQL Server transactions satisfies ACID properties, i.e. (A-atomicity, C-consistency, I-isolation, D-durability). The ACID compliant of SQL Server makes sure when multiple clients access or modify data at a time, data integrity is maintained. The use of shared and exclusive locks ensures concurrent access thereby preventing deadlocks.
Undelete files from Windows Server 2003
SQL database files are stored as .mdf, ndf on Windows Server 2003. These files stored on your Windows server 2003 might be deleted due to many reasons unknown to user. Some possible reasons for deletion are third party utility malfunction, file system corruption or power surge. If you have lost / deleted important database files, use Remo Recover (Windows) and retrieve the files quickly.