SQL server database contains many objects such as stored procedure, views, function, triggers, etc. To secure database objects in SQL server, the user usually takes help of procedure named as encryption. After the database is encrypted, nobody can access its data without decrypting it. In fact, both encryption and decryption are equally important for Database […]
SQL database does not get corrupted frequently. But when database corruption detected, it becomes a stressful or troublesome situation for the database administrator. Most of the time SQL database corrupted due to missing patch, hacker attacks, hardware or subsystem issues. So, SQL provides a CHKDSK option to detect the problem in SQL database. However, SQL […]
“I want to view the file size of MDF file but when I tried to retrieve the data from mdf file I am getting SQL errors. I think my master database file got corrupted as my SQL Server got abnormally shutdown few days earlier. I am not sure if I am right or not in […]
Most of the organizations use an SQL server to manage their vast data. The SQL server offers both automatic shrinking and auto growing of SQL database files. It causes index fragmentation in the physical files, which leads to poor performance. To avoid this problem, you have to disable auto shrink feature in SQL Server databases. […]
Overview DBCC CHECKDB checks the physical and logical integrity of all database objects with DBCC CHECKALLOC, DBCC CHECKTABLE and DBCC CHECKCATALOG. You do not have to run these commands individually as DBCC CHECKDB integrates them all. It performs validation on database and files validates the content of every indexed view,link-level consistencies between tables and files […]
Why to Repair Clustered Index in SQL Server? A large number users of the SQL Server have to deal with a variety of problems while working with the SQL Server database. A majority of these are related to corruption of database files. As data is the essence of all the operations and forms the foundation […]
MS SQL Server has mainly four system databases they are Master database, MSDB database, Tempdb, and Model database. Master Database: The master database stores all the system level information of the SQL Server like system configuration and logging account settings. Tempdb Database: A global resource holds information of all the temporary objects like temporary tables […]
SQL Server is a Relational Database Management System that consists of large sized bulk database related to or created by users and managed by administrator(s). Passwords are the greatest element of security that are used on a variety of platforms whether servers, clients, applications, or devices. Similar is the case with SQL Server that stores […]