MSSQL

Index is an object that improves performance in the database in general. Many inexperienced database administrators or application developers create too much index thinking that …

In the database, especially during the new development phase, indexes are the most important performance providers for us. You should be familiar with the index …

One of the first things that we look at to improve performance in systems that have performance problems is the ones that finding queries that …

When you authorize logins as db_owner in the database, your disks may be full at an unexpected time. Because a login who has the db_owner …

When authorizing users in databases, you can use system-defined roles such as db_datareader, db_datawriter, db_owner, or database-level permissions, such as Execute, View Definition. If there …

Due to the principle of “minimum authority for maximum security”, we should regularly check which user is authorized on the sql server, and revoke the …

To send mail through the SQL Server, you must first configure Database Mail. You can find details in the article “How To Configure Database Mail …

SQL Server Logs and Operating System Logs(Event Logs) are logs that SQL Server Database Administrators checks on a daily basis, or use to find the …

Sometimes we need to list table sizes in SQL Server. For example, we need to find large tables before we start making Compression or before …

We can compress some tables to reduce the size of the table. I / O performance increases as data size decreases. It also increases CPU …