Learn how to use the Query Editor in MS SQL Server.
The DBCC CHECKDB utility is a useful tool in MS SQL Server databases that enables you to find and repair any kind of issues in the MDF files. There are several kinds of repair clauses that help in repairing different types of problems....
Lot many times, when you work on an MS SQL Server database you would have seen some queries unable to execute even if they are correctly constructed. Most of the times, these problems arise when there are not enough memory resources for the query to be executed....
In the MS SQL Server databases, the IAM (Index Allocation Map), GAM (Global Allocation Map), SGAM (Shared GAM) are different types of pages that are used to store the records on the hard disks....
In MS SQL Server databases, the records are stored in the form of pages, which are linked to each other in a sequential manner. Because of being linked to each other, the searching and inserting new records is made easy thereby saving a lot of precious time....
In the SQL Server databases, a text index node is the one that is one level higher than the nodes in the database. In addition, it includes the text pointer in the actual data or index rows....
Lot many times, when you work on an MS SQL Server database you would have seen some queries unable to execute even if they are correctly constructed. Most of the times, these problems arise when there are not enough memory resources for the query to be executed....
In MS SQL Server databases, the records are stored in the form of pages, which are linked to each other in a sequential manner. Because of being linked to each other, the searching and inserting new records is made easy thereby saving a lot of precious time....
A PFS (Page Free Space) page in the databases has allocated one byte per page in the file interval, which is about 64 MB. Every byte in the page contains three status bits that convey the type of the page and its status as to whether it is allocated or not....
A transaction log is an important component of database which is often ignored or overlooked as it is not regularly maintained or used by the database administrators or users....
SQL Server is a Platform vision that helps your organization to manage any data, any place, and any time. By using SQL server you may store data from structured, semi-structured, and unstructured documents...