SQL Server Database Tutorials

SQL Server Database Management Tutorials and Database Administration Articles
  Title / Author Replies Reverse Sort Order
Views
Introduction I had a complex SQL query that was used to extract data from my system and send it across via web request to an external system. The query was taking unduly longer time to run. I made few changes to the query structure and reduced it run time to 7 mins. A part of the main query...
20
13,225
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
229,924
There are many occasions where if someone updates a records or even deletes a record we need to keep the Audit trails of the record updated or deleted or even keep a history of records as what are the updates that happened on the database as well as what are the records deleted from the table. In...
10
28,163
Introduction This article deals with parsing techniques involved in executing the sql server query. Nowadays, stored procedures forms a strong back ground in accessing the database. Why is it so???? how it's related to my query parsing technique Background If we think about the query...
8
13,624
Introduction Stored procedures are special objects available in sql server. Its a precompiled statements where all the preliminary parsing operations are performed and the statements are ready for execution. Its very fast when compared to ordinary sql statements where the sql...
6
158,168
What is SMO? SQL Server Management Objects (SMO) is a collection of objects that are designed for programming all aspects of managing Microsoft SQL Server. SMO Overview SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server. You can...
6
22,187
SQL Server implements Client/Server technology.A number of client send queries to the Central Server.The server after receiving the query request,parses it for syntax errors and process the request.Since the query passes from the client to the server through the network it adds to network...
6
12,956
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,859
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,380
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,518
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,367
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,320
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,558
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,411
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
405
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
586
There are several data types defined in SQL. It is necessary for the user to understand different data types available in SQL Numeric data types Date and Time types String Data types Unicode character string types Binary Data types Miscellaneous data types
0
458
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
617
The various SQL Server operators are as listed below: Comparison operators Arithmetic operators Logical operators Negation operators Arithmetic operators
0
481
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
322