SQL Server computer application is used to create different data applications for desktop and enterprise. The database in this computer application can include many things like triggers, tables, indexes, stored procedures, rules, etc, but, like other computer applications, the database of this application is also corruptible. In some cases, the database items of this application [...]
In SQL Server database, there are few types of pages that are used to store allocation structures. A GAM (Global Allocation Map) page is the one that has an individual bit for each extent included in the file interval that GAM page maps. Whereas, SGAM (Shared GAM) has similar structure as of GAM but has [...]
SQL Server is a powerful database: it supports multiple users with ease, and is designed to cope with databases with millions of records. However, you do pay a price for this robustness … In the belief that the easiest way to evaluate software is to concentrate on its down side (the software vendor will amply [...]
SQL Table Indexes (B-tree): Microsoft SQL Database Server supports B-tree indexes (table indexes) to provide quick query results. The pages of these B-tree indexes are called index nodes. The top node is termed as the root node, the middle nodes are called branch nodes and the bottom level nodes are denoted as the leaf nodes. [...]
A brand new Microsoft SQL technology just hit the marketplace on January 1, 2010. Or maybe it would be better to say that a rebranded Microsoft technology just hit the marketplace. Azure services is Microsoft’s most significant step into cloud computing. It functions as a complete platform in the cloud with computing, storage and fabric-tying [...]
This time we are going to let you know about an easy way of import .sql files into a MSSQL db, this feature is implemented in Recovery Toolbox for SQL Server application. Please note that Recovery Toolbox for SQL Server should not be used by unauthorized persons because the service of import .sql file creating [...]