SQL Server Database Tutorials

SQL Server Database Management Tutorials and Database Administration Articles
  Title / Author Reverse Sort Order Replies
Views
A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.Triggers are used to enforce data integrity and business rules such as...
12
230,718
CUBE generates a result set that represents aggregates for all combinations of values in the selected columns. CUBE automatically generates a summation rollup to the top level of a GROUP BY. Lets us look one Example. Create table #TempTable(Items varchar(30), ...
0
5,896
Concatenating data with Multiple Result(s) using FOR XML PATH Create table #TempProducts(Items Varchar(30),Colour Varchar(15)) Insert into #TempProducts values('Table','Red'); Insert into #TempProducts values('Table','Green'); Insert into #TempProducts values('Table','Blue'); Insert...
0
4,902
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,602
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,607
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
1,462
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
2,631
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
3,752
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
2,423
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
2,669
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
2,500
Expressions used in query The expression used for defining a query consists of values, and different functions. The data can be easily calculated using the queries. The expressions represent formulas which are created in form of a query. The general representation of expression is as...
0
518
The SQL Server data engine which is introduced by Microsoft. Using SQL, user can create the database and manage them. User can easily execute queries, add records to the database, update and delete data. New databases and tables are created. Procedures and views are added on different tables. ...
0
709
SQL Server management studio is used for creation and use of the database objects. The Database Engine Tuning Advisor is used for administering the database activities. The BI solutions are implemented using the SQL Server Business Intelligence development studio. SQL Server is associated with...
0
700
Modified comparison operators are used for checking the values against the specific condition which are returned from the subquery.. Modified comparison operators The comparison operators like =, < and > are used in a query. If the subquery returns more than one value, we need to apply the...
0
444
Complete details regarding the query process can be viewed using the execution plan. The execution of query through the SQL Server can be viewed using the plan. The troubleshooting method is provided for the query which has slow processing. Once the query is sent to the server, a parse tree is...
0
490
The view is an object of the database used for accessing the data from different database tables. The view does not contain data but has tabular structure. Using views, the data security can be achieved by restricting the access on specific rows and columns of the table, rows retrieved using joins,...
0
387
In SQL, the set of statements are stored permanently in a function. The functions are user defined functions. User defined functions Scalar functions Table valued functions User defined functions The user defined functions is the object of database containing statements used for used...
0
516
The cursor is used for accessing the set of records from the result set with a row at a time. The difference between T-SQL statement and a cursor is that the statement operates on all the records. The result set created contains the common rows and user needs to process the data per row. The...
0
367
The reporting services provides user with application programming interfaces and tools for the creation of reports. The reports can be easily authorized and published using these tools. User can create the environment on the current database and the web server infrastructure. User can render...
0
359