ms sql server
-
AND conditions in SQL Server
in sql server, the and condition (or and operator) is used to test two or more conditions.
-
The ORDER BY clause in SQL Server
the order by clause is used to filter records in the result set.
-
WHERE clause in SQL Server
in sql server) t-sql), the where clause is used to filter results from select, insert, update, or delete statements.
-
Comparison operators in SQL Server
this article will show the comparison operators that are used to check for equilibrium along with more advanced operators in sql server.
-
The FROM clause in SQL Server
the sql server from clause (t-sql) is used to list the necessary tables in the sql server query.
-
Analysis services in MS SQL Server
this service is used to analyze a large amount of data and for businesses to make decisions.
-
Integrated services in MS SQL Server
integrated services are used to implement etl (extraction, transform and load data) and administrator jobs.
-
Execution Plans - Execution plan in MS SQL Server
the execution plan is created using the query optimizer with the help of statistics, the algebrizer / process tree.
-
Reporting service in MS SQL Server
the report is a presentationable component.
-
High Availability - Availability of MS SQL Server
basically, there are 5 options to set up database availability in ms sql server.
-
How to start and stop services in MS SQL Server
ms sql server brings two main services for creating and maintaining databases (csdl). there are also additional services for other purposes.
-
Database monitoring in MS SQL Server
monitoring refers to checking the database status (database), setting the owner name, file name, file size, backup schedule ...