SQL Server Database Tutorials

SQL Server Database Management Tutorials and Database Administration Articles
  Title / Author Replies
Views
SQL Server B-tree indexes The indexes in SQL Server are organized in B-tree structure. B-tree means balanced tree. In B-tree, at the top there is a root node, leaf node at bottom. The indexes have two components as leaf level and non leaf level. The non leaf levels are useful for navigation....
0
1,123
SQLOS Architecture The SQLOS is the server application used for managing the operating system resources. The buffer management, scheduling, deadlock detection, exception handling, extended events, etc are managed. The operating system is called and the scheduling functions efficiently schedule...
0
1,254
SQL Server 2012 components The architecture of SQL Server database engine is as shown below: http://imgs.g4estatic.com/sql-server/2012-architecture/Fig1.jpg There are four major components in SQL Server database engine. The protocol layer, query processor, storage engine, and SQLOS. Every...
0
1,403
Report Authoring The report writing needs to plan with other activities. The considerations are audience, report structure, look and feel of report, report visibility, delivery format, used on web or desktop, etc. All these considerations are connected with each other. Parameterized reports...
0
1,272
The user interface of report builder The various parts of the report builder interface are described. User can access the report builder from Start, All Programs, and Microsoft SQL Server 2008 report builder. The report builder interface is as shown below: ...
0
1,350
The administrator is responsible for carrying the tasks like granting permissions for managing reports on the report server. The following tasks are performed by the administrator. Modify the credentials which are useful for providing access to users for managing reports with their credentials....
0
988
Report Manager Components The Report manager can be accessed from the reporting services configuration manager. The home page for the report manager is as shown below: http://imgs.g4estatic.com/sql-server/Report-Manager/Fig1.jpg The number of activities can be performed using the...
0
1,076
Report Server project template The report server project creates two blank folders as Shared Data sources and reports. User can start creating the report. In the Shared Data Sources folder, the following options are available. Add New Data Source: It provides the shared data source window...
0
1,078
The Report in Visual Studio can be created by using the links to the report wizard provided by the viewer control. There are two types of ReportViewer controls in Visual Studio toolbox as mentioned below: ReportViewer Web server control for ASP.NET pages used for web hosting Report Viewer...
0
978
Architectural components In SQL Server Reporting services 2005, there are two services as windows service and web service. The windows service was responsible for report processing, scheduling, and delivery, database maintenance, and extensibility. The web service worked with SOAP, URL access. ...
1
1,240
The CREATE SEQUENCE command is used for creating the sequence in SQL server. CREATE SEQUENCE sequence_name } | { NO MINVALUE } ] } | { NO MAXVALUE } ]
0
1,347
1. Information about user There are requirements when user wants to know that who is connected to the SQL Server. The T-SQL provides the stored procedure sp_who. It helps know who all are connected to the to the computer. The syntax for the stored procedure is as mentioned below: sp_who...
0
1,665
User needs to create and manage the indexes in SQL Server. There are various types of indexes in SQL server. We shall explore in detail about the indexes in SQL Server. An index is a structure associated with the SQL Server for implementing the indexes on the tables. It enables faster data...
0
1,765
There are certain conditions when either all the statements are executed successfully or none of them are executed. The data integrity is maintained by the user. The SQL Server helps user to maintain the integrity of data. There are several sources accessing a single resource at a time. To prevent...
0
1,679
In SQL Server, the LIKE operator is used for searching the text value in a particular column. The synonyms and antonyms of the specific word are searched using the full text search. The full text search feature is the default and enabled in SQL Server. In this article, we shall learn about the full...
0
1,730
Several databases are supported by the SQL Server. There are some standard system databases provided by SQL Server. The system database contains some server specific configurations and templates for the database. They have some temporary storage for querying the database. The list of databases...
0
1,595
The Service Broker helps users for creating services that can be used for sending and receiving messages. Service is used as a database object. It helps user by creating an endpoint for conversation. The following diagram shows the asynchronous messages to be communicated in Service Broker. ...
0
1,481
It is a markup language that is used for describing the data structure in a hierarchical manner. The data can be saved and retrieved in an XML format in SQL Server. Several database applications are supported. Storing XML Data in a Table The data in an XML format can be XML fragments or XML...
0
1,051
User can create the programs supported by the .NET supported languages using the CLR integration with the SQL Server. The managed code can be defined as the code written and supported with any .NET programming language. Let us take an overview of the details of the CLR integration through SQL...
0
1,189
A trigger is a stored procedure used to execute the statements when an event is raised. The trigger is used statements for actions like insert, delete or update the data. The basics about triggers in sql server is here. In this article we will discuss about several trigger types used for...
0
1,527