What is T-SQL ?
Transact-SQL is a language containing the commands that are used to administer instances of SQL Server; to create and manage all objects in an instance of SQL Server; and to insert, retrieve, modify, and delete data in SQL Server tables. Transact-SQL is an extension of the language defined in the SQL standards published by the […]
Read the rest of this entry »What is OLAP ?
Online Analytical Processing (OLAP) is by far the most complex and advanced SQL Server components. Companies are using OLAP more and more as they try to make sense of their tons of accumulated data. OLAP is used in the mysterious field called “data
Analysis,” The standard database table represents a flat matrix; SQL Server 2000 Analysis […]
Which are the different services in SQL Server ? How do you manage them ?
Replication Service: SQL Server 2000 replication enables sites to maintain multiple copies of data on different computers, in order to improve overall system performance, while ensuring that all the different copies are kept synchronized.
DTS: By using DTS, you can build data warehouses and data marts in SQL Server by importing and transferring data from multiple […]
What is the lock types supported in SQL Server ?
There could be thousands of concurrent users trying to read or modify the database, sometimes exactly the same data. If not for locking, your database would quickly lose its integrity.
The following basic types of locks are available with SQL Server:
- Shared locks: Enable users to read data but not to make modifications.
- Update locks: Prevent […]
How many groups of roles are supported in SQL Server ? Explain them
SQL Server uses roles. Two layers of access exist: access to the SQL Server and access to a database object within the server. Each can be configured separately.
There are four database roles, namely:
_ Public— Essentially anyone who has enough rights to connect to the database; the lowest role possible in terms of database permissions.
_ db_owner— […]
Explain the Physical Structure of a Database
The SQL data is stored in the database. The data is organized into logical components that are visible to user however data is stored as files on hard disk. Each SQL server has four system databases: master, temp, msdb and model and multiple user databases. How many user databases depend from organization to organization?
The fundamental […]
What are instances ? Explain each one of them ?
There can be multiple instances running in a SQL server. There are two types of instances: default instances and named instances.
A named instance simply means that you define a name for an instance during installation and that you can access the instance using this name. A default instance is the one that is default. There […]
-
Subscribe
-
Job In Companies
-
Latest Jobs- Coonvergys requires Technical Support Officers
- Wipro Walk-in for IT professionals on 20th & 21st March 2010
- Siemens Ltd. requires Software Developers
- Chandigarh Police Constable vacancy 2010
- Bank of Baroda Clerical Recruitment March2010
- IT Professionals Jobs at Schneider Electric
- Delhi ASP Developer Job Position-Orbitsys Technologies
- Web Designers & Web Developers (PHP/MySQL) Jobs: Walk-in on 12th & 13th March
- BoB Probationary Officer vacancy March2010
- IIT Indore Faculty Jobs March2010