Monthly Archives: luglio 2016

Performance Issues with Number of Virtual Log Files In SQL Server

Overview Each transaction log file is made of smaller parts, known as virtual log files. The number of virtual log files per transaction log files is not fixed. Its size is determined dynamically when the transaction log file is executed. The number of virtual log files cannot be set or configured by the database administrator. […]

Proficient Way For Giving and Removing Permissions in SQL Server

Overview While working with SQL Server Database, users has the right to assign or remove permission, to allow which user can perform particular tasks on the database. Due to security reasons, only some of the default database users such as db_owner, db_datawriter, etc. are granted access to the database. However, some database needs to be […]

Switch to our mobile site